frmhappening.cs
来自「小区物业管理:管理小区的费用、小区工作人员的编排和工资管理、小区的运作、对住户资」· CS 代码 · 共 789 行 · 第 1/3 页
CS
789 行
private void button3_Click(object sender, System.EventArgs e)
{
this.groupBox2.Visible=true;
}
private void button7_Click(object sender, System.EventArgs e)
{
this.textBox1.Clear();
this.textBox2.Clear();
this.textBox3.Clear();
this.textBox4.Clear();
this.textBox5.Clear();
}
private void button9_Click(object sender, System.EventArgs e)
{
this.groupBox2.Visible=false;
}
private void button6_Click(object sender, System.EventArgs e)
{
this.objSqlConn.Close();
this.Close();
}
private void frmhappening_Load(object sender, System.EventArgs e)
{
//DATAGRID
objSqlConn=new SqlConnection("database=atorregulate;user id=sa;password=;SERVER=(local)");
objSqlConn.Open();
objSqlDataAdapter=new SqlDataAdapter();
objSqlDataAdapter.SelectCommand=new SqlCommand("select Hnumber as 事件编号,Htitle as 标题,Hcontent as 内容,Hdata as 日期, Hperson as 参与人物,Heffecl as 处理结果 from happening",objSqlConn);
objDataSet=new DataSet();
objSqlDataAdapter.Fill(objDataSet,"happening");
//将DATAGRID控件绑定到数据集表
this.dataGrid1.SetDataBinding(objDataSet,"happening");
//定义插入命令
string insCmd="insert into happening values(@Hnumber,@Htitle,@Hcontent,@Hdata,@Hperson,@Heffecl)";
//实例化insertCommand
this.objSqlDataAdapter.InsertCommand=new SqlCommand(insCmd,this.objSqlConn);
//设置置插入命令参数
objSqlParam=objSqlDataAdapter.InsertCommand.Parameters.Add(new SqlParameter("@Htitle",System.Data.SqlDbType.VarChar,50));
objSqlParam.SourceColumn="事件编号";
objSqlParam.SourceVersion=DataRowVersion.Current;
objSqlParam=objSqlDataAdapter.InsertCommand.Parameters.Add(new SqlParameter("@Hnumber",System.Data.SqlDbType.VarChar,50));
objSqlParam.SourceColumn="标题";
objSqlParam.SourceVersion=DataRowVersion.Current;
objSqlParam=objSqlDataAdapter.InsertCommand.Parameters.Add(new SqlParameter("@Hcontent",System.Data.SqlDbType.VarChar,255));
objSqlParam.SourceColumn="内容";
objSqlParam.SourceVersion=DataRowVersion.Current;
objSqlParam=objSqlDataAdapter.InsertCommand.Parameters.Add(new SqlParameter("@Hdata",System.Data.SqlDbType.DateTime,8));
objSqlParam.SourceColumn="日期";
objSqlParam.SourceVersion=DataRowVersion.Current;
objSqlParam=objSqlDataAdapter.InsertCommand.Parameters.Add(new SqlParameter("@Hperson",System.Data.SqlDbType.VarChar,50));
objSqlParam.SourceColumn="参与人物";
objSqlParam.SourceVersion=DataRowVersion.Current;
objSqlParam=objSqlDataAdapter.InsertCommand.Parameters.Add(new SqlParameter("@Heffecl",System.Data.SqlDbType.VarChar,255));
objSqlParam.SourceColumn="处理结果";
objSqlParam.SourceVersion=DataRowVersion.Current;
}
private bool ValidateFields()
{
bool returnValue=true;
if(this.textBox1.Text.Trim()==String.Empty || this.textBox2.Text.Trim()==String.Empty || this.textBox3.Text.Trim()==String.Empty || this.textBox5.Text.Trim()==String.Empty)
{
MessageBox.Show("请输入完整信息！","服务器拒绝");
this.textBox1.Focus();
return false;
}
else
{
for(int i=0;i<this.textBox4.Text.Length;i++)
{
if(Char.IsNumber(textBox4.Text.ToString(),i))
{
MessageBox.Show("人物名字不能为数字！","服务器拒绝");
this.textBox4.Focus();
returnValue=false;
break;
}
}
}
return returnValue;
}
private void btninsert_Click(object sender, System.EventArgs e)
{
try
{
if(this.textBox1.Text!=String.Empty && this.textBox2.Text!=String.Empty && this.textBox3.Text!=String.Empty && this.textBox5.Text!=String.Empty)
{
//如果有数据和字段。验证..
if(ValidateFields())
{
DataRow objDataRow=objDataSet.Tables["happening"].NewRow();
objDataRow["标题"]=this.textBox1.Text;
objDataRow["内容"]=this.textBox2.Text;
objDataRow["日期"]=DateTime.Parse(this.textBox3.Text);
objDataRow["参与人物"]=this.textBox4.Text;
objDataRow["处理结果"]=this.textBox5.Text;
objDataRow["事件编号"]=this.textBox6.Text;
objDataSet.Tables["happening"].Rows.Add(objDataRow);
objDataSet.HasChanges(DataRowState.Added);
objSqlDataAdapter.Update(objDataSet,"happening");
MessageBox.Show("插入事件纪录成功！","服务器确认");
this.textBox1.Clear();
this.textBox2.Clear();
this.textBox3.Clear();
this.textBox4.Clear();
this.textBox5.Clear();
this.dataGrid1.Update();
this.textBox1.Focus();
}
}
else if(objDataSet.HasChanges())
{
objSqlDataAdapter.Update(objDataSet,"happening");
MessageBox.Show("插入事件纪录已成功！","服务器拒绝");
}
else
MessageBox.Show("请输入完整信息！","服务器拒绝");
}
catch(SqlException ex)
{
MessageBox.Show(ex.Message.ToString());
}
catch(Exception genEx)
{
MessageBox.Show(genEx.Message.ToString());
}
}
private void frmhappening_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
this.objSqlConn.Close();
}
private void button4_Click(object sender, System.EventArgs e)
{
if (this.printDialog2 .ShowDialog ()==DialogResult.OK )
{
this.pdocOrderDetails .Print ();
}
}
private void pdocOrderDetails_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
}
private void button5_Click(object sender, System.EventArgs e)
{
}
private void button5_Click_1(object sender, System.EventArgs e)
{
this.ppdlgOrderDatails .ShowDialog ();
}
private void pdocOrderDetails_PrintPage_1(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
Font objFont=new Font ("Tahoma",11,FontStyle.Regular );
Brush objBrush=Brushes.Black ;
Pen objPen=new Pen (objBrush);
objPen.Width =2;
int nLeft=this.pageSetupDialog1 .PageSettings .Margins .Left ;
int nTop=this.pageSetupDialog1 .PageSettings .Margins .Top ;
int nWidth=this.pageSetupDialog1 .PageSettings .PaperSize .Width -(this.pageSetupDialog1 .PageSettings .Margins .Left +this.pageSetupDialog1 .PageSettings .Margins .Right );
int nHeight=this.pageSetupDialog1 .PageSettings .PaperSize .Height -(this.pageSetupDialog1 .PageSettings .Margins .Bottom );
e.Graphics .DrawLine (objPen,nLeft,nTop,nLeft+nWidth,nTop);
e.Graphics .DrawLine (objPen,nLeft,nTop+nHeight,nLeft+nWidth,nTop+nHeight);
e.Graphics .DrawLine (objPen,nLeft,nTop,nLeft,nTop+nHeight);
e.Graphics .DrawLine (objPen,nLeft+nWidth,nTop,nLeft+nWidth,nTop+nHeight);
e.Graphics.DrawString ("重大事件记录",new Font ("Garamond",36,FontStyle.Bold ),Brushes.Blue ,nLeft+30,nTop+10);
e.Graphics.DrawString ("编号",objFont,objBrush ,nLeft+20,nTop+60);
e.Graphics.DrawString ("标题",objFont,objBrush ,nLeft+70,nTop+60);
e.Graphics.DrawString ("内容",objFont,objBrush ,nLeft+140,nTop+60);
e.Graphics.DrawString ("日期",objFont,objBrush ,nLeft+280,nTop+60);
e.Graphics.DrawString ("参与人物",objFont,objBrush ,nLeft+430,nTop+60);
e.Graphics.DrawString ("处理结果",objFont,objBrush ,nLeft+520,nTop+60);
try
{
objSqlConn=new SqlConnection ("Server=(local);database=atorregulate;user id=sa;password=;");
objSqlConn.Open ();
objSqlCommand=new SqlCommand ("Select * from happening",objSqlConn);
objSqlDataReader=objSqlCommand.ExecuteReader ();
int nLine=1;
while(objSqlDataReader.Read ())
{
e.Graphics .DrawString (objSqlDataReader["Hnumber"].ToString (),objFont,objBrush,nLeft+20,nTop+60+nLine*30);
e.Graphics .DrawString (objSqlDataReader["Htitle"].ToString (),objFont,objBrush,nLeft+70,nTop+60+nLine*30);
e.Graphics .DrawString (objSqlDataReader["Hcontent"].ToString (),objFont,objBrush,nLeft+140,nTop+60+nLine*30);
e.Graphics .DrawString (objSqlDataReader["Hdata"].ToString (),objFont,objBrush,nLeft+280,nTop+60+nLine*30);
e.Graphics .DrawString (objSqlDataReader["Hperson"].ToString (),objFont,objBrush,nLeft+430,nTop+60+nLine*30);
e.Graphics .DrawString (objSqlDataReader["Heffecl"].ToString (),objFont,objBrush,nLeft+520,nTop+60+nLine*30);
nLine++;
}
}
catch(SqlException ex)
{
MessageBox.Show (ex.Message );
}
}
private void button2_Click(object sender, System.EventArgs e)
{
string str1=this.comboBox1.Text;
string str2=this.comboBox2.Text;
objSqlConn=new SqlConnection("database=atorregulate;user id=sa;password=;SERVER=(local)");
objSqlConn.Open();
objSqlDataAdapter=new SqlDataAdapter();
objSqlDataAdapter.SelectCommand=new SqlCommand("select Hnumber as 事件编号,Htitle as 标题,Hcontent as 内容,Hdata as 日期, Hperson as 参与人物,Heffecl as 处理结果 from happening where Hdata like '[str1]-[str2]-[%]'",objSqlConn);
objDataSet=new DataSet();
objSqlDataAdapter.Fill(objDataSet,"happening");
//将DATAGRID控件绑定到数据集表
this.dataGrid1.SetDataBinding(objDataSet,"happening");
}
private void button1_Click(object sender, System.EventArgs e)
{
objSqlConn=new SqlConnection("database=atorregulate;user id=sa;password=;SERVER=(local)");
objSqlConn.Open();
objSqlDataAdapter=new SqlDataAdapter();
objSqlDataAdapter.SelectCommand=new SqlCommand("select Hnumber as 事件编号,Htitle as 标题,Hcontent as 内容,Hdata as 日期, Hperson as 参与人物,Heffecl as 处理结果 from happening ",objSqlConn);
objDataSet=new DataSet();
objSqlDataAdapter.Fill(objDataSet,"happening");
//将DATAGRID控件绑定到数据集表
this.dataGrid1.SetDataBinding(objDataSet,"happening");
}
private void printPreviewDialog1_Load(object sender, System.EventArgs e)
{
}
private void ppdlgOrderDatails_Load(object sender, System.EventArgs e)
{
}
}
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?