private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string sql = "update COST_EXPENSE set emp_no = '" + textEditEmpno.Text.ToString().Trim() + "',begin_date = '" + dateTimePickerDate.Text + "',expense='" + Common.IsNull(textEditPrice.Text.ToString().Trim()) + "'"; sql = sql + " where cid = '" + id + "'"; string sql2 = "select * from COST_EXPENSE where cid <> '" + id + "' and emp_no = '" + textEditEmpno.Text.ToString().Trim() + "' and begin_date = '" + dateTimePickerDate.Text.ToString() + "' and ctype =2"; int rows = conn.ReturnRecordCount(sql2); if (rows > 0) { MessageBox.Show("该员工这天的交通补贴信息已经存在!"); } else { bool isok = conn.EditDatabase(sql); if (isok) { MessageBox.Show("修改成功!"); TempEmpTravelExpenseQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } } conn.Close(); }
public static TempEmpTravelExpenseQuery GetInstance() { if (weqform == null || weqform.IsDisposed) { weqform = new TempEmpTravelExpenseQuery(); } return(weqform); }
private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e) { TempEmpTravelExpenseQuery Frm = TempEmpTravelExpenseQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); }
private void LineType_Load(object sender, EventArgs e) { this.WindowState = FormWindowState.Maximized; TempEmpTravelExpenseQuery Frm = TempEmpTravelExpenseQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); }
private void TempWorkerPriceUpdate_Load(object sender, EventArgs e) { TempEmpTravelExpenseQuery.GetInfo(ref id, ref empno, ref name, ref begin_date, ref expense); if (id != "") { textEditEmpno.Text = empno; textEditName.Text = name; dateTimePickerDate.Text = begin_date; textEditPrice.Text = expense; } }
private void barButtonItem修改_ItemClick(object sender, ItemClickEventArgs e) { string id = "", empno = "", name = "", begin_date = "", expense = "0"; TempEmpTravelExpenseQuery.GetInfo(ref id, ref empno, ref name, ref begin_date, ref expense); if (id != "") { TempEmpTravelExpenseUpdate Frm = new TempEmpTravelExpenseUpdate(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); } }
private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string strsql, strsql2; int rows; strsql = "insert into COST_EXPENSE(CTYPE,TYPE_DES,BEGIN_DATE,EMP_NO,EXPENSE) values(2,'交通补贴','" + dateTimePickerBegin.Text.ToString() + "','" + textEditEmpno.Text.ToString().Trim() + "','" + textEditPrice.Text.ToString().Trim() + "')"; strsql2 = "select EXPENSE from COST_EXPENSE where ctype =2 and emp_no ='" + textEditEmpno.Text.ToString().Trim() + "' and begin_date = '" + dateTimePickerBegin.Text.ToString() + "'"; if (textEditEmpno.Text.ToString().Trim() != "") { rows = conn.ReturnRecordCount(strsql2); if (rows > 0) { MessageBox.Show("该员工此日期的交通补贴已经存在!"); } else { bool isok = conn.EditDatabase(strsql); if (isok) { MessageBox.Show("添加成功!"); TempEmpTravelExpenseQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } } } else { MessageBox.Show("工号不能为空!"); } conn.Close(); }
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e) { TempEmpTravelExpenseQuery.RefreshEX(); }