private void simpleButtonOK_Click(object sender, EventArgs e)
{
ConnDB conn = new ConnDB();
string sql = "update COST_TEMP_WORKER_PRICE set price = ltrim(rtrim('" + textEditTempWorkerPrice.Text.ToString() + "'))";
sql = sql + " where cid = " + textEditID.Text.ToString();
bool isok = conn.EditDatabase(sql);
if (isok)
{
MessageBox.Show("修改成功！");
TempWorkerPriceQuery.RefreshEX();
this.Close();
}
else
{
MessageBox.Show("失败！");
}
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, strsql2;
int rows;
bool isok = false;
DateTime dt1 = Convert.ToDateTime(dateTimePicker1.Text);
DateTime dt2 = System.DateTime.Now;
int month = (dt2.Year - dt1.Year) * 12 + (dt2.Month - dt1.Month);
strsql2 = "select yyyymm from COST_TEMP_WORKER_PRICE where yyyymm ='" + dateTimePicker1.Text.ToString() + "'";
rows = conn.ReturnRecordCount(strsql2);
if (rows > 0)
{
MessageBox.Show("该月度临时工费率已经存在！");
}
else if (month < -1)
{
MessageBox.Show("月份错误！");
}
else
{
strsql = "insert into COST_TEMP_WORKER_PRICE(yyyymm,sale_type_id,price) select '" + dateTimePicker1.Text + "',sale_type_id,price from COST_TEMP_WORKER_PRICE where YYYYMM = (select Max(yyyymm) from COST_TEMP_WORKER_PRICE) ";
isok = conn.EditDatabase(strsql);
if (isok)
{
MessageBox.Show("复制成功！");
TempWorkerPriceQuery.RefreshEX();
this.Close();
}
}
conn.Close();
}
}
private void simpleButtonOK_Click(object sender, EventArgs e)
{
ConnDB conn = new ConnDB();
string strsql, strsql2;
int rows;
strsql = "insert into COST_TEMP_WORKER_PRICE(yyyymm,sale_type_id,price) values('" + dateTimePicker1.Text.ToString() + "'," + comboBoxSaleType.SelectedValue + "," + textEditTempWorkerPrice.Text.ToString().Trim() + ")";
strsql2 = "select yyyymm from COST_TEMP_WORKER_PRICE where yyyymm ='" + dateTimePicker1.Text.ToString() + "' and sale_type_id = " + comboBoxSaleType.SelectedValue;
if (textEditTempWorkerPrice.Text.ToString() != "")
{
rows = conn.ReturnRecordCount(strsql2);
if (rows > 0)
{
MessageBox.Show("该临时工费率已经存在！");
}
else
{
bool isok = conn.EditDatabase(strsql);
if (isok)
{
MessageBox.Show("添加成功！");
TempWorkerPriceQuery.RefreshEX();
this.Close();
}
else
{
MessageBox.Show("失败！");
}
}
}
else
{
MessageBox.Show("费率不能为空！");
}
conn.Close();
}
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e)
{
TempWorkerPriceQuery.RefreshEX();
}