📄 accountprop.cs
字号:
this.tbOutID.Size = new System.Drawing.Size(327, 21);
this.tbOutID.TabIndex = 16;
this.tbOutID.Text = "";
//
// label9
//
this.label9.Location = new System.Drawing.Point(19, 112);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(163, 25);
this.label9.TabIndex = 15;
this.label9.Text = "发件服务器登录账户：";
//
// tbOutPort
//
this.tbOutPort.Location = new System.Drawing.Point(173, 293);
this.tbOutPort.Name = "tbOutPort";
this.tbOutPort.Size = new System.Drawing.Size(374, 21);
this.tbOutPort.TabIndex = 17;
this.tbOutPort.Text = "";
//
// label7
//
this.label7.Location = new System.Drawing.Point(19, 293);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(163, 25);
this.label7.TabIndex = 16;
this.label7.Text = "发件服务器登录端口：";
//
// cbNeedVerify
//
this.cbNeedVerify.Checked = true;
this.cbNeedVerify.CheckState = System.Windows.Forms.CheckState.Checked;
this.cbNeedVerify.Location = new System.Drawing.Point(19, 60);
this.cbNeedVerify.Name = "cbNeedVerify";
this.cbNeedVerify.Size = new System.Drawing.Size(269, 26);
this.cbNeedVerify.TabIndex = 15;
this.cbNeedVerify.Text = "发件服务器需要验证";
this.cbNeedVerify.CheckedChanged += new System.EventHandler(this.cbNeedVerify_CheckedChanged);
//
// tbOutServer
//
this.tbOutServer.Location = new System.Drawing.Point(125, 17);
this.tbOutServer.Name = "tbOutServer";
this.tbOutServer.Size = new System.Drawing.Size(422, 21);
this.tbOutServer.TabIndex = 10;
this.tbOutServer.Text = "";
//
// label10
//
this.label10.Location = new System.Drawing.Point(19, 17);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(96, 25);
this.label10.TabIndex = 9;
this.label10.Text = "收件服务器：";
//
// btnApply
//
this.btnApply.Location = new System.Drawing.Point(499, 388);
this.btnApply.Name = "btnApply";
this.btnApply.Size = new System.Drawing.Size(90, 24);
this.btnApply.TabIndex = 1;
this.btnApply.Text = "应用(&A)";
this.btnApply.Click += new System.EventHandler(this.btnApply_Click);
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(384, 388);
this.btnCancel.Name = "btnCancel";
this.btnCancel.Size = new System.Drawing.Size(90, 24);
this.btnCancel.TabIndex = 2;
this.btnCancel.Text = "取消(&C)";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// btnOk
//
this.btnOk.Location = new System.Drawing.Point(250, 388);
this.btnOk.Name = "btnOk";
this.btnOk.Size = new System.Drawing.Size(90, 24);
this.btnOk.TabIndex = 3;
this.btnOk.Text = "确定(&O)";
this.btnOk.Click += new System.EventHandler(this.btnOk_Click);
//
// da
//
this.da.DeleteCommand = this.oleDbDeleteCommand1;
this.da.InsertCommand = this.oleDbInsertCommand1;
this.da.SelectCommand = this.oleDbSelectCommand1;
this.da.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "MailAccounts", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Account", "Account"),
new System.Data.Common.DataColumnMapping("IncomingMailServer", "IncomingMailServer"),
new System.Data.Common.DataColumnMapping("InPassword", "InPassword"),
new System.Data.Common.DataColumnMapping("InPort", "InPort"),
new System.Data.Common.DataColumnMapping("InUserID", "InUserID"),
new System.Data.Common.DataColumnMapping("IsLeaveMessage", "IsLeaveMessage"),
new System.Data.Common.DataColumnMapping("IsOutgoingAuthorized", "IsOutgoingAuthorized"),
new System.Data.Common.DataColumnMapping("IsTheSameWithIncoming", "IsTheSameWithIncoming"),
new System.Data.Common.DataColumnMapping("MailAccountID", "MailAccountID"),
new System.Data.Common.DataColumnMapping("OutgoingMailServer", "OutgoingMailServer"),
new System.Data.Common.DataColumnMapping("OutPassword", "OutPassword"),
new System.Data.Common.DataColumnMapping("OutPort", "OutPort"),
new System.Data.Common.DataColumnMapping("OutUserID", "OutUserID"),
new System.Data.Common.DataColumnMapping("ServerType", "ServerType"),
new System.Data.Common.DataColumnMapping("Type", "Type")})});
this.da.UpdateCommand = this.oleDbUpdateCommand1;
//
// oleDbDeleteCommand1
//
this.oleDbDeleteCommand1.CommandText = @"DELETE FROM MailAccounts WHERE (MailAccountID = ?) AND (Account = ? OR ? IS NULL AND Account IS NULL) AND (InPassword = ? OR ? IS NULL AND InPassword IS NULL) AND (InPort = ? OR ? IS NULL AND InPort IS NULL) AND (InUserID = ? OR ? IS NULL AND InUserID IS NULL) AND (IncomingMailServer = ? OR ? IS NULL AND IncomingMailServer IS NULL) AND (IsLeaveMessage = ?) AND (IsOutgoingAuthorized = ?) AND (IsTheSameWithIncoming = ?) AND (OutPassword = ? OR ? IS NULL AND OutPassword IS NULL) AND (OutPort = ? OR ? IS NULL AND OutPort IS NULL) AND (OutUserID = ? OR ? IS NULL AND OutUserID IS NULL) AND (OutgoingMailServer = ? OR ? IS NULL AND OutgoingMailServer IS NULL) AND (ServerType = ? OR ? IS NULL AND ServerType IS NULL) AND (Type = ? OR ? IS NULL AND Type IS NULL)";
this.oleDbDeleteCommand1.Connection = this.oleDbConnection1;
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_MailAccountID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "MailAccountID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Account", System.Data.OleDb.OleDbType.VarWChar, 125, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Account", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Account1", System.Data.OleDb.OleDbType.VarWChar, 125, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Account", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_InPassword", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "InPassword", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_InPassword1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "InPassword", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_InPort", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "InPort", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_InPort1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "InPort", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_InUserID", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "InUserID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_InUserID1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "InUserID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IncomingMailServer", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IncomingMailServer", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IncomingMailServer1", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IncomingMailServer", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IsLeaveMessage", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsLeaveMessage", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IsOutgoingAuthorized", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsOutgoingAuthorized", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IsTheSameWithIncoming", System.Data.OleDb.OleDbType.Boolean, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IsTheSameWithIncoming", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OutPassword", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OutPassword", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OutPassword1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OutPassword", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OutPort", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OutPort", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OutPort1", System.Data.OleDb.OleDbType.VarWChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OutPort", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OutUserID", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OutUserID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OutUserID1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OutUserID", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OutgoingMailServer", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OutgoingMailServer", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_OutgoingMailServer1", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "OutgoingMailServer", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ServerType", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ServerType", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ServerType1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ServerType", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Type", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Type", System.Data.DataRowVersion.Original, null));
this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Type1", System.Data.OleDb.OleDbType.VarWChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Type", System.Data.DataRowVersion.Original, null));
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=""MyOutlookDB.mdb"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";
//
// oleDbInsertCommand1
//
this.oleDbInsertCommand1.CommandText = @"INSERT INTO MailAccounts(Account, IncomingMailServer, InPassword, InPort, InUserID, IsLeaveMessage, IsOutgoingAuthorized, IsTheSameWithIncoming, OutgoingMailServer, OutPassword, OutPort, OutUserID, ServerType, Type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Account", System.Data.OleDb.OleDbType.VarWChar, 125, "Account"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncomingMailServer", System.Data.OleDb.OleDbType.VarWChar, 25, "IncomingMailServer"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("InPassword", System.Data.OleDb.OleDbType.VarWChar, 20, "InPassword"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("InPort", System.Data.OleDb.OleDbType.VarWChar, 6, "InPort"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("InUserID", System.Data.OleDb.OleDbType.VarWChar, 20, "InUserID"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("IsLeaveMessage", System.Data.OleDb.OleDbType.Boolean, 2, "IsLeaveMessage"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("IsOutgoingAuthorized", System.Data.OleDb.OleDbType.Boolean, 2, "IsOutgoingAuthorized"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("IsTheSameWithIncoming", System.Data.OleDb.OleDbType.Boolean, 2, "IsTheSameWithIncoming"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutgoingMailServer", System.Data.OleDb.OleDbType.VarWChar, 25, "OutgoingMailServer"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutPassword", System.Data.OleDb.OleDbType.VarWChar, 20, "OutPassword"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutPort", System.Data.OleDb.OleDbType.VarWChar, 6, "OutPort"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutUserID", System.Data.OleDb.OleDbType.VarWChar, 20, "OutUserID"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ServerType", System.Data.OleDb.OleDbType.VarWChar, 4, "ServerType"));
this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Type", System.Data.OleDb.OleDbType.VarWChar, 4, "Type"));
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT Account, IncomingMailServer, InPassword, InPort, InUserID, IsLeaveMessage," +
" IsOutgoingAuthorized, IsTheSameWithIncoming, MailAccountID, OutgoingMailServer," +
" OutPassword, OutPort, OutUserID, ServerType, Type FROM MailAccounts";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbUpdateCommand1
//
this.oleDbUpdateCommand1.CommandText = @"UPDATE MailAccounts SET Account = ?, IncomingMailServer = ?, InPassword = ?, InPort = ?, InUserID = ?, IsLeaveMessage = ?, IsOutgoingAuthorized = ?, IsTheSameWithIncoming = ?, OutgoingMailServer = ?, OutPassword = ?, OutPort = ?, OutUserID = ?, ServerType = ?, Type = ? WHERE (MailAccountID = ?) AND (Account = ? OR ? IS NULL AND Account IS NULL) AND (InPassword = ? OR ? IS NULL AND InPassword IS NULL) AND (InPort = ? OR ? IS NULL AND InPort IS NULL) AND (InUserID = ? OR ? IS NULL AND InUserID IS NULL) AND (IncomingMailServer = ? OR ? IS NULL AND IncomingMailServer IS NULL) AND (IsLeaveMessage = ?) AND (IsOutgoingAuthorized = ?) AND (IsTheSameWithIncoming = ?) AND (OutPassword = ? OR ? IS NULL AND OutPassword IS NULL) AND (OutPort = ? OR ? IS NULL AND OutPort IS NULL) AND (OutUserID = ? OR ? IS NULL AND OutUserID IS NULL) AND (OutgoingMailServer = ? OR ? IS NULL AND OutgoingMailServer IS NULL) AND (ServerType = ? OR ? IS NULL AND ServerType IS NULL) AND (Type = ? OR ? IS NULL AND Type IS NULL)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Account", System.Data.OleDb.OleDbType.VarWChar, 125, "Account"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("IncomingMailServer", System.Data.OleDb.OleDbType.VarWChar, 25, "IncomingMailServer"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("InPassword", System.Data.OleDb.OleDbType.VarWChar, 20, "InPassword"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("InPort", System.Data.OleDb.OleDbType.VarWChar, 6, "InPort"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("InUserID", System.Data.OleDb.OleDbType.VarWChar, 20, "InUserID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("IsLeaveMessage", System.Data.OleDb.OleDbType.Boolean, 2, "IsLeaveMessage"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("IsOutgoingAuthorized", System.Data.OleDb.OleDbType.Boolean, 2, "IsOutgoingAuthorized"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("IsTheSameWithIncoming", System.Data.OleDb.OleDbType.Boolean, 2, "IsTheSameWithIncoming"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutgoingMailServer", System.Data.OleDb.OleDbType.VarWChar, 25, "OutgoingMailServer"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutPassword", System.Data.OleDb.OleDbType.VarWChar, 20, "OutPassword"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutPort", System.Data.OleDb.OleDbType.VarWChar, 6, "OutPort"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("OutUserID", System.Data.OleDb.OleDbType.VarWChar, 20, "OutUserID"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ServerType", System.Data.OleDb.OleDbType.VarWChar, 4, "ServerType"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Type", System.Data.OleDb.OleDbType.VarWChar, 4, "Type"));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -