private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string strsql, strsql2; int rows; strsql = "insert into cost_temp_worker(cdate,sale_type_id,dept_id,labour_num,hours) values('" + dateEditDate.Text.ToString() + "','" + Common.IsZero(comboBoxSaleType.SelectedValue.ToString()) + "','" + Common.IsZero(comboBoxDept.SelectedValue.ToString()) + "'," + Common.IsNull(textEditLabourNum.Text.ToString().Trim()) + "," + textEditHours.Text.ToString().Trim() + ")"; strsql2 = "select cdate from cost_temp_worker where cdate ='" + dateEditDate.Text.ToString() + "' and sale_type_id = " + comboBoxSaleType.SelectedValue.ToString() + " and dept_id = " + comboBoxDept.SelectedValue.ToString(); if (textEditHours.Text.ToString() != "") { rows = conn.ReturnRecordCount(strsql2); if (rows > 0) { MessageBox.Show("此日期记录已经存在!"); } else { bool isok = conn.EditDatabase(strsql); if (isok) { MessageBox.Show("添加成功!"); TempWorkerQuery.RefreshEX(); this.Close(); } } } else { MessageBox.Show("投入工时不能为空!"); } conn.Close(); }
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e) { TempWorkerQuery.RefreshEX(); }