using?System;

using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?LoginDataServer
{
????public?partial?class?Form1?:?Form
????{
????????///?

????????///?數(shù)據(jù)庫鏈接字符串
????????///?

????????private?string?_strConnectionString?=?string.Empty;

????????///?

????????///?數(shù)據(jù)庫連接對(duì)象
????????///?

????????private?SqlConnection?_sqlConnection?=?null;

????????///?

????????///?數(shù)據(jù)庫連接適配器
????????///?

????????private?SqlDataAdapter?_sqlDataAdapter?=?null;

????????///?

????????///?數(shù)據(jù)庫批量操作對(duì)象
????????///?

????????private?SqlCommandBuilder?_sqlCommandBuilder?=?null;

????????///?

????????///?數(shù)據(jù)庫緩存
????????///?

????????private?DataSet?_ds?=?null;

????????///?

????????///?
????????///?

????????public?Form1（）
????????{
????????????InitializeComponent（）;

????????????_strConnectionString?=?textBox_connectionString.Text.Trim（）;
????????????_sqlConnection?=?new?System.Data.SqlClient.SqlConnection（_strConnectionString）;

????????????_sqlDataAdapter?=?new?SqlDataAdapter（）;
????????????_sqlDataAdapter.SelectCommand?=?new?SqlCommand（“SELECT?ASM_A1_10?AS?資產(chǎn)ID?ASM_A1_20?AS?資產(chǎn)編號(hào)?ASM_A1_9995?AS?日期時(shí)間?FROM?ASM_A1“?_sqlConnection）;

????????????_ds?=?new?DataSet（）;
????????????_sqlCommandBuilder?=?new?System.Data.SqlClient.SqlCommandBuilder（）;
????????}

????????///?

????????///?執(zhí)行增加操作
????????///?

????????private?void?DoInsert（）
????????{
????????????try
????????????{
????????????????string?_id?=?string.Empty;
????????????????_id?=?textBox_id.Text.Trim（）;

????????????????string?_code?=?string.Empty;
????????????????_code?=?textBox_code.Text.Trim（）;

????????????????string?_datetime?=?string.Empty;
????????????????_datetime?=?textBox_dt.Text.Trim（）;

????????????????if?（string.IsNullOrEmpty（_code）
????????????????????||string.IsNullOrEmpty（_datetime））
????????????????{
????????????????????MessageBox.Show（“請(qǐng)輸入完整！“）;
????????????????????return;
????????????????????
????????????????}

????????????????if?（CheckCode（_code））
????????????????{
????????????????????MessageBox.Show（“資產(chǎn)編號(hào)重復(fù)！“）;

????????????????????textBox_code.Focus（）;
????????????????????textBox_code.SelectAll（）;
????????????????????
????????????????????return;
????????????????}

????????????????_id?=?GetMaxId（）;

????????????????SaveData（_id?_code?_datetime）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????throw?ex;
????????????}????????
????????}

????????///?

????????///?獲取資產(chǎn)ID最大值
????????///?

????????///?
????????private?string?GetMaxId（）
????????{
????????????string?_strResult?=?string.Empty;

????????????try
????????????{
????????????????using?（SqlConnection?_sqlConnection?=?

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-12-06?13:49??LoginDataServer\
?????文件????????1101??2011-12-01?13:52??LoginDataServer.sln
?????文件???????17408??2011-12-06?13:54??LoginDataServer.suo
?????文件????????1406??2011-12-06?13:40??LoginDataServer\App.ico
?????目錄???????????0??2011-12-06?13:40??LoginDataServer\bin\
?????目錄???????????0??2011-12-06?13:49??LoginDataServer\bin\Debug\
?????文件???????19456??2011-12-06?13:49??LoginDataServer\bin\Debug\LoginDataServer.exe
?????文件???????32256??2011-12-06?13:49??LoginDataServer\bin\Debug\LoginDataServer.pdb
?????文件??????191248??2005-09-03?06:55??LoginDataServer\bin\Debug\System.Data.SqlClient.dll
?????文件?????????108??2005-07-15?22:35??LoginDataServer\bin\Debug\System.Data.SqlClient.xml
?????文件???????18091??2011-12-06?13:49??LoginDataServer\Form1.cs
?????文件???????10686??2011-12-06?13:35??LoginDataServer\Form1.Designer.cs
?????文件????????6298??2011-12-06?13:35??LoginDataServer\Form1.resx
?????文件????????4302??2011-12-06?13:48??LoginDataServer\LoginDataServer.csproj
?????文件?????????236??2011-12-02?09:44??LoginDataServer\LoginDataServer.csproj.user
?????目錄???????????0??2011-12-01?13:52??LoginDataServer\obj\
?????目錄???????????0??2011-12-06?13:49??LoginDataServer\obj\Debug\
?????文件????????1398??2011-12-06?13:49??LoginDataServer\obj\Debug\LoginDataServer.csproj.FileListAbsolute.txt
?????文件?????????847??2011-12-06?13:49??LoginDataServer\obj\Debug\LoginDataServer.csproj.GenerateResource.Cache
?????文件???????19456??2011-12-06?13:49??LoginDataServer\obj\Debug\LoginDataServer.exe
?????文件?????????180??2011-12-06?13:49??LoginDataServer\obj\Debug\LoginDataServer.Form1.resources
?????文件???????32256??2011-12-06?13:49??LoginDataServer\obj\Debug\LoginDataServer.pdb
?????文件?????????180??2011-12-06?13:49??LoginDataServer\obj\Debug\LoginDataServer.Properties.Resources.resources
?????目錄???????????0??2011-12-01?14:58??LoginDataServer\obj\Debug\Refactor\
?????文件????????9381??2011-12-06?13:49??LoginDataServer\obj\Debug\ResolveAssemblyReference.cache
?????目錄???????????0??2011-12-01?13:52??LoginDataServer\obj\Debug\TempPE\
?????文件?????????362??2011-12-01?13:52??LoginDataServer\Program.cs
?????目錄???????????0??2011-12-01?13:52??LoginDataServer\Properties\
?????文件????????1439??2011-12-01?13:52??LoginDataServer\Properties\AssemblyInfo.cs
?????文件????????2367??2011-12-01?13:52??LoginDataServer\Properties\Resources.Designer.cs
?????文件????????5618??2011-12-01?13:52??LoginDataServer\Properties\Resources.resx
............此處省略0個(gè)文件信息