📄 jzgl.cs
字号:
this.textBox7.Name = "textBox7";
this.textBox7.Size = new System.Drawing.Size(128, 21);
this.textBox7.TabIndex = 26;
this.textBox7.Text = "textBox7";
//
// label9
//
this.label9.Location = new System.Drawing.Point(424, 216);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(64, 16);
this.label9.TabIndex = 27;
this.label9.Text = "证件号码";
//
// textBox8
//
this.textBox8.Location = new System.Drawing.Point(488, 216);
this.textBox8.Name = "textBox8";
this.textBox8.Size = new System.Drawing.Size(208, 21);
this.textBox8.TabIndex = 28;
this.textBox8.Text = "textBox8";
//
// checkBox1
//
this.checkBox1.Location = new System.Drawing.Point(88, 248);
this.checkBox1.Name = "checkBox1";
this.checkBox1.TabIndex = 29;
this.checkBox1.Text = "是否结清";
//
// button2
//
this.button2.Location = new System.Drawing.Point(232, 248);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(184, 23);
this.button2.TabIndex = 30;
this.button2.Text = "确认";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// dgrd_StockerData
//
this.dgrd_StockerData.AlternatingBackColor = System.Drawing.Color.GhostWhite;
this.dgrd_StockerData.BackColor = System.Drawing.Color.GhostWhite;
this.dgrd_StockerData.BackgroundColor = System.Drawing.Color.Lavender;
this.dgrd_StockerData.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.dgrd_StockerData.CaptionBackColor = System.Drawing.Color.RoyalBlue;
this.dgrd_StockerData.CaptionForeColor = System.Drawing.Color.White;
this.dgrd_StockerData.DataMember = "";
this.dgrd_StockerData.FlatMode = true;
this.dgrd_StockerData.Font = new System.Drawing.Font("Tahoma", 8F);
this.dgrd_StockerData.ForeColor = System.Drawing.Color.MidnightBlue;
this.dgrd_StockerData.GridLineColor = System.Drawing.Color.RoyalBlue;
this.dgrd_StockerData.HeaderBackColor = System.Drawing.Color.MidnightBlue;
this.dgrd_StockerData.HeaderFont = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
this.dgrd_StockerData.HeaderForeColor = System.Drawing.Color.Lavender;
this.dgrd_StockerData.LinkColor = System.Drawing.Color.Teal;
this.dgrd_StockerData.Location = new System.Drawing.Point(16, 280);
this.dgrd_StockerData.Name = "dgrd_StockerData";
this.dgrd_StockerData.ParentRowsBackColor = System.Drawing.Color.Lavender;
this.dgrd_StockerData.ParentRowsForeColor = System.Drawing.Color.MidnightBlue;
this.dgrd_StockerData.SelectionBackColor = System.Drawing.Color.Teal;
this.dgrd_StockerData.SelectionForeColor = System.Drawing.Color.PaleGreen;
this.dgrd_StockerData.Size = new System.Drawing.Size(688, 128);
this.dgrd_StockerData.TabIndex = 41;
//
// jzgl
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(716, 421);
this.Controls.Add(this.dgrd_StockerData);
this.Controls.Add(this.button2);
this.Controls.Add(this.checkBox1);
this.Controls.Add(this.textBox8);
this.Controls.Add(this.label9);
this.Controls.Add(this.textBox7);
this.Controls.Add(this.textBox6);
this.Controls.Add(this.label8);
this.Controls.Add(this.label7);
this.Controls.Add(this.textBox5);
this.Controls.Add(this.label6);
this.Controls.Add(this.textBox4);
this.Controls.Add(this.label5);
this.Controls.Add(this.textBox3);
this.Controls.Add(this.label4);
this.Controls.Add(this.richTextBox1);
this.Controls.Add(this.label3);
this.Controls.Add(this.textBox2);
this.Controls.Add(this.label2);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.label1);
this.Controls.Add(this.button1);
this.Controls.Add(this.comboBox1);
this.Controls.Add(this.toolBar1);
this.Name = "jzgl";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "【结帐登记】";
this.Load += new System.EventHandler(this.jzgl_Load);
((System.ComponentModel.ISupportInitialize)(this.dgrd_StockerData)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void jzgl_Load(object sender, System.EventArgs e)
{
textBox1.Text=textBox2.Text=textBox3.Text=textBox4.Text=textBox5.Text=textBox6.Text=textBox7.Text=textBox8.Text=richTextBox1.Text="";
checkBox1.Checked= false;
button2.Enabled=false;
scfjh();
}
private void scfjh() //生成房间号
{
string sendTableName = "jud_ts";
string kong="挂 账";
string sendStrSQL ="select pzhm from jud_ts where jkfs like'"+kong+"'";
this.ds = this.link.SelectDataBase(sendStrSQL,sendTableName);
comboBox1.DataSource = ds.Tables[sendTableName];
comboBox1.DisplayMember = "pzhm";
}
private void button2_Click(object sender, System.EventArgs e)
{
string sfjq="";
if(checkBox1.Checked==true)
{
//结清欠款需要更新退宿表里付款方式为结 帐
que=true;
sfjq="1";
}
else{sfjq="0";}
double zk =double.Parse(textBox3.Text);
double hk =double.Parse(textBox5.Text);
double qk =zk-hk;
DateTime dt = DateTime.Now;
DataTable ordersTable = ds1.Tables["jud_gzxx"];
DataRow workRow = ds1.Tables["jud_gzxx"].NewRow();
int yue =dt.Month;
string yue1;
if (yue<10)
{ yue1="0"+yue.ToString();}
else{yue1=yue.ToString();}
int day =dt.Day;
string day1;
if (day<10)
{day1="0"+day.ToString();}
else{day1=day.ToString();}
int hour=dt.Hour;
int min=dt.Minute;
int sec=dt.Second;
string hour1;
string min1;
string sec1;
if (hour<10)
{hour1="0"+hour.ToString();}
else{hour1=hour.ToString();}
if (min<10)
{min1="0"+min.ToString();}
else{min1=min.ToString();}
if (sec<10)
{sec1="0"+sec.ToString();}
else{sec1=sec.ToString();}
string pz ="GZ"+dt.Year.ToString()+yue1+day1+hour1+min1+sec1;
workRow[0] = pz;
workRow[1] = comboBox1.Text;
workRow[2] = textBox1.Text;
workRow[3] = textBox2.Text;
workRow[4] = richTextBox1.Text;
workRow[5] = textBox3.Text;
workRow[6] = qk.ToString();
workRow[7] = textBox5.Text;
workRow[8] = "0";
workRow[9] = textBox6.Text;
workRow[10] = textBox7.Text;
workRow[11] = textBox8.Text;
workRow[12] = hour1+":"+min1+":"+sec1;
workRow[13] = sfjq;
ds1.Tables["jud_gzxx"].Rows.Add(workRow);
textBox1.Text=textBox2.Text=textBox3.Text=textBox4.Text=textBox5.Text=textBox6.Text=textBox7.Text=textBox8.Text=richTextBox1.Text="";
checkBox1.Checked= false;
button2.Enabled=false;
scfjh();
}
private void gengxin(string pz)
{
string sendTableName = "jud_ts";
string jkfs="结 帐";
string sendStrSQL ="update jud_ts set jkfs='"+jkfs+"' where pzhm='"+pz+"'";
this.ds4 = this.link4.SelectDataBase(sendStrSQL,sendTableName);
}
private void button1_Click(object sender, System.EventArgs e)
{
string sendTableName = "jud_ts";
string kong=comboBox1.Text;
string sendStrSQL ="select tsrq,jezj,xm from jud_ts where pzhm='"+kong+"'";
this.ds2 = this.link2.SelectDataBase(sendStrSQL,sendTableName);
textBox1.DataBindings.Add("Text",ds2,"jud_ts.tsrq");
textBox3.DataBindings.Add("Text",ds2,"jud_ts.jezj");
textBox6.DataBindings.Add("Text",ds2,"jud_ts.xm");
button2.Enabled = true;
qk();
}
private void qk()
{
string sendTableName = "jud_gzxx";
string kong=comboBox1.Text;
string sendStrSQL ="select pzhm,sum(qkje) as qkje from jud_gzxx where pzhm='"+kong+"'group by pzhm ";
this.ds3 = this.link3.SelectDataBase(sendStrSQL,sendTableName);
int intRowNumber = this.ds3.Tables[0].Rows.Count;
if (intRowNumber>0)
{
DataRow workrow=this.ds3.Tables[0].Rows[intRowNumber-1];
textBox4.Text = workrow[1].ToString();
}
else
{
textBox4.Text="0";
}
}
private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
{
DateTime dt = DateTime.Now;
string shijian = dt.Year.ToString()+"-"+dt.Month.ToString()+"-"+dt.Day.ToString();
string sendTableName="jud_gzxx";
if (e.Button.ToolTipText == "保存修改")
{
try
{
int row = this.dgrd_StockerData.CurrentCell.RowNumber;
//将当前所在行往下移动一行,为便于实现同步保存
//(否则会出现修改的最后一行无法保存,因为它还处于编辑状态)
this.dgrd_StockerData.CurrentCell = new DataGridCell(row+1,0);
if (this.ds1.HasChanges())
{
this.link1.UpdateDataBase(this.ds1.GetChanges(),sendTableName);
MessageBox.Show("数据修改成功!","信息");
string tempStrSQL ="select bh as '编号',pzhm as '凭证号码',rq as '日期',dwbh as '单位名称',zy as '摘要',zsje as '住宿金额',qkje as '欠款金额',hkje as '还款金额',jelj as '金额累计',xm as '姓名',zjmc as '证件名称',zjhm as '证件号码',sj as '时间',sfjq as '是否结清' from jud_gzxx where rq>='"+shijian+"'";
this.link1.SelectDataBase(tempStrSQL,sendTableName);
scfjh();
if (que==true)
{
gengxin(comboBox1.Text);
}
}
else
{
MessageBox.Show("没有修改的数据!");
return;
}
}
catch(Exception ex)
{
MessageBox.Show("数据保存失败,请确认所有信息输入完整且正确!"+ex,"提示");
return;
}
}
if (e.Button.ToolTipText == "删除数据")
{
if (MessageBox.Show("确实要删除这条记录吗?","询问",MessageBoxButtons.YesNo) == DialogResult.Yes)
{
int intRowNumber = this.dgrd_StockerData.CurrentCell.RowNumber;
try
{
DataRow workrow=this.ds1.Tables[0].Rows[intRowNumber];
string fjh = workrow[2].ToString();
this.ds1.Tables[0].Rows[intRowNumber].Delete();
this.link1.UpdateDataBase(this.ds1.GetChanges(),sendTableName);
MessageBox.Show("数据删除成功!","信息");
string tempStrSQL ="select bh as '编号',pzhm as '凭证号码',rq as '日期',dwbh as '单位名称',zy as '摘要',zsje as '住宿金额',qkje as '欠款金额',hkje as '还款金额',jelj as '金额累计',xm as '姓名',zjmc as '证件名称',zjhm as '证件号码',sj as '时间',sfjq as '是否结清' from jud_gzxx where rq>='"+shijian+"'";
this.link1.SelectDataBase(tempStrSQL,sendTableName);
scfjh();
}
catch(Exception ex)
{
MessageBox.Show("该数据不能删除!"+ex,"提示");
string tempStrSQL ="select bh as '编号',pzhm as '凭证号码',rq as '日期',dwbh as '单位名称',zy as '摘要',zsje as '住宿金额',qkje as '欠款金额',hkje as '还款金额',jelj as '金额累计',xm as '姓名',zjmc as '证件名称',zjhm as '证件号码',sj as '时间',sfjq as '是否结清' from jud_gzxx where rq>='"+shijian+"'";
this.link1.SelectDataBase(tempStrSQL,sendTableName);
return;
}
}
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -