//提交 private void btnOK_Click(object sender, EventArgs e) { double totalPrice = 0; foreach (DataRow row in AddApplicationDT.Rows) { decimal MoneyDiscont = 1; switch (row["MoneyUnit"].ToString()) { case "1": default: MoneyDiscont = 1; break; case "2": MoneyDiscont = EmailControl.config.USrate; break; case "3": MoneyDiscont = EmailControl.config.HKrate; break; case "4": MoneyDiscont = EmailControl.config.MOPrate; break; case "5": MoneyDiscont = EmailControl.config.SGDrate; break; case "6": MoneyDiscont = EmailControl.config.MYRrate; break; case "7": MoneyDiscont = EmailControl.config.GBPrate; break; case "8": MoneyDiscont = EmailControl.config.EURrate; break; case "9": MoneyDiscont = EmailControl.config.JPYrate; break; case "10": MoneyDiscont = EmailControl.config.TWDrate; break; } if (items.SelectItemByItemID(row["ItemID"].ToString()).Rows[0]["IsSpecial"].ToString() == "1") { } else { totalPrice += double.Parse(row["Price"].ToString()) * double.Parse(row["Count"].ToString()) * double.Parse(row["ApprovalDiscount"].ToString()) / 100.00 * Convert.ToDouble(MoneyDiscont); } } if (AddApplicationDT.Rows.Count == 0) { MessageBox.Show("申请表中未添加项目内容"); } else if (Login.LoginUser.RestAmount - totalPrice < 0) { MessageBox.Show("当前余额不足"); } else if (applicationInfo.SelectApplicationByTransNo(txtTransNo.Text).Rows.Count > 0) { MessageBox.Show("已存在该交易号"); } else { DataTable AddAppInfoDT = applicationInfo.SelectApplicationByTransNo("0"); DataRow dr = AddAppInfoDT.NewRow(); dr["TransNo"] = transNo; dr["Applicants"] = Login.LoginUser.UID; dr["ApplicantsName"] = txtApplicantsName.Text; dr["ApplicantsNo"] = txtApplicantsNo.Text; dr["Location"] = txtLocation.Text; dr["ApplicantsDate"] = DateTime.Now; dr["TotalPrice"] = txtTotalPrice.Value; dr["Deadline"] = txtDeadline.Value; dr["SalesDate"] = txtDeadline.Value.AddYears(3); dr["ApprovalDate"] = txtDeadline.Value.AddYears(3); dr["ApprovalDate2"] = txtDeadline.Value.AddYears(3); dr["PurchaseLocation"] = txtPurchaseLocation.Text; dr["IsDelete"] = 0; dr["AppState"] = 0; dr["ApprovalState"] = 0; dr["ApprovalState2"] = 0; dr["Approval2"] = Login.LoginUser.ManagerID; dr["StaffApproval"] = 0; dr["MoneyUnit"] = AddApplicationDT.Rows[0]["MoneyUnit"]; foreach (DataRow addDr in AddApplicationDT.Rows) { addDr["TransNo"] = dr["TransNo"]; } AddAppInfoDT.Rows.Add(dr); try { applicationInfo.SubmitApplicationInfo(AddAppInfoDT, totalPrice, Login.LoginUser.UID, 0); applicationDetail.SubmitApplicationDetail(AddApplicationDT, totalPrice, Login.LoginUser.UID, 1); Thread thread = new Thread(new ThreadStart(SendEmail)); thread.Start(); MessageBox.Show("提交成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information); DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { MessageBox.Show("提交失败,错误信息:" + ex.Message); } } }
//提交 private void btnOK_Click(object sender, EventArgs e) { double totalPrice = 0; foreach (DataRow row in AddApplicationDT.Rows) { if (items.SelectItemByItemID(row["ItemID"].ToString()).Rows[0]["IsSpecial"].ToString() == "1") { } else { totalPrice += double.Parse(row["Price"].ToString()) * double.Parse(row["Count"].ToString()); } } if (AddApplicationDT.Rows.Count == 0) { MessageBox.Show("Items are not added in the application form"); } else if (Login.LoginUser.RestAmount - totalPrice < 0) { MessageBox.Show("Your current balance is not enough"); } else { string transNo = "NG" + DateTime.Now.ToString("yyyyMMddHHmmssffff"); DataTable AddAppInfoDT = applicationInfo.SelectApplicationByTransNo("0"); DataRow dr = AddAppInfoDT.NewRow(); dr["TransNo"] = transNo; dr["Applicants"] = Login.LoginUser.UID; dr["ApplicantsName"] = txtApplicantsName.Text; dr["ApplicantsNo"] = txtApplicantsNo.Text; dr["Location"] = txtLocation.Text; dr["ApplicantsDate"] = DateTime.Now; dr["TotalPrice"] = txtTotalPrice.Value; dr["Deadline"] = txtDeadline.Value; dr["PurchaseLocation"] = txtPurchaseLocation.Text; dr["IsDelete"] = 0; dr["AppState"] = 0; dr["ApprovalState"] = 0; dr["ApprovalState2"] = 0; dr["Approval2"] = Login.LoginUser.ManagerID; dr["StaffApproval"] = 0; foreach (DataRow addDr in AddApplicationDT.Rows) { addDr["TransNo"] = dr["TransNo"]; } AddAppInfoDT.Rows.Add(dr); try { applicationInfo.SubmitApplicationInfo(AddAppInfoDT, totalPrice, Login.LoginUser.UID, 0); applicationDetail.SubmitApplicationDetail(AddApplicationDT, totalPrice, Login.LoginUser.UID, 1); Thread thread = new Thread(new ThreadStart(SendEmail)); thread.Start(); MessageBox.Show("Submit Successe", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { MessageBox.Show("Submit Fail,Message:" + ex.Message); } } }
private void BtnSubmitAddApp_Click(object sender, EventArgs e) { BaseData.Store store = new BaseData.Store(); //if (store.SelectStoreInfoByStoreName(txtDeliverStore4.Text).Rows.Count == 0 || store.SelectStoreInfoByStoreName(txtReceiptStore4.Text).Rows.Count == 0) //{ // MessageBox.Show("收发店铺名错误"); //} if (AddApplicationDT.Rows.Count == 0) { MessageBox.Show("申请表中未添加转货内容"); } else if (txtCtrlID.Text == null || txtCtrlID.Text.Length == 0) { MessageBox.Show("请填写控制单号"); } else if (cbDeliverStore.SelectedItem.ToString() == cbRecieveStore.SelectedItem.ToString()) { MessageBox.Show("收发店面相同,无法添加"); } else { int TotalCount = 0; double TotalPrice = 0; DataTable AddAppInfoDT = applicationInfo.SelectApplicationByCtrlID("0"); DataRow dr = AddAppInfoDT.NewRow(); dr["CtrlID"] = txtCtrlID.Text; dr["DeliverStore"] = cbDeliverStore.SelectedItem.ToString(); dr["ReceiptStore"] = cbRecieveStore.SelectedItem.ToString(); dr["ApplicantsDate"] = DateTime.Now; dr["ApplicantsName"] = txtApplicant.Text; dr["ApplicantsPos"] = txtApplicantPos.Text; dr["Applicants"] = Login.LoginUser.UID; dr["Alert_Approval"] = 0; dr["Alert_Deliver"] = 0; dr["Alert_Receipt"] = 0; dr["ExchangeType"] = cboExchangeType.SelectedItem.ToString(); foreach (DataRow addDr in AddApplicationDT.Rows) { addDr["CtrlID"] = dr["CtrlID"]; TotalCount += (int)addDr["App_Count"]; TotalPrice += ((int)addDr["App_Count"]) * ((double.Parse(addDr["Price"].ToString()))); } dr["TotalCount"] = TotalCount; dr["TotalPrice"] = TotalPrice; AddAppInfoDT.Rows.Add(dr); if (TotalPrice > EmailControl.config.UpperLimit) { DialogResult dres = MessageBox.Show("超出限额,是否继续提交?", "消息", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (dres == DialogResult.OK) { try { applicationInfo.SubmitApplicationInfo(AddAppInfoDT); applicationDetail.SubmitApplicationDetail(AddApplicationDT); Thread thread = new Thread(new ThreadStart(SendEmail)); thread.Start(); MessageBox.Show("提交成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch (Exception ex) { MessageBox.Show("提交失败,错误信息:" + ex.Message); } } } else { try { applicationInfo.SubmitApplicationInfo(AddAppInfoDT); applicationDetail.SubmitApplicationDetail(AddApplicationDT); Thread thread = new Thread(new ThreadStart(SendEmail)); thread.Start(); MessageBox.Show("提交成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch (Exception ex) { MessageBox.Show("提交失败,错误信息:" + ex.Message); } } } }
private void btnDataProcess_Click(object sender, EventArgs e) { AccessHelper ah = new AccessHelper(); foreach (DataRow dr in dtStaDetail.Rows) { string strCtrlID = ""; int intNum = int.Parse(dr["num"].ToString()); int intCI = 1; int intCurrentNum = 1; int intTotalCount = 0; double douTotalPrice = 0.00; string strSQL = "select * from applicationdetail where CtrlID='" + dr["CtrlID"].ToString() + "' "; DataTable dtDataDetail = ah.SelectToDataTable(strSQL); strSQL = "select * from ApplicationInfo where CtrlID='" + dr["CtrlID"].ToString() + "' "; DataTable dtDataInfo = ah.SelectToDataTable(strSQL); string strOriCtrlID = "Auto" + DateTime.Now.ToString("HHmmssfff") + dtDataInfo.Rows[0]["Applicants"].ToString().Substring(0, 1); strCtrlID = strOriCtrlID; DataTable AddAppInfoDT = applicationInfo.SelectApplicationByCtrlID("0"); DataTable AddAppDetailDT = applicationDetail.SelectAppDetailByCtrlID("0"); DataRow drInfo = AddAppInfoDT.NewRow(); DataRow drDetail = AddAppDetailDT.NewRow(); drInfo = dtDataInfo.Rows[0]; foreach (DataRow drIN in dtDataDetail.Rows) { drDetail = drIN; if (intCurrentNum <= 20) { intCurrentNum++; drInfo["CtrlID"] = strCtrlID; drDetail["CtrlID"] = strCtrlID; intTotalCount += (int)drDetail["App_Count"]; douTotalPrice += ((int)drDetail["App_Count"]) * ((double.Parse(drDetail["Price"].ToString()))); AddAppDetailDT.Rows.Add(drDetail.ItemArray); } else { drInfo["TotalCount"] = intTotalCount; drInfo["TotalPrice"] = douTotalPrice; AddAppInfoDT.Rows.Add(drInfo.ItemArray); applicationInfo.SubmitApplicationInfo(AddAppInfoDT); applicationDetail.SubmitApplicationDetail(AddAppDetailDT); intCurrentNum = 1; intTotalCount = 0; douTotalPrice = 0.00; strCtrlID = strOriCtrlID + intCI.ToString(); intCI++; AddAppInfoDT.Clear(); AddAppDetailDT.Clear(); //drInfo = AddAppInfoDT.NewRow(); //drDetail = AddAppDetailDT.NewRow(); //drInfo = dtDataInfo.Rows[0]; intCurrentNum++; drInfo["CtrlID"] = strCtrlID; drDetail["CtrlID"] = strCtrlID; intTotalCount += (int)drDetail["App_Count"]; douTotalPrice += ((int)drDetail["App_Count"]) * ((double.Parse(drDetail["Price"].ToString()))); AddAppDetailDT.Rows.Add(drDetail.ItemArray); } } if (AddAppDetailDT.Rows.Count > 0) { drInfo["TotalCount"] = intTotalCount; drInfo["TotalPrice"] = douTotalPrice; AddAppInfoDT.Rows.Add(drInfo.ItemArray); applicationInfo.SubmitApplicationInfo(AddAppInfoDT); applicationDetail.SubmitApplicationDetail(AddAppDetailDT); intCurrentNum = 1; intTotalCount = 0; douTotalPrice = 0.00; //strCtrlID = strOriCtrlID + intCI.ToString(); //intCI++; AddAppInfoDT.Clear(); AddAppDetailDT.Clear(); } strSQL = "update applicationdetail set isdelete=1 where CtrlID='" + dr["CtrlID"].ToString() + "' "; ah.ExecuteSQLNonquery(strSQL); strSQL = "update ApplicationInfo set isdelete=1 where CtrlID='" + dr["CtrlID"].ToString() + "' "; ah.ExecuteSQLNonquery(strSQL); } ah.Close(); MessageBox.Show("处理完成!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Warning); frmDataProcessing_Load(null, null); }