private void simpleButtonOK_Click(object sender, EventArgs e)
{
ConnDB conn = new ConnDB();
string strsql;
strsql = "insert into COST_EXPENSE(CTYPE,TYPE_DES,CMONTH,EXPENSE,NOTE) values('" + comboBoxType.SelectedValue.ToString() + "','" + comboBoxType.Text.ToString() + "','" + dateTimePickerMonth.Text.ToString() + "','" + Common.IsNull(textEditExpense.Text.ToString().Trim()) + "','" + textEditNote.Text.ToString().Trim() + "')";
if (textEditExpense.Text.ToString().Trim() != "")
{
bool isok = conn.EditDatabase(strsql);
if (isok)
{
MessageBox.Show("添加成功！");
TempEmpExpenseQuery.RefreshEX();
this.Close();
}
else
{
MessageBox.Show("失败！");
}
}
else
{
MessageBox.Show("费用金额不能为空！");
}
conn.Close();
}
public static TempEmpExpenseQuery GetInstance()
{
if (weqform == null || weqform.IsDisposed)
{
weqform = new TempEmpExpenseQuery();
}
return(weqform);
}
private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e)
{
TempEmpExpenseQuery Frm = TempEmpExpenseQuery.GetInstance();
Frm.TopLevel = false;
Frm.Parent = this;
Frm.Show();
Frm.BringToFront();
}
private void LineType_Load(object sender, EventArgs e)
{
this.WindowState = FormWindowState.Maximized;
TempEmpExpenseQuery Frm = TempEmpExpenseQuery.GetInstance();
Frm.TopLevel = false;
Frm.Parent = this;
Frm.Show();
Frm.BringToFront();
}
private void TempWorkerPriceUpdate_Load(object sender, EventArgs e)
{
BindType();
TempEmpExpenseQuery.GetInfo(ref id, ref ctype, ref expense, ref note);
if (id != "")
{
textEditExpense.Text = expense;
textEditNote.Text = note;
comboBoxType.SelectedIndex = -1;
comboBoxType.SelectedValue = ctype;
}
}
private void barButtonItem修改_ItemClick(object sender, ItemClickEventArgs e)
{
string id = "", ctype = "", expense = "", note = "";
TempEmpExpenseQuery.GetInfo(ref id, ref ctype, ref expense, ref note);
if (id != "")
{
TempEmpExpenseUpdate Frm = new TempEmpExpenseUpdate();
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_expense set ctype = '" + comboBoxType.SelectedValue.ToString() + "',type_des = '" + comboBoxType.Text.ToString() + "',cmonth='" + dateTimePickerMonth.Text + "',expense='" + Common.IsNull(textEditExpense.Text.ToString().Trim()) + "',note='" + textEditExpense.Text.ToString().Trim() + "'";
sql = sql + " where cid = '" + id + "'";
bool isok = conn.EditDatabase(sql);
if (isok)
{
MessageBox.Show("修改成功！");
TempEmpExpenseQuery.RefreshEX();
this.Close();
}
else
{
MessageBox.Show("失败！");
}
conn.Close();
}
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e)
{
TempEmpExpenseQuery.RefreshEX();
}
