private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string strsql, strsql2; int rows; strsql = "insert into cost_ems_hh_hours(cdate,hours) values('" + dateEditDate.Text.ToString() + "',ltrim(rtrim(" + textEditHours.Text.ToString() + ")))"; strsql2 = "select cdate from cost_ems_hh_hours where cdate ='" + dateEditDate.Text.ToString() + "'"; if (textEditHours.Text.ToString() != "") { rows = conn.ReturnRecordCount(strsql2); if (rows > 0) { MessageBox.Show("此日期产出工时已经存在!"); } else { bool isok = conn.EditDatabase(strsql); if (isok) { MessageBox.Show("添加成功!"); EmsHhHoursQuery.RefreshEX(); } } } else { MessageBox.Show("产出工时不能为空!"); } conn.Close(); }
public static EmsHhHoursQuery GetInstance() { if (ehqform == null || ehqform.IsDisposed) { ehqform = new EmsHhHoursQuery(); } return(ehqform); }
private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e) { EmsHhHoursQuery Frm = EmsHhHoursQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); }
private void SteelNetRate_Load(object sender, EventArgs e) { this.WindowState = FormWindowState.Maximized; EmsHhHoursQuery Frm = EmsHhHoursQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); }
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e) { EmsHhHoursQuery.RefreshEX(); }