private void 销售明细维护_Load(object sender, EventArgs e)
{
//获取销售名单
cmbUserName.DisplayMember = "UserName";
cmbUserName.ValueMember = "id";
cmbUserName.DataSource = new T_UsersTableAdapter().GetSalers();
cmbUserName.SelectedIndex = -1;
if (mId == -1)
{
}
else
{
DataTable dt = new DataTable();
dt = new T_OfficeExpensesTableAdapter().GetDataById(mId);
if (dt.Rows.Count > 0)
{
var mRow = (销售管理.DAL.DataSetOfficeExpenses.T_OfficeExpensesRow)dt.Rows[0];
cmbUserName.SelectedValue = mRow.UserName;
dtpDate1.Value = mRow.SalaryDate;
Txt1.Text = mRow.Price1.ToString("0.00");
Txt2.Text = mRow.Price2.ToString("0.00");
Txt3.Text = mRow.Price3.ToString("0.00");
Txt4.Text = mRow.Price4.ToString("0.00");
Txt5.Text = mRow.Price5.ToString("0.00");
TxtSumMoney.Text = mRow.SumMoney.ToString("0.00");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cmbUserName.SelectedIndex == -1)
{
toolTip1.Show("请选择销售名称！", cmbUserName, 0, cmbUserName.Height, 2000);
return;
}
if (string.IsNullOrEmpty(dtpDate1.Text.Trim()) == true)
{
toolTip1.Show("请输入费用分摊日期！", dtpDate1, 0, dtpDate1.Height, 2000);
return;
}
if (string.IsNullOrEmpty(Txt1.Text.Trim()) == true)
{
toolTip1.Show("请输入" + lb1.Text, Txt1, 0, Txt1.Height, 2000);
return;
}
if (Classes.PubClass.IsDecimalSign(Txt1.Text.Trim()) == false)
{
toolTip1.Show(lb1.Text + "输入不合法", Txt1, 0, Txt1.Height, 2000);
return;
}
if (string.IsNullOrEmpty(Txt2.Text.Trim()) == true)
{
toolTip1.Show("请输入" + lb2.Text, Txt2, 0, Txt2.Height, 2000);
return;
}
if (Classes.PubClass.IsDecimalSign(Txt2.Text.Trim()) == false)
{
toolTip1.Show(lb2.Text + "输入不合法", Txt2, 0, Txt2.Height, 2000);
return;
}
if (string.IsNullOrEmpty(Txt3.Text.Trim()) == true)
{
toolTip1.Show("请输入" + lb3.Text, Txt3, 0, Txt1.Height, 2000);
return;
}
if (Classes.PubClass.IsDecimalSign(Txt3.Text.Trim()) == false)
{
toolTip1.Show(lb3.Text + "输入不合法", Txt3, 0, Txt3.Height, 2000);
return;
}
if (string.IsNullOrEmpty(Txt4.Text.Trim()) == true)
{
toolTip1.Show("请输入" + lb4.Text, Txt4, 0, Txt4.Height, 2000);
return;
}
if (Classes.PubClass.IsDecimalSign(Txt4.Text.Trim()) == false)
{
toolTip1.Show(lb4.Text + "输入不合法", Txt1, 0, Txt4.Height, 2000);
return;
}
if (string.IsNullOrEmpty(Txt5.Text.Trim()) == true)
{
toolTip1.Show("请输入" + lb5.Text, Txt5, 0, Txt5.Height, 2000);
return;
}
if (Classes.PubClass.IsDecimalSign(Txt5.Text.Trim()) == false)
{
toolTip1.Show(lb5.Text + "输入不合法", Txt5, 0, Txt5.Height, 2000);
return;
}
int ret = 0;
if (mId == -1)
{
ret = new T_OfficeExpensesTableAdapter().Insert1((long)cmbUserName.SelectedValue, Convert.ToDecimal(Txt1.Text), Convert.ToDecimal(Txt2.Text), Convert.ToDecimal(Txt3.Text), Convert.ToDecimal(Txt4.Text), Convert.ToDecimal(Txt5.Text), Convert.ToDecimal(TxtSumMoney.Text), dtpDate1.Value.Date);
}
else
{
ret = new T_OfficeExpensesTableAdapter().UpdateById((long)cmbUserName.SelectedValue, Convert.ToDecimal(Txt1.Text), Convert.ToDecimal(Txt2.Text), Convert.ToDecimal(Txt3.Text), Convert.ToDecimal(Txt4.Text), Convert.ToDecimal(Txt5.Text), Convert.ToDecimal(TxtSumMoney.Text), dtpDate1.Value.Date, mId);
}
if (ret > 0)
{
MessageBox.Show("保存成功");
btnSave.Enabled = false;
return;
}
else
{
MessageBox.Show("保存失败");
return;
}
}
