private void 销售明细维护_Load(object sender, EventArgs e) { //获取销售名单 cmbUserName.DisplayMember = "UserName"; cmbUserName.ValueMember = "id"; cmbUserName.DataSource = new T_UsersTableAdapter().GetData(); cmbUserName.SelectedIndex = -1; if (!Common.AuthenticateRight.AuthOperation(111301) && !CommonClass.SttUser.blSuperUser) { cmbUserName.SelectedValue = Classes.PubClass.UserId; cmbUserName.Enabled = false; } if (mId == -1) { } else { DataTable dt = new DataTable(); dt = new T_NoTicketTableAdapter().GetDataById(mId); if (dt.Rows.Count > 0) { var mRow = (销售管理.DAL.DataSetNoTicket.T_NoTicketRow)dt.Rows[0]; cmbUserName.SelectedValue = mRow.UserName; cmbCustomerName.SelectedValue = mRow.CustomerName; TxtProjectName.Text = mRow.ProjectName.ToString(); 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(dtpDate1.Text.Trim()) == true) { toolTip1.Show("请输入申请日期!", dtpDate1, 0, dtpDate1.Height, 2000); return; } if (string.IsNullOrEmpty(TxtProjectName.Text.Trim()) == true) { toolTip1.Show("请输入项目名称!", TxtProjectName, 0, TxtProjectName.Height, 2000); return; } if (string.IsNullOrEmpty(TxtSumMoney.Text.Trim()) == true) { toolTip1.Show("请输入申请金额说明!", TxtSumMoney, 0, TxtSumMoney.Height, 2000); return; } if (Classes.PubClass.IsDecimalSign(TxtSumMoney.Text.Trim()) == false) { toolTip1.Show("请输入正确的申请金额!", TxtSumMoney, 0, TxtSumMoney.Height, 2000); return; } int ret = 0; if (mId == -1) { ret = new T_NoTicketTableAdapter().Insert((long)cmbUserName.SelectedValue, (long)cmbCustomerName.SelectedValue, TxtProjectName.Text, Convert.ToDecimal(TxtSumMoney.Text), dtpDate1.Value.Date, "未审批", null, null, "正常"); } else { ret = new T_NoTicketTableAdapter().UpdateById((long)cmbUserName.SelectedValue, (long)cmbCustomerName.SelectedValue, TxtProjectName.Text, Convert.ToDecimal(TxtSumMoney.Text), dtpDate1.Value.Date, mId); } if (ret > 0) { MessageBox.Show("保存成功"); btnSave.Enabled = false; return; } else { MessageBox.Show("保存失败"); return; } }