private void ShowDetail() { ConnDB conn = new ConnDB(); string strsql; string yyyymm = "", deptid = "", indirectlabourid = ""; IndirectLabourPriceQuery.GetInfo(ref yyyymm, ref deptid, ref indirectlabourid); if (deptid == "0") { strsql = "select i.indirect_labour_id 员工id,i.yyyymm 年月,i.deptname 部门,i.cno 工号,i.cname 姓名,j.CID,j.CNAME 上班类型,i.price '费率(元/小时)' from (select i.*,j.cno,j.cname,d.cid as deptid,d.cname as deptname from cost_indirect_labour_price i left join cost_direct_labour j on i.indirect_labour_id = j.cid left join cost_dept d on j.dept_id = d.cid where isnull(YYYYMM,'') ='" + yyyymm + "') i left join (select * from COST_WORK_TYPE where forbidden = 'false') j on i.WORK_TYPE_id = j.cid "; } else if (indirectlabourid == "0") { strsql = "select i.indirect_labour_id 员工id,i.yyyymm 年月,i.deptname 部门,i.cno 工号,i.cname 姓名,j.CID,j.CNAME 上班类型,i.price '费率(元/小时)' from (select i.*,j.cno,j.cname,d.cid as deptid,d.cname as deptname from cost_indirect_labour_price i left join cost_direct_labour j on i.indirect_labour_id = j.cid left join cost_dept d on j.dept_id = d.cid where isnull(YYYYMM,'') ='" + yyyymm + "' and j.dept_id = " + deptid + ") i left join (select * from COST_WORK_TYPE where forbidden = 'false') j on i.WORK_TYPE_id = j.cid "; } else { strsql = "select i.indirect_labour_id 员工id,i.yyyymm 年月,i.deptname 部门,i.cno 工号,i.cname 姓名,j.CID,j.CNAME 上班类型,i.price '费率(元/小时)' from (select i.*,j.cno,j.cname,d.cid as deptid,d.cname as deptname from cost_indirect_labour_price i left join cost_direct_labour j on i.indirect_labour_id = j.cid left join cost_dept d on j.dept_id = d.cid where isnull(YYYYMM,'') ='" + yyyymm + "' and j.dept_id = " + deptid + " and indirect_labour_id = " + indirectlabourid + ") i left join (select * from COST_WORK_TYPE where forbidden = 'false') j on i.WORK_TYPE_id = j.cid "; } DataSet ds = conn.ReturnDataSet(strsql); gridControl1.DataSource = ds.Tables[0].DefaultView; gridView1.Columns[0].Visible = false; gridView1.Columns[5].Visible = false; gridView1.Columns[0].OptionsColumn.ReadOnly = true; gridView1.Columns[1].OptionsColumn.ReadOnly = true; gridView1.Columns[2].OptionsColumn.ReadOnly = true; gridView1.Columns[3].OptionsColumn.ReadOnly = true; gridView1.Columns[4].OptionsColumn.ReadOnly = true; gridView1.Columns[5].OptionsColumn.ReadOnly = true; gridView1.Columns[6].OptionsColumn.ReadOnly = true; conn.Close(); }
private void simpleButton复制_Click(object sender, EventArgs e) { MessageBoxButtons messButton = MessageBoxButtons.OKCancel; DialogResult dr = MessageBox.Show("将按最近的月度数据自动新增当前选择月份的数据,确认复制吗?", "复制最近月份数据", messButton); if (dr == DialogResult.OK) { ConnDB conn = new ConnDB(); string strsql; bool isok = false; DateTime dt1 = Convert.ToDateTime(ilpiform.dateTimePicker1.Text); DateTime dt2 = System.DateTime.Now; int month = (dt2.Year - dt1.Year) * 12 + (dt2.Month - dt1.Month); if (!ilpiform.Exist()) { if (month < 0) { MessageBox.Show("不能新增以后的月份!"); } else { strsql = "insert into cost_indirect_labour_price(yyyymm,indirect_labour_id,work_type_id,price) select '" + ilpiform.dateTimePicker1.Text + "',indirect_labour_id,work_type_id,price from cost_indirect_labour_price where YYYYMM = (select Max(yyyymm) from cost_indirect_labour_price) "; isok = conn.EditDatabase(strsql); if (isok) { MessageBox.Show("复制成功!"); IndirectLabourPriceQuery.RefreshEX(); this.Close(); } } } conn.Close(); } }
public static void Save() { ConnDB conn = new ConnDB(); string sql; bool isok = false; if (ilpuform.gridView1.RowCount > 0) { ilpuform.gridView1.FocusInvalidRow(); for (int i = 0; i < ilpuform.gridView1.RowCount; i++) { sql = "update cost_indirect_labour_price set price = " + ilpuform.gridView1.GetDataRow(i).ItemArray[7].ToString() + " where yyyymm = '" + ilpuform.gridView1.GetDataRow(i).ItemArray[1].ToString() + "' and work_type_id = " + ilpuform.gridView1.GetDataRow(i).ItemArray[5].ToString() + " and indirect_labour_id = " + ilpuform.gridView1.GetDataRow(i).ItemArray[0].ToString(); isok = conn.EditDatabase(sql); } } if (isok) { MessageBox.Show("修改成功!"); IndirectLabourPriceQuery.RefreshEX(); ilpuform.Close(); } else { MessageBox.Show("失败!"); } ilpuform.ischange = false; conn.Close(); ilpuform.Close(); IndirectLabourPrice.savetype = "insert"; }
public static IndirectLabourPriceQuery GetInstance() { if (ilpqform == null || ilpqform.IsDisposed) { ilpqform = new IndirectLabourPriceQuery(); } return(ilpqform); }
private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e) { IndirectLabourPriceQuery Frm = IndirectLabourPriceQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); }
private void IndirectLabourPrice_Load(object sender, EventArgs e) { this.WindowState = FormWindowState.Maximized; IndirectLabourPriceQuery Frm = IndirectLabourPriceQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); }
public static void Save() { if (ilpiform == null || ilpiform.IsDisposed) { } else { //ilpiform.gridView1.UpdateCurrentRow(); ConnDB conn = new ConnDB(); string strsql; bool isok = false; DateTime dt1 = Convert.ToDateTime(ilpiform.dateTimePicker1.Text); DateTime dt2 = System.DateTime.Now; int month = (dt2.Year - dt1.Year) * 12 + (dt2.Month - dt1.Month); if (!ilpiform.Exist()) { if (month < 0) { MessageBox.Show("不能新增以后的月份!"); } else if (ilpiform.comboBoxDept.SelectedValue.ToString() == "0") { MessageBox.Show("请选择部门!"); } else if (ilpiform.comboBoxIndirectLabour.SelectedValue.ToString() == "0") { MessageBox.Show("请选择人员!"); } else { ilpiform.gridView1.FocusInvalidRow(); for (int i = 0; i < ilpiform.gridView1.RowCount; i++) { strsql = "insert into cost_indirect_labour_price(yyyymm,indirect_labour_id,work_type_id,price) values('" + ilpiform.dateTimePicker1.Text.ToString() + "'," + ilpiform.comboBoxIndirectLabour.SelectedValue.ToString() + "," + ilpiform.gridView1.GetDataRow(i).ItemArray[2].ToString() + "," + ilpiform.gridView1.GetDataRow(i).ItemArray[4].ToString() + ")"; isok = conn.EditDatabase(strsql); //MessageBox.Show(ilpiform.gridView1.GetRowCellValue(i, "费率").ToString()); } if (isok) { MessageBox.Show("保存成功!"); IndirectLabourPriceQuery.RefreshEX(); } } } ilpiform.ischange = false; conn.Close(); } }
private void barButtonItem删除_ItemClick(object sender, ItemClickEventArgs e) { IndirectLabourPriceQuery.Delete(); IndirectLabourPriceQuery.RefreshEX(); }