private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string strsql; strsql = "insert into COST_EXPENSE(CTYPE,TYPE_DES,CMONTH,EXPENSE,NOTE) values('" + comboBoxType.SelectedValue.ToString() + "','" + comboBoxType.Text.ToString() + "','" + dateTimePickerMonth.Text.ToString() + "','" + Common.IsNull(textEditExpense.Text.ToString().Trim()) + "','" + textEditNote.Text.ToString().Trim() + "')"; if (textEditExpense.Text.ToString().Trim() != "") { bool isok = conn.EditDatabase(strsql); if (isok) { MessageBox.Show("添加成功!"); TempEmpExpenseQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } } else { MessageBox.Show("费用金额不能为空!"); } conn.Close(); }
public static TempEmpExpenseQuery GetInstance() { if (weqform == null || weqform.IsDisposed) { weqform = new TempEmpExpenseQuery(); } return(weqform); }
private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e) { TempEmpExpenseQuery Frm = TempEmpExpenseQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); }
private void LineType_Load(object sender, EventArgs e) { this.WindowState = FormWindowState.Maximized; TempEmpExpenseQuery Frm = TempEmpExpenseQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); }
private void TempWorkerPriceUpdate_Load(object sender, EventArgs e) { BindType(); TempEmpExpenseQuery.GetInfo(ref id, ref ctype, ref expense, ref note); if (id != "") { textEditExpense.Text = expense; textEditNote.Text = note; comboBoxType.SelectedIndex = -1; comboBoxType.SelectedValue = ctype; } }
private void barButtonItem修改_ItemClick(object sender, ItemClickEventArgs e) { string id = "", ctype = "", expense = "", note = ""; TempEmpExpenseQuery.GetInfo(ref id, ref ctype, ref expense, ref note); if (id != "") { TempEmpExpenseUpdate Frm = new TempEmpExpenseUpdate(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); } }
private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string sql = "update COST_expense set ctype = '" + comboBoxType.SelectedValue.ToString() + "',type_des = '" + comboBoxType.Text.ToString() + "',cmonth='" + dateTimePickerMonth.Text + "',expense='" + Common.IsNull(textEditExpense.Text.ToString().Trim()) + "',note='" + textEditExpense.Text.ToString().Trim() + "'"; sql = sql + " where cid = '" + id + "'"; bool isok = conn.EditDatabase(sql); if (isok) { MessageBox.Show("修改成功!"); TempEmpExpenseQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } conn.Close(); }
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e) { TempEmpExpenseQuery.RefreshEX(); }