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 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();
}
