private void SetData(kkslm_ms_teamtelesales ts) { hdfID.Value = ts.slm_TeamTelesales_Id.ToString(); txtDCode.Text = ts.slm_TeamTelesales_Code; txtDName.Text = ts.slm_TeamTelesales_Name; //AppUtil.SetComboValue(cmbDHeader, ts.slm_HeadStaff); rdoStatus.SelectedIndex = rdoStatus.Items.IndexOf(rdoStatus.Items.FindByValue(ts.is_Deleted.ToString())); hdfStaffID.Value = ts.slm_HeadStaff; SlmScr038Biz biz = new SlmScr038Biz(); string empcode; var stf = biz.GetStaffNameFromID(SLMUtil.SafeDecimal(ts.slm_HeadStaff), out empcode); if (stf != null) { txtDHeader.Text = empcode; // stf.slm_EmpCode; lblStaffName.Text = stf; // (stf.slm_PositionName == null ? "" : stf.slm_PositionName + " - ") + stf.slm_StaffNameTH ?? ""; } else { txtDHeader.Text = ""; lblStaffName.Text = ""; } txtDCode.ReadOnly = true; updModal.Update(); }
private kkslm_ms_config_car_premium GetData() { kkslm_ms_config_car_premium cp = new kkslm_ms_config_car_premium(); cp.slm_cc_pm_id = SLMUtil.SafeDecimal(hdfID.Value); cp.slm_Brand_Code = cmbDBrand.SelectedValue; cp.is_Deleted = rdoDStatus.SelectedValue == "True"; return(cp); }
private bool ValidateData() { string err = ""; //if (txtDCode.Text.Trim() == "") err += (err == "" ? "" : ", ") + "Team Telesales Code"; //if (txtDName.Text.Trim() == "") err += (err == "" ? "" : ", ") + "ชื่อทีม Telesales"; //if (cmbDHeader.SelectedValue == "") err += (err == "" ? "" : ", ") + "หัวหน้าทีม"; if (cmbDRole.SelectedIndex == 0) { err += (err == "" ? "" : ", ") + "Role"; } if (rdoInsuranceType.SelectedIndex < 0) { err += (err == "" ? "" : ", ") + "ผลตอบแทนธนาคาร"; } if (txtDDiscountValue.Text.Trim() == "") { err += (err == "" ? "" : ", ") + "ส่วนลด"; } if (err != "") { AppUtil.ClientAlert(this, "กรุณากรอก " + err); return(false); } #region Add by First -- 20/11/2016 decimal temp; if (!decimal.TryParse(txtDDiscountValue.Text, out temp)) { AppUtil.ClientAlert(this, "กรุณากรอกตัวเลขเท่านั้น"); return(false); } // by PPP, 21/11/2016, หน้าจอป้องกันการคีย์ตัวอักษรแล้ว และ มีเช็คด้านล่างแล้ว //if (rdoDiscount.SelectedValue == "1" && SLMUtil.SafeInt(txtDDiscountValue.Text) == 0) //{ // AppUtil.ClientAlert(this, "กรุณากรอก ส่วนลด (%) เป็นตัวเลขจำนวนเต็มและไม่เกิน 100% เท่านั้น");//by PPP, 21/11/2016, เพิ่ม Wording // return false; //} #endregion if (rdoDiscount.SelectedValue == "2" && SLMUtil.SafeDecimal(txtDDiscountValue.Text) > (decimal)9999999999999999.99) { AppUtil.ClientAlert(this, "ส่วนลด (บาท) ต้องไม่เกิน 9,999,999,999,999,999.99"); return(false); } if (SLMUtil.SafeDecimal(txtDDiscountValue.Text) > 100 && rdoDiscount.SelectedValue == "1") { AppUtil.ClientAlert(this, "กรอกส่วนลดได้ไม่เกิน 100%"); return(false); } return(true); }
private void BuildAmphur() { //เขต/อำเภอ cmbAmphur.DataSource = SlmScr010Biz.GetAmphurDataNew(SLMUtil.SafeInt(cmbProvince.SelectedItem.Value)); cmbAmphur.DataTextField = "TextField"; cmbAmphur.DataValueField = "ValueField"; cmbAmphur.DataBind(); cmbAmphur.Items.Insert(0, new ListItem("", "")); }
private void BuildTambol() { //แขวง/ตำบล cmbTambol.DataSource = SlmScr010Biz.GetTambolDataNew(SLMUtil.SafeInt(cmbAmphur.SelectedItem.Value)); cmbTambol.DataTextField = "TextField"; cmbTambol.DataValueField = "ValueField"; cmbTambol.DataBind(); cmbTambol.Items.Insert(0, new ListItem("", "")); }
private kkslm_ms_mapping_brand_model_inscartype GetData() { kkslm_ms_mapping_brand_model_inscartype mm = new kkslm_ms_mapping_brand_model_inscartype(); mm.slm_BrandCode = cmbDBrand.SelectedValue; mm.slm_ModelCode = cmbDModel.SelectedValue; mm.slm_InsuranceCarTypeId = SLMUtil.SafeInt(cmbDType.SelectedValue); mm.is_Deleted = rdoDStatus.SelectedValue == "True"; return(mm); }
protected void imbAction_Click(object sender, ImageClickEventArgs e) { var id = SLMUtil.SafeInt(((ImageButton)sender).CommandArgument); SlmScr063Biz bz = new SlmScr063Biz(); var cp = bz.GetDetail(id); if (cp != null) { SetData(cp); zPopDetail.Show(); } }
protected void imbAction_Click(object sender, ImageClickEventArgs e) { var id = SLMUtil.SafeDecimal(((ImageButton)sender).CommandArgument); SlmScr038Biz bz = new SlmScr038Biz(); var ts = bz.GetTeamData(id); if (ts != null) { SetData(ts); zPopDetail.Show(); } }
private kkslm_ms_teamtelesales GetData() { kkslm_ms_teamtelesales ts = new kkslm_ms_teamtelesales(); ts.slm_TeamTelesales_Id = SLMUtil.SafeDecimal(hdfID.Value); ts.slm_TeamTelesales_Code = txtDCode.Text; ts.slm_TeamTelesales_Name = txtDName.Text; //ts.slm_HeadStaff = cmbDHeader.SelectedValue; ts.slm_HeadStaff = hdfStaffID.Value; ts.is_Deleted = rdoStatus.SelectedValue == "True"; return(ts); }
private kkslm_ms_discount GetData() { kkslm_ms_discount ds = new kkslm_ms_discount(); ds.slm_Discount_Id = SLMUtil.SafeInt(hdfID.Value); ds.slm_StaffTypeId = SLMUtil.SafeDecimal(cmbDRole.SelectedValue); ds.slm_DiscountBath = rdoDiscount.SelectedValue == "2" ? (decimal?)SLMUtil.SafeDecimal(txtDDiscountValue.Text) : null; ds.slm_DiscountPercent = rdoDiscount.SelectedValue == "1" ? (int?)SLMUtil.SafeInt(txtDDiscountValue.Text) : null; ds.slm_InsuranceTypeCode = rdoInsuranceType.SelectedValue; //ds.slm_ActDiscountBaht = null; //ds.slm_ActDiscountPercent = null; ds.is_Deleted = rdoDStatus.SelectedValue == "True"; return(ds); }
protected void btnPopupDoImportExcel_Click(object sender, EventArgs e) { try { string message = ""; ReceiveNoData data = new ReceiveNoData(); data.CodeName = textCodeName.Text; data.InsComId = SLMUtil.SafeDecimal(hiddenInsComId.Value); data.IsDeleted = false; data.ProductId = hiddenProductId.Value; data.ReceiveNoCancel = 0; data.ReceiveNoEnd = SLMUtil.SafeDecimal(textEndReceiveNoNumber.Text); data.ReceiveNoStart = SLMUtil.SafeDecimal(textStartReceiveNoNumber.Text); data.ReceiveNoRemain = data.ReceiveNoEnd - data.ReceiveNoStart; data.ReceiveNoTotal = data.ReceiveNoRemain; data.ReceiveNoUsed = 0; data.UpdatedBy = HttpContext.Current.User.Identity.Name; data.UpdatedDate = DateTime.Now; data.IsDeleted = false; if (ObtScr002Biz.SaveReceiveData(data, out message)) { // rebind gridview var result = ObtScr002Biz.GetSearchData(data.ProductId, data.InsComId, true); BindGridview(pcReceiveNo, gvReceiveNoList, result.ToArray(), 0); // hide add panel & clear data ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "hidePanel", "CancelAdd();", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "hidePanel", "AddReceiveNo();", true); } lblError.Text = message; mpePopupEdit.Show(); mpePopupError.Show(); upError.Update(); //upnPopupEdit.Update(); } catch (Exception ex) { string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message; _log.Error(message); AppUtil.ClientAlert(Page, message); } }
private void LoadDataList(int pageIdx) { try { SlmScr062Biz biz = new SlmScr062Biz(); var lst = biz.GetDataList(SLMUtil.SafeInt(cmbSRole.SelectedValue), chkSPolicy.Checked, chkSAct.Checked, cmbSStatus.SelectedValue);// biz.GetDataList(txtTeamCode.Text, txtTeamName.Text, cmbTeamHeader.SelectedValue, cmbStatus.SelectedValue); BindGridview(pcTop, lst, pageIdx); pcTop.Visible = gvResult.PageCount > 0; gvResult.Visible = true; upResult.Update(); } catch (Exception ex) { string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message; _log.Error(message); AppUtil.ClientAlert(Page, message); } }
protected void lbReloadPreleadInfo_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(Request["ticketid"])) { var lead = SlmScr004Biz.SearchSCR004Data(Request["ticketid"]); GetLeadData(lead); } else if (!string.IsNullOrEmpty(Request["preleadid"])) { GetPreleadData(SLMUtil.SafeDecimal(Request["preleadid"])); } } catch (Exception ex) { string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message; _log.Error(message); AppUtil.ClientAlert(Page, message); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { ((Label)Page.Master.FindControl("lblTopic")).Text = "แก้ไขข้อมูล Prelead"; //ScreenPrivilegeData priData = RoleBiz.GetScreenPrivilege(HttpContext.Current.User.Identity.Name, "SLM_SCR_046"); //if (priData == null || priData.IsView != 1) // AppUtil.ClientAlertAndRedirect(Page, "คุณไม่มีสิทธิ์เข้าใช้หน้าจอนี้", "SLM_SCR_046.aspx"); var prid = SLMUtil.SafeDecimal(Request["preleadid"]); LoadData(prid); } } catch (Exception ex) { string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message; _log.Error(message); AppUtil.ClientAlert(Page, message); } }
private void SetDataList(int page) { try { var mn = SLMUtil.SafeInt(cmbMonth.SelectedValue); gvResult.Columns[5].HeaderText = SlmScr053Biz.GetMonthName(mn - 5); gvResult.Columns[6].HeaderText = SlmScr053Biz.GetMonthName(mn - 4); gvResult.Columns[7].HeaderText = SlmScr053Biz.GetMonthName(mn - 3); gvResult.Columns[8].HeaderText = SlmScr053Biz.GetMonthName(mn - 2); gvResult.Columns[9].HeaderText = SlmScr053Biz.GetMonthName(mn - 1); gvResult.Columns[10].HeaderText = SlmScr053Biz.GetMonthName(mn); gvResult.Columns[11].HeaderText = SlmScr053Biz.GetMonthName(mn + 1); gvResult.Columns[12].HeaderText = SlmScr053Biz.GetMonthName(mn + 2); SlmScr053Biz bz = new SlmScr053Biz(); var lst = SlmScr053Biz.GetSearchResult(SLMUtil.SafeInt(cmbYear.SelectedValue), SLMUtil.SafeInt(cmbMonth.SelectedValue), SLMUtil.SafeInt(cmbTelesalesTeam.SelectedValue), cmbTelesales.SelectedValue); BindGridview(pcTop, gvResult, lst.ToArray(), page); } catch (Exception ex) { AppUtil.ClientAlert(this, ex.InnerException == null ? ex.Message : ex.InnerException.Message); } upResult.Update(); }
public LeadInfoBiz.LeadDetailInsData GetInsData() { var ins = new LeadInfoBiz.LeadDetailInsData(); ins.slm_RenewInsureId = SLMUtil.SafeDecimal(hdfID.Value); ins.slm_ContractNo = txtContractNo.Text.Trim(); if (cmbCardType.SelectedIndex > 0) { ins.CardType = cmbCardType.SelectedValue; } if (cmbCountry.SelectedIndex > 0) { ins.CountryId = Convert.ToInt32(cmbCountry.SelectedValue); } ins.IsCustomer = chkOldCustomer.Checked; ins.CitizenId = txtCitizenId.Text.Trim(); if (tdBirthdate.DateValue.Year != 1) { ins.Birthdate = tdBirthdate.DateValue; } ins.MaritalStatus = rdoMarital.SelectedValue; if (cmbOccupation.SelectedIndex > 0) { ins.Occupation = cmbOccupation.SelectedValue; } ins.slm_CC = txtCarCC.Text.Trim(); if (cmbBrand.SelectedIndex > 0) { ins.slm_RedbookBrandCode = cmbBrand.SelectedValue; } if (cmbModel.SelectedIndex > 0) { ins.slm_RedbookModelCode = cmbModel.SelectedValue; } if (cmbYearGroup.SelectedIndex > 0) { ins.slm_RedbookYearGroup = SLMUtil.SafeInt(cmbYearGroup.SelectedValue); } if (cmbSubModel.SelectedIndex > 0) { ins.slm_RedbookKKKey = cmbSubModel.SelectedValue; } //ins.slm_CoverageTypeId = SLMUtil.SafeInt(cmbCarType.SelectedValue); if (cmbCarType.SelectedIndex > 0) { ins.slm_InsurancecarTypeId = SLMUtil.SafeInt(cmbCarType.SelectedValue); } ins.slm_LicenseNo = txtCarLicense.Text.Trim(); if (cmbProvinceRegis.SelectedItem.Value != "") { ins.ProvinceRegis = cmbProvinceRegis.SelectedItem.Value; } ins.slm_ChassisNo = txtCarChassie.Text.Trim(); ins.slm_EngineNo = txtCarEngine.Text.Trim(); ins.slm_SendDocFlag = chkSendToBranch.Checked ? "3" : "1"; if (chkSendToBranch.Checked) { ins.slm_SendDocBrandCode = cmbDocBranch.SelectedValue; } // default? ins.slm_PolicyDiscountAmt = SLMUtil.SafeInt(hdfPolicyDiscountAmt.Value); ins.slm_PolicyGrossVat = SLMUtil.SafeInt(hdfPolicyGrossVat.Value); ins.slm_PolicyGrossStamp = SLMUtil.SafeInt(hdfPolicyGrossStamp.Value); ins.slm_PolicyGrossPremium = SLMUtil.SafeInt(hdfPolicyGrossPremium.Value); ins.slm_PolicyGrossPremiumTotal = SLMUtil.SafeInt(hdfPolicyGrossPremiumTotal.Value); ins.slm_ActGrossPremium = SLMUtil.SafeInt(hdfActGrossPremium.Value); ins.slm_ActNetPremium = SLMUtil.SafeInt(hdfActNetPremium.Value); ins.slm_ActVat = SLMUtil.SafeInt(hdfActVat.Value); ins.slm_ActStamp = SLMUtil.SafeInt(hdfActStamp.Value); return(ins); }
protected void radioActive_CheckedChanged(object sender, EventArgs e) { try { string alertMessage = ""; bool inuse = ObtScr002Biz.HasLotInUse(hiddenProductId.Value, SLMUtil.SafeDecimal(hiddenInsComId.Value)); if (inuse) { alertMessage = "มี Lot ที่ใช้งานอยู่แล้ว ไม่สามารถเปลี่ยนสถานะได้"; trConfirmOK.Visible = true; trComfirmYesNo.Visible = false; } else { alertMessage = "ต้องการเปลี่ยนสถานะใช่หรือไม่?"; trConfirmOK.Visible = false; trComfirmYesNo.Visible = true; } GridViewRow row = ((RadioButton)sender).Parent.Parent as GridViewRow; txtEditRowIndex.Text = row.RowIndex.ToString(); lblAlertMessage.Text = alertMessage; upConfirm.Update(); mpePopupConfirm.Show(); mpePopupEdit.Show(); } catch (Exception ex) { string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message; _log.Error(message); AppUtil.ClientAlert(Page, message); } }
private void SetStaffCombo() { AppUtil.BuildCombo(cmbTelesaleName, SlmScr032Biz.GetSearchStaffList(cmbTelesale.SelectedValue == "" ? -1 : SLMUtil.SafeInt(cmbTelesale.SelectedValue)), "ทั้งหมด"); }
private void SetTTACombo() { BuildCombo(cmbTTAName, SlmScr032Biz.GetSearchStaffList(SLMUtil.SafeInt(cmbTeamCode.SelectedValue)), "ทั้งหมด"); }
// load and save data override public override bool SaveData(string leadID, string UserID) { bool ret = true; try { // prepare data var ins = ctlLeadIns.GetInsData(); var addrLst = ctlLeadIns.GetInsAddrData(); ins.slm_ActNo = txtActNo.Text.Trim(); ins.slm_ActStartCoverDate = tdActStart.DateValue; ins.slm_ActEndCoverDate = tdActEnd.DateValue; ins.slm_ActIssuePlace = SLMUtil.SafeInt(cmbActIssue.SelectedValue); ins.slm_ActIssueBranch = cmbActIssueBranch.SelectedValue; LeadData ldata = new LeadData(); ldata.TicketId = CommonData.TicketID; ldata.TitleId = CommonData.TitleID; ldata.Name = CommonData.FName; ldata.LastName = CommonData.LName; ldata.ChannelId = CommonData.ChannelID; ldata.CampaignId = CommonData.CampaignID; ldata.TelNo_1 = CommonData.Phone1; ldata.TelNo_2 = CommonData.Phone2; ldata.Owner_Branch = CommonData.Branch; ldata.Owner = CommonData.Owner; ldata.IsCustomer = ins.IsCustomer ? "Y" : "N"; ldata.CardType = SLMUtil.SafeInt(ins.CardType); ldata.CitizenId = ins.CitizenId; ldata.CountryId = ins.CountryId; ldata.slm_SubStatus = "15"; ldata.Detail = txtDetails.Text.Trim(); if (ins.Birthdate.Year > 1) { ldata.Birthdate = ins.Birthdate; } ldata.Occupation = SLMUtil.SafeInt(ins.Occupation); ldata.TicketIdRefer = CommonData.TicketIDRefer; ldata.ProvinceRegis = string.IsNullOrEmpty(ins.ProvinceRegis) ? null : (int?)int.Parse(ins.ProvinceRegis); //owner, delegate ldata.HasNewOwner = CommonData.ActOwner; ldata.HasNewDelegate = CommonData.ActDelegate; //owner if (CommonData.Owner != "") //owner lead { ldata.Owner = CommonData.Owner; ldata.NewOwner = CommonData.Owner; ldata.NewOwner2 = CommonData.Owner; StaffData StaffData = SlmScr010Biz.GetStaffData(CommonData.Owner); if (StaffData != null) { ldata.StaffId = Convert.ToInt32(StaffData.StaffId); //LData.Owner_Branch = StaffData.BranchCode; } } ldata.slmOldOwner = CommonData.OldOwner; ldata.OldOwner = CommonData.OldOwner; ldata.OldOwner2 = CommonData.OldOwner; ldata.Type2 = CommonData.Type2; ldata.Delegate_Branch = CommonData.DelegateBranch; ldata.Delegate = CommonData.DelegateLead; //delegate if (!string.IsNullOrEmpty(CommonData.DelegateFlag)) { ldata.Delegate_Flag = Convert.ToDecimal(CommonData.DelegateFlag); //Add if (ldata.Delegate_Flag == 1) { ldata.Delegate_Branch = CommonData.DelegateBranch; ldata.Delegate = CommonData.DelegateLead; ldata.NewDelegate = CommonData.DelegateLead; ldata.OldDelegate = CommonData.OldDelegateLead; ldata.Type = CommonData.Type; } } else { ldata.Delegate_Flag = 0; } if (string.IsNullOrEmpty(ldata.Delegate)) { ldata.Delegate_Flag = 0; } if (ldata.CardType == 0) { ldata.CardType = null; } if (ldata.Occupation == 0) { ldata.Occupation = null; } // get create by branch StaffData createbyData = SlmScr010Biz.GetStaffData(HttpContext.Current.User.Identity.Name); if (createbyData != null) { ldata.CreatedBy_Branch = createbyData.BranchCode; } // saving string ticketid; LeadInfoBiz bz = new LeadInfoBiz(); if (!bz.SaveInsData(ldata, ins, addrLst, UserID, out ticketid, 2)) { throw new Exception(bz.ErrorMessage); } // post action CommonData.R_TicketID = ticketid; if (ldata.HasAdamsUrl) { CommonData.R_Message = "ต้องการแนบเอกสารต่อใช่หรือไม่?"; CommonData.R_HasAdams = true; } else { CommonData.R_Message = "ต้องการไปหน้าแสดงรายละเอียดผู้มุ่งหวังใช่หรือไม่?"; CommonData.R_HasAdams = false; } } catch (Exception ex) { string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message; _log.Debug(message); ret = false; CommonData.R_Message = message; } return(ret); }
protected void btnExcel2_Click(object sender, EventArgs e) { SlmScr049Biz bz = new SlmScr049Biz(); var filename = Path.GetTempPath() + "\\tmpexcel_049_" + Page.User.Identity.Name + ".xls";// Path.GetTempFileName(); if (bz.CreateExcel2(filename, tdmIncFrom.DateValue, tdmIncTo.DateValue, tdmCallFrom.DateValue, tdmCallTo.DateValue, SLMUtil.SafeInt(cmbTelesale.SelectedValue), cmbTelesaleName.SelectedValue)) { ExportExcel(filename, "SLM049_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xls"); } else { AppUtil.ClientAlert(this, bz.ErrorMessage); } }
private void SetTelesaleName() { AppUtil.BuildCombo(cmbTelesales, SlmScr051Biz.GetTelesaleList(SLMUtil.SafeInt(cmbTelesalesTeam.SelectedValue)), "ทั้งหมด"); }
// upload popup protected void btnUpload_Click(object sender, EventArgs e) { tbResult.Visible = false; pnlResult.Visible = false; pnlError.Visible = false; if (!ValidateData("")) { popImport.Show(); return; } string[] monabb = { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }; string moncheck = monabb[cmbMonth.SelectedIndex - 1]; if (fuData.HasFile) { try { var ext = Path.GetExtension(fuData.FileName).ToLower(); if (ext != ".xls") { throw new Exception("กรุณาระบุไฟล์ให้ถูกต้อง (.xls)"); } using (OleDbConnection conn = new OleDbConnection()) { DataTable dt = new DataTable(); string filename = Path.GetTempFileName(); fuData.SaveAs(filename); lblFilename.Text = fuData.FileName; fuData.ClearAllFilesFromPersistedStore(); // อ่านข้อมูล excel conn.ConnectionString = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES;IMEX=0;'", filename); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * FROM [Sheet1$]"; OleDbDataAdapter adp = new OleDbDataAdapter(cmd); adp.Fill(dt); // ตรวจสอบ column เดือน if (dt.Columns[3].ColumnName.ToLower() != moncheck) { throw new Exception("ไม่พบข้อมูลสำหรับเดือนที่ระบุ"); } // สร้าง data objects (ตัด row ที่มีค่าว่างทิ้ง) List <SlmScr041Biz.ExcelData> lst = new List <SlmScr041Biz.ExcelData>(); for (int i = 0; i < dt.Rows.Count; i++) { var row = dt.Rows[i]; if (row[0].ToString() == "" && row[1].ToString() == "") { continue; } lst.Add(new SlmScr041Biz.ExcelData() { TeamCode = row[0].ToString(), EmpCode = row[1].ToString(), TAAName = row[2].ToString(), Performance = SLMUtil.SafeDecimal(row[3].ToString()), Level = row[4].ToString() }); } if (lst.Count == 0) { throw new Exception("ไม่พบข้อมูลสำหรับนำเข้า"); } int succ, fail; List <ControlListData> rs; tbResult.Visible = false; // นำเข้าข้อมูล SlmScr041Biz bz = new SlmScr041Biz(); if (!bz.ImportTelesaleData(lst, cmbYear.SelectedValue, cmbMonth.SelectedValue, Page.User.Identity.Name, out succ, out fail, out rs)) { throw new Exception(bz.ErrorMessage); } else { if (rs.Count == 0) { pnlError.Visible = false; AppUtil.ClientAlert(this, "นำเข้าข้อมูลเรียบร้อย"); } else { pnlError.Visible = true; gvUploadResult.DataSource = rs; gvUploadResult.DataBind(); AppUtil.ClientAlert(this, "ข้อมูลไม่ถูกนำเข้า กรุณาตรวจสอบข้อผิดพลาด"); } tbResult.Visible = true; lblTotal.Text = (succ + fail).ToString("#,##0"); lblSucc.Text = succ.ToString("#,##0"); lblFail.Text = fail.ToString("#,##0"); //lblResult.Text = String.Format("<b>ผลการนำเข้าข้อมูล :</b> ทั้งหมด {0} รายการ, สำเร็จ {1} รายการ, ผิดพลาด {2} รายการ ", succ + fail, succ, fail); } } } catch (Exception ex) { fuData.ClearAllFilesFromPersistedStore(); if (ex.Message.Contains("Sheet1")) { lblUploadError.Text = "ไม่สามารถ Import ข้อมูลได้เนื่องจากไม่พบ Sheet : 'Sheet1'"; } else if (ex.Message.Contains("External table is not in the expected format.")) { lblUploadError.Text = "ไม่สามารถ Import ข้อมูลได้เนื่องจากรูปแบบไฟล์ไม่ถูกต้อง"; } else { lblUploadError.Text = ex.Message; } _log.Error(ex.InnerException != null ? ex.InnerException.Message : ex.Message); } } else { lblUploadError.Text = "กรุณาระบุไฟล์ที่ต้องการนำเข้า"; } popImport.Show(); }
public List <LeadInfoBiz.LeadDetailAddress> GetInsAddrData() { List <LeadInfoBiz.LeadDetailAddress> adrLst = new List <LeadInfoBiz.LeadDetailAddress>(); if (txtAddressNo.Text.Trim() != "" || cmbProvince.SelectedIndex >= 0) { adrLst.Add(new LeadInfoBiz.LeadDetailAddress() { slm_RenewInsureAddressId = SLMUtil.SafeDecimal(hdfAddrID.Value), slm_AddressType = "C", slm_AddressNo = txtAddressNo.Text.Trim(), slm_Moo = txtMoo.Text.Trim(), slm_BuildingName = txtBuildingName.Text.Trim(), slm_Street = txtStreet.Text.Trim(), slm_Floor = txtFloor.Text.Trim(), slm_Soi = txtSoi.Text.Trim(), slm_Province = SLMUtil.SafeInt(cmbProvince.SelectedValue), slm_Amphur = SLMUtil.SafeInt(cmbAmphur.SelectedValue), slm_Tambon = SLMUtil.SafeInt(cmbTambol.SelectedValue), slm_PostalCode = txtPostalCode.Text.Trim() }); } if (txtOAddressNo.Text.Trim() != "" || cmbOProvince.SelectedIndex >= 0) { adrLst.Add(new LeadInfoBiz.LeadDetailAddress() { slm_RenewInsureAddressId = SLMUtil.SafeDecimal(hdfOAddrID.Value), slm_AddressType = "O", slm_AddressNo = txtOAddressNo.Text.Trim(), slm_Moo = txtOMoo.Text.Trim(), slm_BuildingName = txtOBuildingname.Text.Trim(), slm_Street = txtOStreet.Text.Trim(), slm_Floor = txtOFloor.Text.Trim(), slm_Soi = txtOSoi.Text.Trim(), slm_Province = SLMUtil.SafeInt(cmbOProvince.SelectedValue), slm_Amphur = SLMUtil.SafeInt(cmbOAmphur.SelectedValue), slm_Tambon = SLMUtil.SafeInt(cmbOTambol.SelectedValue), slm_PostalCode = txtOPostCode.Text.Trim() }); } if (txtDAddressno.Text.Trim() != "" || cmbDProvince.SelectedIndex >= 0) { adrLst.Add(new LeadInfoBiz.LeadDetailAddress() { slm_RenewInsureAddressId = SLMUtil.SafeDecimal(hdfDAddrID.Value), slm_AddressType = "D", slm_AddressNo = txtDAddressno.Text.Trim(), slm_Moo = txtDMoo.Text.Trim(), slm_BuildingName = txtDBuilding.Text.Trim(), slm_Street = txtDStreet.Text.Trim(), slm_Floor = txtDFloor.Text.Trim(), slm_Soi = txtDSoi.Text.Trim(), slm_Province = SLMUtil.SafeInt(cmbDProvince.SelectedValue), slm_Amphur = SLMUtil.SafeInt(cmbDAmphur.SelectedValue), slm_Tambon = SLMUtil.SafeInt(cmbDTambol.SelectedValue), slm_PostalCode = txtDPostCode.Text.Trim(), }); } return(adrLst); }
protected void gvResult_DataBound(object sender, EventArgs e) { if (gvResult.HeaderRow != null) { gvResult.HeaderRow.Visible = false; } var mn = SLMUtil.SafeInt(cmbMonth.SelectedValue); if (gvResult.Rows.Count == 0) { return; } GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal); TableHeaderCell cell = new TableHeaderCell(); cell.Text = "Team Code"; cell.RowSpan = 3; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.RowSpan = 3; cell.Text = "Telesales"; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.ColumnSpan = 13; cell.Text = string.Format("Lead คุ้มครองเดือน {0}-{1}", SlmScr053Biz.GetMonthName(mn - 5), SlmScr053Biz.GetMonthName(mn + 2)); row.Controls.Add(cell); gvResult.Controls[0].Controls.AddAt(0, row); row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal); cell = new TableHeaderCell(); cell.Text = "Port ตั้งต้น"; cell.RowSpan = 2; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.RowSpan = 2; cell.Text = "Port คงค้าง"; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.RowSpan = 2; cell.Text = "Port ที่ไม่ต่อประกัน"; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.ColumnSpan = 8; cell.Text = "เดือนที่ชำระประกัน"; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.RowSpan = 2; cell.Text = "Grand Total"; row.Controls.Add(cell); cell = new TableHeaderCell(); cell.RowSpan = 2; cell.Text = "%Success"; row.Controls.Add(cell); gvResult.Controls[0].Controls.AddAt(1, row); int month; int.TryParse(cmbMonth.SelectedValue, out month); row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal); for (int mnz = month - 5; mnz <= month + 2; mnz++) { cell = new TableHeaderCell(); cell.Text = SlmScr053Biz.GetMonthName(mnz); row.Controls.Add(cell); } gvResult.Controls[0].Controls.AddAt(2, row); }
private void SetSubModelCombo() { BuildCombo(cmbSubModel, SlmScr010Biz.GetSubModelDataNew(cmbBrand.SelectedValue, cmbModel.SelectedValue, SLMUtil.SafeInt(cmbYearGroup.SelectedValue)), "กรุณาระบุ"); }
private void SetOTambol() { BuildCombo(cmbOTambol, SlmScr010Biz.GetTambolDataNew(SLMUtil.SafeInt(cmbOAmphur.SelectedValue))); }
private void SetDAmphur() { BuildCombo(cmbDAmphur, SlmScr010Biz.GetAmphurDataNew(SLMUtil.SafeInt(cmbDProvince.SelectedValue))); }
private void LoadDataList(int pageIdx) { try { SlmScr039Biz biz = new SlmScr039Biz(); var lst = biz.GetDataList(cmbSBrand.SelectedValue, cmbSModel.SelectedValue, SLMUtil.SafeInt(cmbSType.SelectedValue), cmbSStatus.SelectedValue); BindGridview(pcTop, lst, pageIdx); gvResult.Visible = true; pcTop.Visible = gvResult.PageCount > 0; upResult.Update(); } catch (Exception ex) { string message = ex.InnerException != null ? ex.InnerException.Message : ex.Message; _log.Error(message); AppUtil.ClientAlert(Page, message); } }
protected void btnExcel1_Click(object sender, EventArgs e) { if (tdmIncFrom.DateValue.Year == 1 || tdmIncTo.DateValue.Year == 1) { AppUtil.ClientAlert(this, "กรุณาเลือกเลือกช่วงวันที่กดเบิก Incentive ที่ต้องการค้นหา"); return; } if (tdmIncFrom.DateValue.Year != 1 && tdmIncTo.DateValue.Year != 1) { TimeSpan datediff = tdmIncTo.DateValue.Subtract(tdmIncFrom.DateValue); double totalday = datediff.TotalDays; if (totalday >= 60) { AppUtil.ClientAlert(this, "ไม่สามารถค้นหาช่วงวันที่กดรับ Incentive มากกว่าหรือเท่ากับ 60 วันได้"); return; } } SlmScr049Biz bz = new SlmScr049Biz(); var filename = Path.GetTempPath() + "\\tmpexcel_049_" + Page.User.Identity.Name + ".xls";// Path.GetTempFileName(); if (bz.CreateExcel1v2(filename, tdmIncFrom.DateValue, tdmIncTo.DateValue, tdmCallFrom.DateValue, tdmCallTo.DateValue, SLMUtil.SafeInt(cmbTelesale.SelectedValue), cmbTelesaleName.SelectedValue)) { ExportExcel(filename, "BSAT_REPORT_" + DateTime.Now.ToString("yyyyMMdd_HHmm") + ".xls"); } else { AppUtil.ClientAlert(this, bz.ErrorMessage); } }