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