accountprop.cs

网络编程案例

			this.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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.oleDbUpdateCommand1.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));
			// 
			// AccountProp
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(607, 429);
			this.Controls.Add(this.btnOk);
			this.Controls.Add(this.btnCancel);
			this.Controls.Add(this.btnApply);
			this.Controls.Add(this.tabControl1);
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
			this.MaximizeBox = false;
			this.Name = "AccountProp";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
			this.tabControl1.ResumeLayout(false);
			this.tabPageMail.ResumeLayout(false);
			this.tabPageIn.ResumeLayout(false);
			this.tabPageOut.ResumeLayout(false);
			this.gbOutSettings.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion


		//创建或者修改属性
		public void setProp(bool newAccount) 
		{
			if (!newAccount) 
			{
				updateData();
			}
			else 
			{
				newFlag = true;
			}
		}

		//更新窗口中的数据
		private void updateData() 
		{
			if (lv.SelectedIndices.Count>0)
			{
				int index = lv.SelectedIndices[0];
				string account = lv.Items[index].Text;

				//从数据库中读取邮箱帐户

				DataRow dr = dt.Rows[index];
				
				this.tbMailBox.Text = (string)dr["Account"];
				this.tbInServer.Text = (string)dr["IncomingMailServer"].ToString();
				this.tbInID.Text = (string)dr["InUserID"].ToString();
				this.tbInPwd.Text = (string)dr["InUserID"].ToString();
				this.tbInPort.Text = (string)dr["InPort"].ToString();
				this.tbOutServer.Text = (string)dr["OutgoingMailServer"].ToString();
				this.tbOutPwd.Text = (string)dr["OutPassword"].ToString();
				this.tbOutID.Text = (string)dr["OutUserID"].ToString();
				this.tbOutPort.Text = (string)dr["OutPort"].ToString();

				this.cbKeepMails.Checked = (bool)dr["IsLeaveMessage"];
				this.cbNeedVerify.Checked = (bool)dr["IsOutgoingAuthorized"];
				this.rbtnSame.Checked = (bool)dr["IsTheSameWithIncoming"];

				this.cbNeedVerify_CheckedChanged(null, null);
			}
		}

		//根据Checkbox的状态更新下面的控件
		private void cbNeedVerify_CheckedChanged(object sender, System.EventArgs e)
		{
			gbOutSettings.Enabled = cbNeedVerify.Checked;
			tbOutID.Enabled = rbtnOwn.Checked;
			tbOutPwd.Enabled = rbtnOwn.Checked;
		}

		private void rbtnSame_CheckedChanged(object sender, System.EventArgs e)
		{
			this.cbNeedVerify_CheckedChanged(null, null);
		}

		private void rbtnOwn_CheckedChanged(object sender, System.EventArgs e)
		{
			this.cbNeedVerify_CheckedChanged(null, null);
		}

		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void btnApply_Click(object sender, System.EventArgs e)
		{
			if (this.tbMailBox.Text == "") 
			{
				MessageBox.Show("必须输入邮件帐户名字", "邮箱帐户错误",
					MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
				return;
			}

			DataRow dr;
			if (!newFlag) 
			{
				int index = lv.SelectedIndices[0];
				dr = dt.Rows[index];
			}
			else 
			{
				dr = dt.NewRow();
				dt.Rows.Add(dr);
			}
			dr.BeginEdit();

			dr["Account"] = this.tbMailBox.Text;
			dr["IncomingMailServer"] = this.tbInServer.Text;
			dr["InUserID"] = this.tbInID.Text;
			dr["InPassword"] = this.tbInPwd.Text;
			dr["InPort"] = this.tbInPort.Text;

			dr["OutgoingMailServer"] = this.tbOutServer.Text;
			dr["OutPassword"] = this.tbOutPwd.Text;
			dr["OutUserID"] = this.tbOutID.Text;
			dr["OutPort"] = this.tbOutPort.Text;
			dr["IsLeaveMessage"] = this.cbKeepMails.Checked;
			dr["IsOutgoingAuthorized"] = this.cbNeedVerify.Checked;
			dr["IsTheSameWithIncoming"] =this.rbtnSame.Checked;
				
			dr.EndEdit();

			da.Update(ds, "MailAccounts");
			ds.AcceptChanges();

				

			//更新ListView
			if (newFlag) 
			{
				ListViewItem item1 = lv.Items.Add(this.tbMailBox.Text);
				item1.SubItems.Add(FormAccount.MAIL_TYPE_GENERAL);
			}
			else 
			{
				int index = lv.SelectedIndices[0];
				lv.Items[index].Text = this.tbMailBox.Text;
			}

			newFlag = false;
			
		}

		private void btnOk_Click(object sender, System.EventArgs e)
		{
			btnApply_Click(null, null);
			this.Close();
		}
	}
}