protected void cmdSearch_Click(object sender, EventArgs e) { lblMessage.Text = string.Empty; lblCIF.Text = string.Empty; lblCustomerName.Text = string.Empty; lblCMND.Text = string.Empty; lblTelephone.Text = string.Empty; lblAddress.Text = string.Empty; lblAccountNumber.Text = string.Empty; lblAmount.Text = string.Empty; if (string.IsNullOrEmpty(txtCIF.Text)) { lblMessage.Text = "Nhập mã khách hàng"; txtCIF.Focus(); return; } if (string.IsNullOrEmpty(cboBranch.SelectedItem.Value)) { lblMessage.Text = "Chọn chi nhánh"; cboBranch.Focus(); return; } bool bValidate = false; using (PromotionEntities db = new PromotionEntities()) { var cust = db.CUSTOMERs.FirstOrDefault(t => t.CUSTOMER_CODE.Equals(txtCIF.Text)); if (cust != null) { lblCIF.Text = cust.CUSTOMER_CODE; lblCustomerName.Text = cust.CUSTOMER_NAME; lblCMND.Text = cust.LEGAL_ID; if (!string.IsNullOrEmpty(cust.TELEPHONE)) { lblTelephone.Text = cust.TELEPHONE; } if (!string.IsNullOrEmpty(cust.ADDRESS)) { lblAddress.Text = cust.ADDRESS; } string strAccount = string.Empty; var listAcc = db.AZ_ACCOUNT.Where(t => t.CUSTOMER_ID.Equals(txtCIF.Text.Trim())).ToList(); if (listAcc != null) { foreach (var azAccount in listAcc) { //strAccount += azAccount.ACCOUNT_NUMBER + "; "; } } bValidate = true; lblAccountNumber.Text = strAccount; } else { lblMessage.Text = "Thông tin khách hàng không phù hợp. "; } } if (bValidate) { using (DataModel.BLACKLIST_CUSTOMER_BO objBLACKLIST_CUSTOMER_BO = new DataModel.BLACKLIST_CUSTOMER_BO()) { DataModel.BLACKLIST_CUSTOMER objBLACKLIST_CUSTOMER = objBLACKLIST_CUSTOMER_BO.GetByCUSTOMER_ID(txtCIF.Text); if (objBLACKLIST_CUSTOMER != null) { lblMessage.Text = "Yêu cầu cấp lì xì không hợp lệ. Khách hàng thuộc danh sách cán bộ, nhân viên GPBank. Đề nghị kiểm tra lại thông tin."; bValidate = false; } } } if (bValidate) { using (DataModel.LiXi_BO objLiXi_BO = new DataModel.LiXi_BO()) { DataModel.LiXi objLiXi = objLiXi_BO.GetByCIF(txtCIF.Text); if (objLiXi != null) { string strPGD = string.Empty; using (DataModel.COMPANY_BO objT24_COMPANY_BO = new DataModel.COMPANY_BO()) { DataModel.COMPANY objT24_COMPANY = objT24_COMPANY_BO.GetByCOMPANY_CODE(objLiXi.CoCode); if (objT24_COMPANY != null) { strPGD = objT24_COMPANY.COMPANY_NAME; } } lblMessage.Text = "Khách hàng " + lblCustomerName.Text + " đã được cấp Lì xì vào " + objLiXi.Created.Value.ToString("dd/MM/yyyy HH:mm") + " tại " + strPGD + ". Đề nghị kiểm tra lại thông tin."; bValidate = false; } else { DateTime dtNow = DateTime.Now; DateTime dtFrom = new DateTime(dtNow.Year, dtNow.Month, dtNow.Day, 0, 0, 1); DateTime dtTo = new DateTime(dtNow.Year, dtNow.Month, dtNow.Day, 23, 59, 59); List <DataModel.LiXi> lstData = objLiXi_BO.GetByCoCode(cboBranch.SelectedItem.Value, dtFrom, dtTo).ToList(); if (lstData != null) { lstData = lstData.Where(o => !o.IsUsed.HasValue || (o.IsUsed.HasValue && o.IsUsed.Value)).ToList(); lblAmount.Text = lstData.Count.ToString(); if (lstData.Count < MAX_LIXI) { bValidate = true; } else { bValidate = false; lblMessage.Text = "Yêu cầu cấp Lì xì không hợp lệ. Điểm giao dịch đã cấp đủ số lượng (" + MAX_LIXI.ToString() + ") Lì xì trong ngày. Đề nghị kiểm tra lại thông tin."; } } } } } if (bValidate) { cmdAgree.Visible = true; } }
protected void cmdSearch_Click(object sender, EventArgs e) { lblMessage.Text = string.Empty; lblCIF.Text = string.Empty; lblCustomerName.Text = string.Empty; lblCMND.Text = string.Empty; lblTelephone.Text = string.Empty; lblAddress.Text = string.Empty; lblAccountNumber.Text = string.Empty; lblStatus.Text = string.Empty; if (string.IsNullOrEmpty(txtCIF.Text)) { lblMessage.Text = "Nhập mã khách hàng"; txtCIF.Focus(); return; } if (Session[Constant.USERNAME] != null) { using (PromotionEntities db = new PromotionEntities()) { var cust = db.CUSTOMERs.FirstOrDefault(t => t.CUSTOMER_CODE.Equals(txtCIF.Text)); if (cust != null) { lblCIF.Text = cust.CUSTOMER_CODE; lblCustomerName.Text = cust.CUSTOMER_NAME; lblCMND.Text = cust.LEGAL_ID; if (!string.IsNullOrEmpty(cust.TELEPHONE)) { lblTelephone.Text = cust.TELEPHONE; } if (!string.IsNullOrEmpty(cust.ADDRESS)) { lblAddress.Text = cust.ADDRESS; } string strAccount = string.Empty; var listAcc = db.AZ_ACCOUNT.Where(t => t.CUSTOMER_ID.Equals(txtCIF.Text.Trim())).ToList(); if (listAcc != null) { foreach (var azAccount in listAcc) { //strAccount += azAccount.ACCOUNT_NUMBER + "; "; } } lblAccountNumber.Text = strAccount; hdfCIF.Value = txtCIF.Text.Trim(); using (DataModel.LiXi_BO objLiXi_BO = new DataModel.LiXi_BO()) { DataModel.LiXi objLiXi = objLiXi_BO.GetByCIF(txtCIF.Text); if (objLiXi != null) { string strPGD = string.Empty; using (DataModel.COMPANY_BO objT24_COMPANY_BO = new DataModel.COMPANY_BO()) { DataModel.COMPANY objT24_COMPANY = objT24_COMPANY_BO.GetByCOMPANY_CODE(objLiXi.CoCode); if (objT24_COMPANY != null) { strPGD = objT24_COMPANY.COMPANY_NAME; } } lblStatus.Text = "Đã được cấp Lì xì vào " + objLiXi.Created.Value.ToString("dd/MM/yyyy HH:mm") + " tại " + strPGD + ". Cấp bởi " + objLiXi.CreatedBy; cmdDelete.Visible = true; } else { lblStatus.Text = "Khách hàng chưa được cấp Lì xì"; } } } else { lblMessage.Text = "Thông tin khách hàng không phù hợp. "; } } } }
//public SerialBook GetSerialBookFromT24(string strBookNumber, string strHost, string strPort, string strService, string strUserId, string strPwd, string strSchema, string strBOOK_TYPE, string strCIF, ref string strCategory) public SerialBook GetSerialBookFromT24(string strBookNumber, string strBOOK_TYPE, string strCIF, ref string strCategory) { SerialBook oBook = null; using (PromotionEntities db = new PromotionEntities()) { bool bResult = false; string strResponse = string.Empty; try { //string strAZCommandText = "SELECT ID,PASSBOOK.NUMBER,CUSTOMER,CURRENCY,PRINCIPAL,VALUE.DATE,MATURITY.DATE,CO.CODE,TERM FROM " + strSchema + "."; //strAZCommandText += "FBNK_AZ_ACCOUNT WHERE PASSBOOK.NUMBER='" + strBookNumber + "'"; //string strLDCommandText = "SELECT ID,CONTRACT.NO,CUSTOMER.ID,CURRENCY,AMOUNT,VALUE.DATE,FIN.MAT.DATE,CO.CODE,TERM FROM " + strSchema + "."; //strLDCommandText += "FBNK_LD_L002 WHERE CONTRACT.NO='" + strBookNumber + "'"; if (strBOOK_TYPE.ToUpper() == "AZ") { strResponse = string.Empty; var lstAZByCustomerID = db.AZ_ACCOUNT.Where(t => t.CUSTOMER_ID.Equals(strCIF)); if (lstAZByCustomerID != null) { foreach (var azAccount in lstAZByCustomerID) { Commons.Convertion _oConvertion = new Commons.Convertion(); if (azAccount.PASSBOOK_NUMBER != null && azAccount.PASSBOOK_NUMBER == strBookNumber) { oBook = new SerialBook(); oBook.Book_Number = azAccount.PASSBOOK_NUMBER; oBook.Customer_Id = azAccount.CUSTOMER_ID; oBook.Currency = azAccount.CURRENCY; oBook.TotalAmount = Convert.ToDouble(azAccount.PRINCIPAL); oBook.ValueDate = Convert.ToDateTime(azAccount.VALUE_DATE); oBook.MaturityDate = Convert.ToDateTime(azAccount.MATURITY_DATE); oBook.ACCOUNT_NUMBER = azAccount.ACCOUNT_NUMBER; oBook.CO_CODE = azAccount.CO_CODE; if (azAccount.THAM_GIA_KM != null) { oBook.ThamGiaKM = azAccount.THAM_GIA_KM; } if (azAccount.TERM != null && !string.IsNullOrEmpty(azAccount.TERM)) { oBook.TERM = azAccount.TERM; } strCategory = azAccount.CATEGORY; //reset response strResponse = string.Empty; var objCust = db.CUSTOMERs.FirstOrDefault(t => t.CUSTOMER_CODE.Equals(oBook.Customer_Id)); if (objCust != null) { oBook.Customer_Name = objCust.CUSTOMER_NAME; oBook.CMTND = objCust.LEGAL_ID; oBook.Sector = objCust.SECTOR; oBook.Telephone = objCust.TELEPHONE; } break; } } } } else //LD { strResponse = string.Empty; var objLD = db.AZ_ACCOUNT.SingleOrDefault(t => t.PASSBOOK_NUMBER.Equals(strBookNumber)); if (objLD != null) { Commons.Convertion _oConvertion = new Commons.Convertion(); oBook = new SerialBook(); oBook.Book_Number = objLD.PASSBOOK_NUMBER; oBook.Customer_Id = objLD.CUSTOMER_ID; oBook.Currency = objLD.CURRENCY; oBook.TotalAmount = Convert.ToDouble(objLD.PRINCIPAL); oBook.ValueDate = Convert.ToDateTime(objLD.VALUE_DATE); oBook.MaturityDate = Convert.ToDateTime(objLD.MATURITY_DATE);; oBook.ACCOUNT_NUMBER = objLD.ACCOUNT_NUMBER; oBook.CO_CODE = objLD.CO_CODE; if (objLD.TERM != null && !string.IsNullOrEmpty(objLD.TERM)) { oBook.TERM = objLD.TERM; } strCategory = objLD.CATEGORY; //reset response strResponse = string.Empty; var objCust = db.CUSTOMERs.FirstOrDefault(t => t.CUSTOMER_CODE.Equals(oBook.Customer_Id)); if (objCust != null) { oBook.Customer_Name = objCust.CUSTOMER_NAME; oBook.CMTND = objCust.LEGAL_ID; oBook.Sector = objCust.SECTOR; oBook.Telephone = objCust.TELEPHONE; } } } } catch (Exception oExc) { log.Error(oExc.Message); } if (oBook != null) { oBook.Customer_Name = SplitT24CustomerName(oBook.Customer_Name); TimeSpan ts = oBook.MaturityDate - oBook.ValueDate; int nPeriod = (int)(ts.TotalDays / 30); int nRemain = (int)(ts.TotalDays % 30); if (nRemain >= 28) { nPeriod++; } if (nPeriod > 0) { oBook.PeriodInWord = string.Format("{0} tháng.", nPeriod.ToString()); } else { int nWeeks = nRemain / 7; oBook.PeriodInWord = string.Format("{0} tuần.", nWeeks.ToString()); } } } return(oBook); }