www.pudn.com > CRM.rar > Form1.cs
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using Word;
namespace WindowsApplication1
{
///
/// Form1 的摘要说明。
///
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.DateTimePicker dateTimePicker1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.ListView listView1;
private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
private System.Data.SqlClient.SqlConnection sqlConnection1;
private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Button button4;
//private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter2;
private System.Data.SqlClient.SqlCommand sqlSelectCommand2;
private System.Data.SqlClient.SqlCommand sqlInsertCommand2;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand2;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand2;
private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter2;
private System.Data.SqlClient.SqlCommand sqlSelectCommand3;
private System.Data.SqlClient.SqlCommand sqlInsertCommand3;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand3;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand3;
private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter3;
private System.Data.SqlClient.SqlCommand sqlSelectCommand4;
private System.Data.SqlClient.SqlCommand sqlInsertCommand4;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand4;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand4;
private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter4;
private System.Data.SqlClient.SqlCommand sqlSelectCommand5;
private System.Data.SqlClient.SqlCommand sqlInsertCommand5;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand5;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand5;
private System.Windows.Forms.StatusBar statusBar1;
private System.Windows.Forms.ProgressBar progressBar1;
private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter5;
private System.Data.SqlClient.SqlCommand sqlSelectCommand6;
private System.Data.SqlClient.SqlCommand sqlInsertCommand6;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand6;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand6;
///
/// 必需的设计器变量。
///
private System.ComponentModel.Container components = null;
public Form1()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
///
/// 清理所有正在使用的资源。
///
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
///
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
///
private void InitializeComponent()
{
this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker();
this.button1 = new System.Windows.Forms.Button();
this.listView1 = new System.Windows.Forms.ListView();
this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.button2 = new System.Windows.Forms.Button();
this.textBox1 = new System.Windows.Forms.TextBox();
this.button3 = new System.Windows.Forms.Button();
this.button4 = new System.Windows.Forms.Button();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlDataAdapter2 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlDataAdapter3 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand4 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand4 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand4 = new System.Data.SqlClient.SqlCommand();
this.sqlDataAdapter4 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand5 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand5 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand5 = new System.Data.SqlClient.SqlCommand();
this.statusBar1 = new System.Windows.Forms.StatusBar();
this.progressBar1 = new System.Windows.Forms.ProgressBar();
this.sqlDataAdapter5 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand6 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand6 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand6 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand6 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// dateTimePicker1
//
this.dateTimePicker1.Location = new System.Drawing.Point(32, 40);
this.dateTimePicker1.MaxDate = new System.DateTime(2005, 12, 31, 0, 0, 0, 0);
this.dateTimePicker1.MinDate = new System.DateTime(2005, 1, 1, 0, 0, 0, 0);
this.dateTimePicker1.Name = "dateTimePicker1";
this.dateTimePicker1.TabIndex = 0;
this.dateTimePicker1.Value = new System.DateTime(2005, 12, 31, 0, 0, 0, 0);
//
// button1
//
this.button1.Location = new System.Drawing.Point(48, 336);
this.button1.Name = "button1";
this.button1.TabIndex = 1;
this.button1.Text = "button1";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// listView1
//
this.listView1.Location = new System.Drawing.Point(16, 8);
this.listView1.MultiSelect = false;
this.listView1.Name = "listView1";
this.listView1.Size = new System.Drawing.Size(440, 24);
this.listView1.TabIndex = 2;
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "client", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("id", "id"),
new System.Data.Common.DataColumnMapping("name", "name"),
new System.Data.Common.DataColumnMapping("coding", "coding"),
new System.Data.Common.DataColumnMapping("country", "country"),
new System.Data.Common.DataColumnMapping("country_number", "country_number"),
new System.Data.Common.DataColumnMapping("province", "province"),
new System.Data.Common.DataColumnMapping("area_number", "area_number"),
new System.Data.Common.DataColumnMapping("city", "city"),
new System.Data.Common.DataColumnMapping("post_number", "post_number"),
new System.Data.Common.DataColumnMapping("address", "address"),
new System.Data.Common.DataColumnMapping("phone_number", "phone_number"),
new System.Data.Common.DataColumnMapping("fax", "fax"),
new System.Data.Common.DataColumnMapping("www_address", "www_address"),
new System.Data.Common.DataColumnMapping("income", "income"),
new System.Data.Common.DataColumnMapping("type", "type"),
new System.Data.Common.DataColumnMapping("source", "source"),
new System.Data.Common.DataColumnMapping("state", "state"),
new System.Data.Common.DataColumnMapping("employee_num", "employee_num")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "[clinetDeleteCommand]";
this.sqlDeleteCommand1.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_address", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "address", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_area_number", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "area_number", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_city", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "city", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_coding", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "coding", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_country", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "country", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_country_number", System.Data.SqlDbType.VarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "country_number", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_employee_num", System.Data.SqlDbType.BigInt, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "employee_num", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_fax", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fax", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_income", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "income", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "name", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_phone_number", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "phone_number", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_post_number", System.Data.SqlDbType.VarChar, 7, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "post_number", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_province", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "province", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_source", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "source", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_type", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "type", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_www_address", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "www_address", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=LN;packet size=4096;user id=sa;pwd=1;data source=\".\";persist secur" +
"ity info=False;initial catalog=CRM";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "[clinetInsertCommand]";
this.sqlInsertCommand1.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar, 50, "name"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@coding", System.Data.SqlDbType.VarChar, 10, "coding"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@country", System.Data.SqlDbType.VarChar, 50, "country"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@country_number", System.Data.SqlDbType.VarChar, 3, "country_number"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@province", System.Data.SqlDbType.VarChar, 10, "province"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@area_number", System.Data.SqlDbType.VarChar, 4, "area_number"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@city", System.Data.SqlDbType.VarChar, 50, "city"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@post_number", System.Data.SqlDbType.VarChar, 7, "post_number"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@address", System.Data.SqlDbType.VarChar, 50, "address"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@phone_number", System.Data.SqlDbType.VarChar, 10, "phone_number"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@fax", System.Data.SqlDbType.VarChar, 10, "fax"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@www_address", System.Data.SqlDbType.VarChar, 50, "www_address"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@income", System.Data.SqlDbType.Money, 8, "income"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@type", System.Data.SqlDbType.VarChar, 10, "type"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@source", System.Data.SqlDbType.VarChar, 10, "source"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@state", System.Data.SqlDbType.NVarChar, 1073741823, "state"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@employee_num", System.Data.SqlDbType.BigInt, 8, "employee_num"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "[clinetSelectCommand]";
this.sqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "[clinetUpdateCommand]";
this.sqlUpdateCommand1.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar, 50, "name"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@coding", System.Data.SqlDbType.VarChar, 10, "coding"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@country", System.Data.SqlDbType.VarChar, 50, "country"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@country_number", System.Data.SqlDbType.VarChar, 3, "country_number"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@province", System.Data.SqlDbType.VarChar, 10, "province"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@area_number", System.Data.SqlDbType.VarChar, 4, "area_number"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@city", System.Data.SqlDbType.VarChar, 50, "city"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@post_number", System.Data.SqlDbType.VarChar, 7, "post_number"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@address", System.Data.SqlDbType.VarChar, 50, "address"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@phone_number", System.Data.SqlDbType.VarChar, 10, "phone_number"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@fax", System.Data.SqlDbType.VarChar, 10, "fax"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@www_address", System.Data.SqlDbType.VarChar, 50, "www_address"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@income", System.Data.SqlDbType.Money, 8, "income"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@type", System.Data.SqlDbType.VarChar, 10, "type"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@source", System.Data.SqlDbType.VarChar, 10, "source"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@state", System.Data.SqlDbType.NVarChar, 1073741823, "state"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@employee_num", System.Data.SqlDbType.BigInt, 8, "employee_num"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_address", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "address", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_area_number", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "area_number", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_city", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "city", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_coding", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "coding", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_country", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "country", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_country_number", System.Data.SqlDbType.VarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "country_number", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_employee_num", System.Data.SqlDbType.BigInt, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "employee_num", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_fax", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fax", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_income", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "income", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "name", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_phone_number", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "phone_number", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_post_number", System.Data.SqlDbType.VarChar, 7, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "post_number", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_province", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "province", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_source", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "source", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_type", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "type", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_www_address", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "www_address", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int, 4, "id"));
//
// dataGrid1
//
this.dataGrid1.BackgroundColor = System.Drawing.SystemColors.Menu;
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(64, 88);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(528, 168);
this.dataGrid1.TabIndex = 3;
//
// button2
//
this.button2.Location = new System.Drawing.Point(272, 336);
this.button2.Name = "button2";
this.button2.TabIndex = 4;
this.button2.Text = "修改";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(584, 56);
this.textBox1.Name = "textBox1";
this.textBox1.TabIndex = 5;
this.textBox1.Text = "textBox1";
//
// button3
//
this.button3.Location = new System.Drawing.Point(504, 328);
this.button3.Name = "button3";
this.button3.TabIndex = 6;
this.button3.Text = "word";
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// button4
//
this.button4.Location = new System.Drawing.Point(640, 328);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(96, 23);
this.button4.TabIndex = 7;
this.button4.Text = "updatelinkman";
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "[linkmanSelectCommand]";
this.sqlSelectCommand2.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlSelectCommand2.Connection = this.sqlConnection1;
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "[linkmanInsertCommand]";
this.sqlInsertCommand2.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar, 50, "name"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@client", System.Data.SqlDbType.VarChar, 50, "client"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@department", System.Data.SqlDbType.VarChar, 50, "department"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@area", System.Data.SqlDbType.VarChar, 50, "area"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@mobile_phone", System.Data.SqlDbType.VarChar, 50, "mobile_phone"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@province", System.Data.SqlDbType.VarChar, 10, "province"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@city", System.Data.SqlDbType.VarChar, 50, "city"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@address", System.Data.SqlDbType.NVarChar, 1073741823, "address"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@office_phone", System.Data.SqlDbType.VarChar, 50, "office_phone"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@house_phone", System.Data.SqlDbType.VarChar, 50, "house_phone"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@fax", System.Data.SqlDbType.VarChar, 50, "fax"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@email", System.Data.SqlDbType.VarChar, 50, "email"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@avocation", System.Data.SqlDbType.NVarChar, 1073741823, "avocation"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_day", System.Data.SqlDbType.DateTime, 8, "memory_day"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@brithday", System.Data.SqlDbType.DateTime, 8, "brithday"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@bri_math", System.Data.SqlDbType.Int, 4, "bri_math"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@bri_day", System.Data.SqlDbType.Int, 4, "bri_day"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory__math", System.Data.SqlDbType.Int, 4, "memory__math"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_day1", System.Data.SqlDbType.Int, 4, "memory_day1"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_descript", System.Data.SqlDbType.NVarChar, 50, "memory_descript"));
//
// sqlUpdateCommand2
//
this.sqlUpdateCommand2.CommandText = "[linkmanUpdateCommand]";
this.sqlUpdateCommand2.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlUpdateCommand2.Connection = this.sqlConnection1;
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar, 50, "name"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@client", System.Data.SqlDbType.VarChar, 50, "client"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@department", System.Data.SqlDbType.VarChar, 50, "department"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@area", System.Data.SqlDbType.VarChar, 50, "area"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@mobile_phone", System.Data.SqlDbType.VarChar, 50, "mobile_phone"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@province", System.Data.SqlDbType.VarChar, 10, "province"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@city", System.Data.SqlDbType.VarChar, 50, "city"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@address", System.Data.SqlDbType.NVarChar, 1073741823, "address"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@office_phone", System.Data.SqlDbType.VarChar, 50, "office_phone"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@house_phone", System.Data.SqlDbType.VarChar, 50, "house_phone"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@fax", System.Data.SqlDbType.VarChar, 50, "fax"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@email", System.Data.SqlDbType.VarChar, 50, "email"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@avocation", System.Data.SqlDbType.NVarChar, 1073741823, "avocation"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_day", System.Data.SqlDbType.DateTime, 8, "memory_day"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@brithday", System.Data.SqlDbType.DateTime, 8, "brithday"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@bri_math", System.Data.SqlDbType.Int, 4, "bri_math"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@bri_day", System.Data.SqlDbType.Int, 4, "bri_day"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory__math", System.Data.SqlDbType.Int, 4, "memory__math"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_day1", System.Data.SqlDbType.Int, 4, "memory_day1"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_descript", System.Data.SqlDbType.NVarChar, 50, "memory_descript"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_area", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "area", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_bri_day", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "bri_day", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_bri_math", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "bri_math", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_brithday", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "brithday", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_city", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "city", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_client", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "client", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_department", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "department", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_email", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "email", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_fax", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fax", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_house_phone", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "house_phone", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory__math", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "memory__math", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory_day", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "memory_day", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory_day1", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "memory_day1", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory_descript", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "memory_descript", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_mobile_phone", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "mobile_phone", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "name", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_office_phone", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "office_phone", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_province", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "province", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int, 4, "id"));
//
// sqlDeleteCommand2
//
this.sqlDeleteCommand2.CommandText = "[linkmanDeleteCommand]";
this.sqlDeleteCommand2.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlDeleteCommand2.Connection = this.sqlConnection1;
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_area", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "area", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_bri_day", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "bri_day", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_bri_math", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "bri_math", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_brithday", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "brithday", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_city", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "city", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_client", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "client", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_department", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "department", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_email", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "email", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_fax", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fax", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_house_phone", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "house_phone", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory__math", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "memory__math", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory_day", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "memory_day", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory_day1", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "memory_day1", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory_descript", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "memory_descript", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_mobile_phone", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "mobile_phone", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "name", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_office_phone", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "office_phone", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_province", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "province", System.Data.DataRowVersion.Original, null));
//
// sqlDataAdapter2
//
this.sqlDataAdapter2.DeleteCommand = this.sqlDeleteCommand3;
this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand3;
this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand3;
this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "linkmanSelectCommand", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("id", "id"),
new System.Data.Common.DataColumnMapping("name", "name"),
new System.Data.Common.DataColumnMapping("client", "client"),
new System.Data.Common.DataColumnMapping("department", "department"),
new System.Data.Common.DataColumnMapping("area", "area"),
new System.Data.Common.DataColumnMapping("mobile_phone", "mobile_phone"),
new System.Data.Common.DataColumnMapping("province", "province"),
new System.Data.Common.DataColumnMapping("city", "city"),
new System.Data.Common.DataColumnMapping("address", "address"),
new System.Data.Common.DataColumnMapping("office_phone", "office_phone"),
new System.Data.Common.DataColumnMapping("house_phone", "house_phone"),
new System.Data.Common.DataColumnMapping("fax", "fax"),
new System.Data.Common.DataColumnMapping("email", "email"),
new System.Data.Common.DataColumnMapping("avocation", "avocation"),
new System.Data.Common.DataColumnMapping("memory_day", "memory_day"),
new System.Data.Common.DataColumnMapping("brithday", "brithday"),
new System.Data.Common.DataColumnMapping("bri_math", "bri_math"),
new System.Data.Common.DataColumnMapping("bri_day", "bri_day"),
new System.Data.Common.DataColumnMapping("memory__math", "memory__math"),
new System.Data.Common.DataColumnMapping("memory_day1", "memory_day1"),
new System.Data.Common.DataColumnMapping("memory_descript", "memory_descript")})});
this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand3;
//
// sqlDeleteCommand3
//
this.sqlDeleteCommand3.CommandText = "[clinetDeleteCommand]";
this.sqlDeleteCommand3.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlDeleteCommand3.Connection = this.sqlConnection1;
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_address", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_area_number", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_city", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_coding", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_country", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_country_number", System.Data.SqlDbType.VarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_employee_num", System.Data.SqlDbType.BigInt, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_fax", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_income", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_phone_number", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_post_number", System.Data.SqlDbType.VarChar, 7, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_province", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_source", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_type", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_www_address", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand3
//
this.sqlInsertCommand3.CommandText = "[linkmanInsertCommand]";
this.sqlInsertCommand3.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlInsertCommand3.Connection = this.sqlConnection1;
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar, 50, "name"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@client", System.Data.SqlDbType.VarChar, 50, "client"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@department", System.Data.SqlDbType.VarChar, 50, "department"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@area", System.Data.SqlDbType.VarChar, 50, "area"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@mobile_phone", System.Data.SqlDbType.VarChar, 50, "mobile_phone"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@province", System.Data.SqlDbType.VarChar, 10, "province"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@city", System.Data.SqlDbType.VarChar, 50, "city"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@address", System.Data.SqlDbType.NVarChar, 1073741823, "address"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@office_phone", System.Data.SqlDbType.VarChar, 50, "office_phone"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@house_phone", System.Data.SqlDbType.VarChar, 50, "house_phone"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@fax", System.Data.SqlDbType.VarChar, 50, "fax"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@email", System.Data.SqlDbType.VarChar, 50, "email"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@avocation", System.Data.SqlDbType.NVarChar, 1073741823, "avocation"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_day", System.Data.SqlDbType.DateTime, 8, "memory_day"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@brithday", System.Data.SqlDbType.DateTime, 8, "brithday"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@bri_math", System.Data.SqlDbType.Int, 4, "bri_math"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@bri_day", System.Data.SqlDbType.Int, 4, "bri_day"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory__math", System.Data.SqlDbType.Int, 4, "memory__math"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_day1", System.Data.SqlDbType.Int, 4, "memory_day1"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_descript", System.Data.SqlDbType.NVarChar, 50, "memory_descript"));
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "[linkmanSelectCommand]";
this.sqlSelectCommand3.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlSelectCommand3.Connection = this.sqlConnection1;
this.sqlSelectCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
//
// sqlUpdateCommand3
//
this.sqlUpdateCommand3.CommandText = "[linkmanUpdateCommand]";
this.sqlUpdateCommand3.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlUpdateCommand3.Connection = this.sqlConnection1;
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar, 50, "name"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@client", System.Data.SqlDbType.VarChar, 50, "client"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@department", System.Data.SqlDbType.VarChar, 50, "department"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@area", System.Data.SqlDbType.VarChar, 50, "area"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@mobile_phone", System.Data.SqlDbType.VarChar, 50, "mobile_phone"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@province", System.Data.SqlDbType.VarChar, 10, "province"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@city", System.Data.SqlDbType.VarChar, 50, "city"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@address", System.Data.SqlDbType.NVarChar, 1073741823, "address"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@office_phone", System.Data.SqlDbType.VarChar, 50, "office_phone"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@house_phone", System.Data.SqlDbType.VarChar, 50, "house_phone"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@fax", System.Data.SqlDbType.VarChar, 50, "fax"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@email", System.Data.SqlDbType.VarChar, 50, "email"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@avocation", System.Data.SqlDbType.NVarChar, 1073741823, "avocation"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_day", System.Data.SqlDbType.DateTime, 8, "memory_day"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@brithday", System.Data.SqlDbType.DateTime, 8, "brithday"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@bri_math", System.Data.SqlDbType.Int, 4, "bri_math"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@bri_day", System.Data.SqlDbType.Int, 4, "bri_day"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory__math", System.Data.SqlDbType.Int, 4, "memory__math"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_day1", System.Data.SqlDbType.Int, 4, "memory_day1"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memory_descript", System.Data.SqlDbType.NVarChar, 50, "memory_descript"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_area", System.Data.SqlDbType.VarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_bri_day", System.Data.SqlDbType.Int, 4));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_bri_math", System.Data.SqlDbType.Int, 4));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_brithday", System.Data.SqlDbType.DateTime, 8));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_city", System.Data.SqlDbType.VarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_client", System.Data.SqlDbType.VarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_department", System.Data.SqlDbType.VarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_email", System.Data.SqlDbType.VarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_fax", System.Data.SqlDbType.VarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_house_phone", System.Data.SqlDbType.VarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory__math", System.Data.SqlDbType.Int, 4));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory_day", System.Data.SqlDbType.DateTime, 8));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory_day1", System.Data.SqlDbType.Int, 4));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_memory_descript", System.Data.SqlDbType.NVarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_mobile_phone", System.Data.SqlDbType.VarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_name", System.Data.SqlDbType.VarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_office_phone", System.Data.SqlDbType.VarChar, 50));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_province", System.Data.SqlDbType.VarChar, 10));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int, 4, "id"));
//
// sqlDataAdapter3
//
this.sqlDataAdapter3.DeleteCommand = this.sqlDeleteCommand4;
this.sqlDataAdapter3.InsertCommand = this.sqlInsertCommand4;
this.sqlDataAdapter3.SelectCommand = this.sqlSelectCommand4;
this.sqlDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "distribution", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("id", "id"),
new System.Data.Common.DataColumnMapping("sell_date", "sell_date"),
new System.Data.Common.DataColumnMapping("client", "client"),
new System.Data.Common.DataColumnMapping("linkman", "linkman"),
new System.Data.Common.DataColumnMapping("bargain_number", "bargain_number"),
new System.Data.Common.DataColumnMapping("unit_price", "unit_price"),
new System.Data.Common.DataColumnMapping("quantity", "quantity"),
new System.Data.Common.DataColumnMapping("discount", "discount"),
new System.Data.Common.DataColumnMapping("sum_unm", "sum_unm")})});
this.sqlDataAdapter3.UpdateCommand = this.sqlUpdateCommand4;
//
// sqlDeleteCommand4
//
this.sqlDeleteCommand4.CommandText = "[distributionDeleteCommand]";
this.sqlDeleteCommand4.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlDeleteCommand4.Connection = this.sqlConnection1;
this.sqlDeleteCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlDeleteCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_bargain_number", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "bargain_number", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_client", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "client", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_discount", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "discount", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_linkman", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "linkman", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_quantity", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "quantity", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_sell_date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "sell_date", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_sum_unm", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "sum_unm", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_unit_price", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "unit_price", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand4
//
this.sqlInsertCommand4.CommandText = "[distributionInsertCommand]";
this.sqlInsertCommand4.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlInsertCommand4.Connection = this.sqlConnection1;
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@sell_date", System.Data.SqlDbType.DateTime, 8, "sell_date"));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@client", System.Data.SqlDbType.VarChar, 50, "client"));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@linkman", System.Data.SqlDbType.VarChar, 50, "linkman"));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@bargain_number", System.Data.SqlDbType.VarChar, 50, "bargain_number"));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@unit_price", System.Data.SqlDbType.Money, 8, "unit_price"));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@quantity", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "quantity", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@discount", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "discount", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@sum_unm", System.Data.SqlDbType.Money, 8, "sum_unm"));
//
// sqlSelectCommand4
//
this.sqlSelectCommand4.CommandText = "[distributionSelectCommand]";
this.sqlSelectCommand4.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlSelectCommand4.Connection = this.sqlConnection1;
this.sqlSelectCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
//
// sqlUpdateCommand4
//
this.sqlUpdateCommand4.CommandText = "[distributionUpdateCommand]";
this.sqlUpdateCommand4.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlUpdateCommand4.Connection = this.sqlConnection1;
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@sell_date", System.Data.SqlDbType.DateTime, 8, "sell_date"));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@client", System.Data.SqlDbType.VarChar, 50, "client"));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@linkman", System.Data.SqlDbType.VarChar, 50, "linkman"));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@bargain_number", System.Data.SqlDbType.VarChar, 50, "bargain_number"));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@unit_price", System.Data.SqlDbType.Money, 8, "unit_price"));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@quantity", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "quantity", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@discount", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "discount", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@sum_unm", System.Data.SqlDbType.Money, 8, "sum_unm"));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_bargain_number", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "bargain_number", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_client", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "client", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_discount", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "discount", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_linkman", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "linkman", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_quantity", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(18)), ((System.Byte)(0)), "quantity", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_sell_date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "sell_date", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_sum_unm", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "sum_unm", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_unit_price", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "unit_price", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int, 4, "id"));
//
// sqlDataAdapter4
//
this.sqlDataAdapter4.DeleteCommand = this.sqlDeleteCommand5;
this.sqlDataAdapter4.InsertCommand = this.sqlInsertCommand5;
this.sqlDataAdapter4.SelectCommand = this.sqlSelectCommand5;
this.sqlDataAdapter4.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "feedback", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("id", "id"),
new System.Data.Common.DataColumnMapping("date_time", "date_time"),
new System.Data.Common.DataColumnMapping("client", "client"),
new System.Data.Common.DataColumnMapping("type", "type"),
new System.Data.Common.DataColumnMapping("description", "description"),
new System.Data.Common.DataColumnMapping("dispose", "dispose"),
new System.Data.Common.DataColumnMapping("dispose_date", "dispose_date")})});
this.sqlDataAdapter4.UpdateCommand = this.sqlUpdateCommand5;
//
// sqlDeleteCommand5
//
this.sqlDeleteCommand5.CommandText = "[feedbackDeleteCommand]";
this.sqlDeleteCommand5.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlDeleteCommand5.Connection = this.sqlConnection1;
this.sqlDeleteCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlDeleteCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_client", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "client", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_date_time", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "date_time", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_dispose_date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "dispose_date", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_type", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "type", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand5
//
this.sqlInsertCommand5.CommandText = "[feedbackInsertCommand]";
this.sqlInsertCommand5.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlInsertCommand5.Connection = this.sqlConnection1;
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@date_time", System.Data.SqlDbType.DateTime, 8, "date_time"));
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@client", System.Data.SqlDbType.VarChar, 50, "client"));
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@type", System.Data.SqlDbType.VarChar, 50, "type"));
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@description", System.Data.SqlDbType.NVarChar, 1073741823, "description"));
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@dispose", System.Data.SqlDbType.NVarChar, 1073741823, "dispose"));
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@dispose_date", System.Data.SqlDbType.DateTime, 8, "dispose_date"));
//
// sqlSelectCommand5
//
this.sqlSelectCommand5.CommandText = "[feedbackSelectCommand]";
this.sqlSelectCommand5.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlSelectCommand5.Connection = this.sqlConnection1;
this.sqlSelectCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
//
// sqlUpdateCommand5
//
this.sqlUpdateCommand5.CommandText = "[feedbackUpdateCommand]";
this.sqlUpdateCommand5.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlUpdateCommand5.Connection = this.sqlConnection1;
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@date_time", System.Data.SqlDbType.DateTime, 8, "date_time"));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@client", System.Data.SqlDbType.VarChar, 50, "client"));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@type", System.Data.SqlDbType.VarChar, 50, "type"));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@description", System.Data.SqlDbType.NVarChar, 1073741823, "description"));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@dispose", System.Data.SqlDbType.NVarChar, 1073741823, "dispose"));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@dispose_date", System.Data.SqlDbType.DateTime, 8, "dispose_date"));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_client", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "client", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_date_time", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "date_time", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_dispose_date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "dispose_date", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_type", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "type", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int, 4, "id"));
//
// statusBar1
//
this.statusBar1.Location = new System.Drawing.Point(0, 376);
this.statusBar1.Name = "statusBar1";
this.statusBar1.Size = new System.Drawing.Size(752, 22);
this.statusBar1.TabIndex = 8;
this.statusBar1.Text = "statusBar1";
//
// progressBar1
//
this.progressBar1.Cursor = System.Windows.Forms.Cursors.Default;
this.progressBar1.Location = new System.Drawing.Point(176, 160);
this.progressBar1.Name = "progressBar1";
this.progressBar1.Size = new System.Drawing.Size(456, 23);
this.progressBar1.TabIndex = 9;
this.progressBar1.Visible = false;
//
// sqlDataAdapter5
//
this.sqlDataAdapter5.DeleteCommand = this.sqlDeleteCommand6;
this.sqlDataAdapter5.InsertCommand = this.sqlInsertCommand6;
this.sqlDataAdapter5.SelectCommand = this.sqlSelectCommand6;
this.sqlDataAdapter5.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "logon", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("id", "id"),
new System.Data.Common.DataColumnMapping("username", "username"),
new System.Data.Common.DataColumnMapping("pwd", "pwd"),
new System.Data.Common.DataColumnMapping("class", "class")})});
this.sqlDataAdapter5.UpdateCommand = this.sqlUpdateCommand6;
//
// sqlSelectCommand6
//
this.sqlSelectCommand6.CommandText = "SELECT id, username, pwd, class FROM logon";
this.sqlSelectCommand6.Connection = this.sqlConnection1;
//
// sqlInsertCommand6
//
this.sqlInsertCommand6.CommandText = "INSERT INTO logon(username, pwd, class) VALUES (@username, @pwd, @class); SELECT " +
"id, username, pwd, class FROM logon WHERE (id = @@IDENTITY)";
this.sqlInsertCommand6.Connection = this.sqlConnection1;
this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@username", System.Data.SqlDbType.VarChar, 50, "username"));
this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@pwd", System.Data.SqlDbType.VarChar, 50, "pwd"));
this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@class", System.Data.SqlDbType.TinyInt, 1, "class"));
//
// sqlUpdateCommand6
//
this.sqlUpdateCommand6.CommandText = @"UPDATE logon SET username = @username, pwd = @pwd, class = @class WHERE (id = @Original_id) AND (class = @Original_class OR @Original_class IS NULL AND class IS NULL) AND (pwd = @Original_pwd OR @Original_pwd IS NULL AND pwd IS NULL) AND (username = @Original_username OR @Original_username IS NULL AND username IS NULL); SELECT id, username, pwd, class FROM logon WHERE (id = @id)";
this.sqlUpdateCommand6.Connection = this.sqlConnection1;
this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@username", System.Data.SqlDbType.VarChar, 50, "username"));
this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@pwd", System.Data.SqlDbType.VarChar, 50, "pwd"));
this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@class", System.Data.SqlDbType.TinyInt, 1, "class"));
this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_class", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "class", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_pwd", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "pwd", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_username", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "username", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int, 4, "id"));
//
// sqlDeleteCommand6
//
this.sqlDeleteCommand6.CommandText = @"DELETE FROM logon WHERE (id = @Original_id) AND (class = @Original_class OR @Original_class IS NULL AND class IS NULL) AND (pwd = @Original_pwd OR @Original_pwd IS NULL AND pwd IS NULL) AND (username = @Original_username OR @Original_username IS NULL AND username IS NULL)";
this.sqlDeleteCommand6.Connection = this.sqlConnection1;
this.sqlDeleteCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_id", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "id", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_class", System.Data.SqlDbType.TinyInt, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "class", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_pwd", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "pwd", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_username", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "username", System.Data.DataRowVersion.Original, null));
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(752, 398);
this.Controls.Add(this.progressBar1);
this.Controls.Add(this.statusBar1);
this.Controls.Add(this.button4);
this.Controls.Add(this.button3);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.button2);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.listView1);
this.Controls.Add(this.button1);
this.Controls.Add(this.dateTimePicker1);
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void Form1_Load(object sender, System.EventArgs e)
{
AddHandler();
}
private DataSet ds=new DataSet();
private void button1_Click(object sender, System.EventArgs e)
{
/*listView1.View = View.Details;
//listView1.CheckBoxes=true;
listView1.MultiSelect=false;
listView1.Columns.Add("id", 20, HorizontalAlignment.Left);
ColumnHeader col=new ColumnHeader();
col.Text="id";
this.listView1.Columns.Add(col);
ColumnHeader col1=new ColumnHeader();
col.Text="用户名";
this.listView1.Columns.Add(col1);
ListViewItem item =new ListViewItem();
ListViewItem item1=new ListViewItem();
item.SubItems.Add("1");
item.SubItems.Add("李宁");
listView1.Items.Add(item);
item1.SubItems.Add("2");
item1.SubItems.Add("于华");
listView1.Items.Add(item1);
*/
try
{
this.textBox1.DataBindings.Clear();
this.sqlSelectCommand1.Parameters.Clear();
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@query",System.Data.SqlDbType.NVarChar,200));
this.sqlSelectCommand1.Parameters["@query"].Value=" name like '%中%'";
ds.Clear();
this.sqlDataAdapter1.Fill(ds,"client");
this.dataGrid1.DataSource=ds.Tables[0];
this.textBox1.DataBindings.Add("Text",ds.Tables[0],"name");
}
catch(Exception e3)
{MessageBox.Show(e3.Message+ "\r" + this.sqlSelectCommand1.CommandText.ToString());}
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = "client";
ts.ColumnHeadersVisible=true;
dataGrid1.TableStyles.Clear();
dataGrid1.TableStyles.Add(ts);
dataGrid1.TableStyles["client"].GridColumnStyles[0].Width=0;
//MessageBox.Show(this,dataGrid1.TableStyles[0].GridColumnStyles[0]());
}
private void button3_Click(object sender, System.EventArgs e)
{
this.Cursor=System.Windows.Forms.Cursors.WaitCursor;
this.progressBar1.Step=1;
this.progressBar1.Show();
this.progressBar1.Value=0;
this.progressBar1.Increment(1);
// string savepath = "";
// FolderBrowserDialog folderBrowserDialog1 = new FolderBrowserDialog();
// if (folderBrowserDialog1.ShowDialog() == DialogResult.OK)
// {
// savepath = folderBrowserDialog1.SelectedPath;
// }
Object Nothing=System.Reflection.Missing.Value;
//object filename = savepath + "/" + ds.Tables[0].TableName + "库存报表";
Word.Application WordApp=new Word.ApplicationClass();
Word.Document WordDoc=WordApp.Documents.Add(ref Nothing,ref Nothing,ref Nothing,ref Nothing);
WordDoc.Paragraphs.First.Range.Text = "表名: [" + ds.Tables[0].TableName.ToString() + "] [共有：" + ds.Tables[0].Rows.Count.ToString() + "条记录]";
WordDoc.Paragraphs.First.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
Word.Table table=WordDoc.Tables.Add(WordApp.Selection.Range,ds.Tables[0].Rows.Count+1,(ds.Tables[0].Columns.Count-1),ref Nothing,ref Nothing);
//MessageBox.Show(ds.Tables[0].Columns.Count.ToString(),"good");
for (int g=0;g<(ds.Tables[0].Columns.Count-1);g++)//ds.Tables[0].Columns.Count
{string kk=ds.Tables[0].Columns[g+1].ColumnName.ToString();
table.Cell(1,g+1).Range.Text=kk;
this.progressBar1.Increment(1);
}
// table.Cell(1,2).Range.Text="书名";
// table.Cell(1,3).Range.Text="总库存";
// table.Cell(1,4).Range.Text="借书库存";
// table.Cell(1,5).Range.Text="可借数量";
// table.Cell(1,6).Range.Text="已借数量";
for ( int k=0;k