public static DirectLabourQuery GetInstance() { if (dlqform == null || dlqform.IsDisposed) { dlqform = new DirectLabourQuery(); } return(dlqform); }
private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e) { DirectLabourQuery Frm = DirectLabourQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); }
private void LineType_Load(object sender, EventArgs e) { this.WindowState = FormWindowState.Maximized; DirectLabourQuery Frm = DirectLabourQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); //Frm.Width = this.Width - 15; //Frm.Height = this.Width - 60; }
private void barButtonItem修改_ItemClick(object sender, ItemClickEventArgs e) { string cno = "", cname = "", positionname = "", linetypename = "", deptname = ""; int id = 0, positionid = 0, linetypeid = 0, deptid = 0; DirectLabourQuery.GetInfo(ref id, ref cno, ref cname, ref deptid, ref deptname, ref positionid, ref positionname, ref linetypeid, ref linetypename); if (cno != "") { DirectLabourUpdate Frm = new DirectLabourUpdate(); 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_direct_labour set cno = ltrim(rtrim('" + textEditNo.Text.ToString().Trim() + "')),cname = ltrim(rtrim('" + textEditName.Text.ToString().Trim() + "')),position_id = " + Common.IsZero(comboBoxPosition.SelectedValue.ToString()) + ",linetype_id =" + Common.IsZero(comboBoxLineType.SelectedValue.ToString()) + ",dept_id =" + comboBoxDept.SelectedValue.ToString(); sql = sql + " where cid = " + textEditID.Text.ToString(); string sql2 = "select cname from cost_direct_labour where cno = '" + textEditNo.Text.ToString().Trim() + "' and cid <> " + textEditID.Text; string sql3 = "select * from cost_direct_labour where cno = '" + textEditNo.Text.ToString().Trim() + "' and cname ='" + textEditName.Text.ToString().Trim() + "' and position_id = " + comboBoxPosition.SelectedValue.ToString() + " and linetype_id =" + comboBoxLineType.SelectedValue.ToString() + " and dept_id =" + comboBoxDept.SelectedValue.ToString(); if (textEditNo.Text.ToString().Trim() != "" && textEditName.Text.ToString().Trim() != "" && comboBoxPosition.SelectedValue.ToString() != "0" && comboBoxDept.SelectedValue.ToString() != "0") { int rows = conn.ReturnRecordCount(sql2); int rows2 = conn.ReturnRecordCount(sql3); if (rows > 0) { MessageBox.Show("该工号已经存在!"); } else if (rows2 > 0) { MessageBox.Show("该人员已经存在!"); } else { bool isok = conn.EditDatabase(sql); if (isok) { MessageBox.Show("修改成功!"); DirectLabourQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } } } else { MessageBox.Show("不能为空值!"); } conn.Close(); }
private void DirectLabourUpdate_Load(object sender, EventArgs e) { string cno = "", cname = "", positionname = "", linetypename = "", deptname = ""; int id = 0, positionid = 0, linetypeid = 0, deptid = 0; DirectLabourQuery.GetInfo(ref id, ref cno, ref cname, ref deptid, ref deptname, ref positionid, ref positionname, ref linetypeid, ref linetypename); PositionBind(); Common.BasicDataBind("cost_dept", comboBoxDept); ConnDB conn = new ConnDB(); string sql = "select * from cost_dept where cid = " + deptid + " and isnull(forbidden,'false') = 'true'"; int rows = conn.ReturnRecordCount(sql); string sql2 = "select * from cost_position where cid = " + positionid + " and isnull(forbidden,'false') = 'true'"; int rows2 = conn.ReturnRecordCount(sql); string sql3 = "select * from COST_LINETYPE where cid = " + linetypeid + " and isnull(forbidden,'false') = 'true'"; int rows3 = conn.ReturnRecordCount(sql); if (cno != "") { textEditNo.Text = cno; textEditName.Text = cname; if (rows == 0) { comboBoxDept.SelectedIndex = -1; comboBoxDept.SelectedValue = deptid; } if (rows2 == 0) { comboBoxPosition.SelectedIndex = -1; comboBoxPosition.SelectedValue = positionid; } LineTypeBind(); if (rows3 == 0) { comboBoxLineType.SelectedIndex = -1; comboBoxLineType.SelectedValue = linetypeid; } textEditID.Text = id.ToString(); } }
private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string strsql, strsql2; int rows; strsql = "insert into cost_direct_labour(CNO,CNAME,DEPT_ID,POSITION_ID,LINETYPE_ID,PERSON_TYPE_ID,FORBIDDEN) values(LTRIM(rtrim('" + textEditNo.Text.ToString() + "')),LTRIM(rtrim('" + textEditName.Text.ToString() + "'))," + comboBoxDept.SelectedValue.ToString() + "," + comboBoxPosition.SelectedValue.ToString() + "," + Common.IsZero(comboBoxLineType.SelectedValue.ToString()) + ",3,0)"; strsql2 = "select cname from cost_direct_labour where cno = LTRIM(rtrim('" + textEditNo.Text.ToString().Trim() + "'))"; if (textEditNo.Text.ToString().Trim() != "") { rows = conn.ReturnRecordCount(strsql2); if (rows > 0) { MessageBox.Show("该人员已经存在!"); } else { bool isok = conn.EditDatabase(strsql); if (isok) { MessageBox.Show("添加成功!"); DirectLabourQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } } } else { MessageBox.Show("工号不能为空!"); } conn.Close(); }
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e) { DirectLabourQuery.RefreshEX(); }