//验证并消费 private void BTVerify_Click(object sender, EventArgs e) { string code = TextCode.Text.Trim(); if (code == "") { BathClass.printErrorMsg("需要输入优惠券代码!"); return; } string errorDesc = ""; var consumeWxCouponResult = WxCouponManagement.consumeCoupon(LogIn.connectionIP, LogIn.options.company_Code, code, out errorDesc); if (consumeWxCouponResult == null) { BathClass.printErrorMsg(errorDesc); TextCode.SelectAll(); TextCode.Focus(); return; } if (!consumeWxCouponResult.success) { BathClass.printErrorMsg(consumeWxCouponResult.errorDesc); TextCode.SelectAll(); TextCode.Focus(); return; } couponValue = consumeWxCouponResult.value; this.DialogResult = DialogResult.OK; this.Close(); }
//添加 private void BTAdd_Click(object sender, EventArgs e) { var code = TextCode.Text.Trim(); if (code == "") { MessageBox.Show("需要输入内容!"); return; } if (!StringUtil.isEmpty(companies.FirstOrDefault(x => x.Split(Constants.SplitChar)[0] == code))) { MessageBox.Show("已经包含该店铺,不能重复添加!"); return; } //需要连接服务器检验code是否存在! string errorDesc = ""; var customer = ShopManagement.queryCustomer(MainForm.ip, code, out errorDesc); if (customer == null) { if (!StringUtil.isEmpty(errorDesc)) { MessageBox.Show(errorDesc); } else { MessageBox.Show("该店铺代码不存在,请确认!"); TextCode.SelectAll(); TextCode.Focus(); } return; } //companyCodes.Add(code); companies.Add(joinCustomer(customer)); IOUtil.set_config_by_key(ConfigKeys.KEY_COMPANY_CODE, string.Join(Constants.BIG_SPLITCHAR.ToString(), companies.ToArray())); dgv_show(); TextCode.Text = ""; TextCode.Focus(); }
private void BtnSave_Click(object sender, EventArgs e) { #pragma warning disable CS0618 // 'DXValidationProvider.InvalidControls' is obsolete: 'Use the GetInvalidControls method instead' if (MyValidationProvider.InvalidControls.Count > 0) #pragma warning restore CS0618 // 'DXValidationProvider.InvalidControls' is obsolete: 'Use the GetInvalidControls method instead' { XtraMessageBox.Show("There is Some Error.", "Validation Failed"); TextCode.Focus(); return; } if (TextCode.Text == string.Empty) { XtraMessageBox.Show("Code can not be blank.", "Validation Failed"); TextCode.Focus(); return; } else { if (TextWorked.Text == string.Empty) { XtraMessageBox.Show("Worked Days can not be Blank.", "Validation Failed"); TextWorked.Focus(); return; } else { if (Convert.ToDecimal(TextPaidHolidays.EditValue) > 7) { XtraMessageBox.Show("Paid holidays cannot be greater than 7", "Validation Failed"); TextPaidHolidays.Focus(); return; } else { if ((Convert.ToDecimal(TextWorked.EditValue) + Convert.ToDecimal(TextPaidHolidays.EditValue) + Convert.ToDecimal(TextEarned.EditValue) + Convert.ToDecimal(TextCasual.EditValue) + Convert.ToDecimal(TextSick.EditValue)) > DaysInMonth) { XtraMessageBox.Show("Total Days can not be Exceed.", "Validation Failed"); TextWorked.Focus(); return; } else { using (var Connection = new SqlConnection(ProjectFunctions.ConnectionString)) { var cmd = Connection.CreateCommand(); cmd.Connection = Connection; var sql = string.Empty; if (IsUpdate) { sql = "UPDATE [AtnData] SET [MonthYear] = @MonthYear,[EmpCode] = @EmpCode,[EmpDW] = @EmpDW,[EmpPH] = @EmpPH,[EmpEL] = @EmpEL,[EmpCL] = @EmpCL,[EmpSL] = @EmpSL,[EmpOT] = @EmpOT,[EmpAdvAmt] = @EmpAdvAmt,[EmpLoanAmt] = @EmpLoanAmt,[EmpTdsAmt] = @EmpTdsAmt,[EmpMiscDed1] = @EmpMiscDed1,[EmpMiscAlw1] = @EmpMiscAlw1,[EmpMiscAlw2] = @EmpMiscAlw2,[EmpMiscAlw3] = @EmpMiscAlw3,[EmpPrePaidSal] = @EmpPrePaidSal,EmpML=@EmpML ,EmpMiscDed2=@EmpMiscDed2,EmpPymtMode=@EmpPymtMode" + " WHERE [EmpCode] = @EmpCode and [MonthYear] = @MonthYear"; } else { sql = " INSERT INTO [AtnData]([MonthYear],[EmpCode],[EmpDW],[EmpPH],[EmpEL],[EmpCL],[EmpSL],[EmpOT],[EmpAdvAmt],[EmpLoanAmt],[EmpTdsAmt],[EmpMiscDed1],[EmpMiscAlw1],[EmpMiscAlw2],[EmpMiscAlw3],[EmpLockTag],[EmpPrePaidSal],EmpML,EmpMiscDed2,EmpPymtMode)" + "VALUES" + "(@MonthYear,@EmpCode,@EmpDW,@EmpPH,@EmpEL,@EmpCL ,@EmpSL ,@EmpOT ,@EmpAdvAmt ,@EmpLoanAmt ,@EmpTdsAmt ,@EmpMiscDed1 ,@EmpMiscAlw1 ,@EmpMiscAlw2 ,@EmpMiscAlw3 ,@EmpLockTag,@EmpPrePaidSal,@EmpML,@EmpMiscDed2,@EmpPymtMode)"; } Connection.Open(); cmd.CommandText = sql; var month = TextMonth.Text.Substring(0, 2) + TextMonth.Text.ToString().Substring(TextMonth.Text.ToString().Length - 2, 2); cmd.Parameters.AddWithValue("@MonthYear", TextMonth.Text).Value = month; cmd.Parameters.AddWithValue("@EmpCode", TextCode.Text); cmd.Parameters.AddWithValue("@EmpDW", SqlDbType.Decimal).Value = Convert.ToDecimal(TextWorked.Text); if (TextPaidHolidays.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpPH", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpPH", SqlDbType.Decimal).Value = Convert.ToDecimal(TextPaidHolidays.Text); } if (TextEarned.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpEL", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpEL", SqlDbType.Decimal).Value = Convert.ToDecimal(TextEarned.Text); } if (TextCasual.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpCL", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpCL", SqlDbType.Decimal).Value = Convert.ToDecimal(TextCasual.Text); } if (TextSick.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpSL", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpSL", SqlDbType.Decimal).Value = Convert.ToDecimal(TextSick.Text); } if (TextOverTime.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpOT", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpOT", SqlDbType.Decimal).Value = Convert.ToDecimal(TextOverTime.Text); } if (TextAdvances.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpAdvAmt", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpAdvAmt", SqlDbType.Decimal).Value = Convert.ToDecimal(TextAdvances.Text); } if (TextLoanAmt.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpLoanAmt", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpLoanAmt", SqlDbType.Decimal).Value = Convert.ToDecimal(TextLoanAmt.Text); } if (TextTdsAmt.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpTdsAmt", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpTdsAmt", SqlDbType.Decimal).Value = Convert.ToDecimal(TextTdsAmt.Text); } if (TextDeducMisc.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpMiscDed1", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpMiscDed1", SqlDbType.Decimal).Value = Convert.ToDecimal(TextDeducMisc.Text); } if (TextMisc1.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpMiscAlw1", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpMiscAlw1", SqlDbType.Decimal).Value = Convert.ToDecimal(TextMisc1.Text); } if (TextMisc2.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpMiscAlw2", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpMiscAlw2", SqlDbType.Decimal).Value = Convert.ToDecimal(TextMisc2.Text); } if (TextMisc3.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpMiscAlw3", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpMiscAlw3", SqlDbType.Decimal).Value = Convert.ToDecimal(TextMisc3.Text); } if (txtMaternityLeave.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpML", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpML", SqlDbType.Decimal).Value = Convert.ToDecimal(txtMaternityLeave.Text); } cmd.Parameters.AddWithValue("@EmpLockTag", DBNull.Value); if (IsUpdate) { cmd.Parameters.AddWithValue("@EmpPrePaidSal", TextPrePaidTag.Text); } else { cmd.Parameters.AddWithValue("@EmpPrePaidSal", DBNull.Value); } if (txtMiscDedNew.Text == string.Empty) { cmd.Parameters.AddWithValue("@EmpMiscDed2", SqlDbType.Decimal).Value = "0"; } else { cmd.Parameters.AddWithValue("@EmpMiscDed2", SqlDbType.Decimal).Value = Convert.ToDecimal(txtMiscDedNew.Text); } cmd.Parameters.AddWithValue("@EmpPymtMode", SqlDbType.Decimal).Value = txtPaymentMode.Text; cmd.ExecuteNonQuery(); if (Convert.ToDecimal(TextWorked.Text) == 0) { ProjectFunctions.GetDataSet("Delete from payfinal where monthyear='" + month + "' And EmpCode='" + TextCode.Text.Trim() + "'"); ProjectFunctions.GetDataSet("Delete from Paytestf where monthyear='" + month + "' And EmpCode='" + TextCode.Text.Trim() + "'"); } using (var Conn = new SqlConnection(ProjectFunctions.ConnectionString)) { var month2 = TextMonth.Text.Substring(0, 2) + TextMonth.Text.ToString().Substring(TextMonth.Text.ToString().Length - 2, 2); var str1 = string.Empty; TextMonth.Focus(); } } //BaseFunctions.GetDataSet(" Update exmst set ExLoadTag='1',ExLoadedDate='" + DateTime.Now.ToString("yyyy-MM-dd") + "' where ExEmpCode='" + TextCode.Text + "' And DATEPART(MM,ExMst.ExDatePost)='" + Convert.ToDateTime(TextMonth.Text).ToString("MM") + "' And DATEPART(yyyy,ExMst.ExDatePost)='" + Convert.ToDateTime(TextMonth.Text).ToString("yyyy") + "' And ExLoadTag is null"); TextCode.Text = string.Empty; TextCodeDesc.Text = string.Empty; TextDepartment.EditValue = string.Empty; TextWorked.Text = "0"; TextPaidHolidays.Text = "0"; TextOverTime.Text = "0"; TextEarned.Text = "0"; TextCasual.Text = "0"; TextSick.EditValue = "0"; TextMisc1.EditValue = "0"; TextMisc2.Text = "0"; TextMisc3.Text = "0"; TextFlexiAlw.Text = "0"; TextAdvances.Text = "0"; TextLoanAmt.EditValue = "0"; TextDeducMisc.Text = "5"; TextTdsAmt.Text = "0"; txtMaternityLeave.Text = "0"; txtFood.Text = "0"; TextPrePaidTag.Text = string.Empty; txtTotalDays.Text = "0"; txtMiscDedNew.Text = "0"; TextMonth.Focus(); if (IsUpdate) { //XtraMessageBox.Show("Data Saved", "Success"); Close(); Dispose(); } } } } } }