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_TravelExpensesTableAdapter().GetDataById(mId);
if (dt.Rows.Count > 0)
{
var mRow = (销售管理.DAL.DataSetTravelExpenses.T_TravelExpensesRow)dt.Rows[0];
cmbUserName.SelectedValue = mRow.UserName;
cmbCustomerName.SelectedValue = mRow.CustomerName;
TxtPorjectName.Text = mRow.ProjectName.ToString();
Txt1.Text = mRow.Price1.ToString("0.00");
Txt2.Text = mRow.Price2.ToString("0.00");
TxtSumMoney.Text = mRow.SumMoney.ToString("0.00");
dtpDate1.Value = mRow.SalaryDate;
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cmbUserName.SelectedIndex == -1)
{
toolTip1.Show("请选择销售名称！", cmbUserName, 0, cmbUserName.Height, 2000);
return;
}
if (string.IsNullOrEmpty(cmbCustomerName.Text.Trim()) == true)
{
toolTip1.Show("请选择客户名称！", cmbCustomerName, 0, cmbCustomerName.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(TxtSumMoney.Text.Trim()) == true)
{
toolTip1.Show("请输入" + lb3.Text, TxtSumMoney, 0, Txt1.Height, 2000);
return;
}
if (Classes.PubClass.IsDecimalSign(TxtSumMoney.Text.Trim()) == false)
{
toolTip1.Show(lb3.Text + "输入不合法", TxtSumMoney, 0, TxtSumMoney.Height, 2000);
return;
}
int ret = 0;
if (mId == -1)
{
ret = new T_TravelExpensesTableAdapter().Insert((long)cmbUserName.SelectedValue, (long)cmbCustomerName.SelectedValue, TxtPorjectName.Text, Convert.ToDecimal(Txt1.Text), Convert.ToDecimal(Txt2.Text), Convert.ToDecimal(TxtSumMoney.Text), dtpDate1.Value.Date);
}
else
{
ret = new T_TravelExpensesTableAdapter().UpdateById((long)cmbUserName.SelectedValue, (long)cmbCustomerName.SelectedValue, TxtPorjectName.Text, Convert.ToDecimal(Txt1.Text), Convert.ToDecimal(Txt2.Text), Convert.ToDecimal(TxtSumMoney.Text), dtpDate1.Value.Date, mId);
}
if (ret > 0)
{
MessageBox.Show("保存成功");
btnSave.Enabled = false;
return;
}
else
{
MessageBox.Show("保存失败");
return;
}
}
