private void insertIntoList(ReceiptsCard rc) { int i = dataGridView.Rows.Count; // chưa có trong list --> thêm mới dataGridView.Rows.Add(); dataGridView.Rows[i].Cells[0].Value = (i + 1).ToString(); //STT dataGridView.Rows[i].Cells[1].Value = rc.id; //Id //Ttin thẻ string str = " Tên chủ thẻ: " + rc.CardHolderName; str = str + "\n Số thẻ: " + rc.CardNo; str = str + "\n Ngày hết hạn: " + rc.ExpiredDate; str = str + "\n Loại thẻ: " + rc.CardType; str = str + "\n Ngân hàng : " + rc.Bank; dataGridView.Rows[i].Cells[2].Value = str; //ProductId //ttin Transaction str = "Số GD: " + rc.TerminalId + "\n"; str = str + "\n Batch No: " + rc.BatchNo; str = str + "\n Trace No: " + rc.TraceNo; str = str + "\n Ref No: " + rc.RefNo; dataGridView.Rows[i].Cells[3].Value = str; //PromotionId dataGridView.Rows[i].Cells[4].Value = rc.TotalAmount; dataGridView.Rows[i].Cells[17].Value = "Xóa"; //Xóa DataGridViewRow row = dataGridView.Rows[i]; row.Height = 35; }
private void insertIntoList(ReceiptsCard rc) { int i = dataGridView.Rows.Count; // chưa có trong list --> thêm mới dataGridView.Rows.Add(); dataGridView.Rows[i].Cells[0].Value = (i + 1).ToString(); //STT dataGridView.Rows[i].Cells[1].Value = rc.id; //Id //Ttin thẻ string str = Common.clsLanguages.GetResource("CardHolderName") + " " + rc.CardHolderName; str = str + "\n" + Common.clsLanguages.GetResource("CardNumber") + " " + rc.CardNo; str = str + "\n" + Common.clsLanguages.GetResource("DeadlineDate") + ": " + rc.ExpiredDate; str = str + "\n" + Common.clsLanguages.GetResource("CardType") + ": " + rc.CardType; str = str + "\n" + Common.clsLanguages.GetResource("Banks") + ": " + rc.Bank; dataGridView.Rows[i].Cells[2].Value = str; //ProductId //ttin TransactionBanks str = Common.clsLanguages.GetResource("NoTracsition") + rc.TerminalId + "\n"; str = str + "\n Batch No: " + rc.BatchNo; str = str + "\n Trace No: " + rc.TraceNo; str = str + "\n Ref No: " + rc.RefNo; dataGridView.Rows[i].Cells[3].Value = str; //PromotionId dataGridView.Rows[i].Cells[4].Value = rc.TotalAmount; //dataGridView.Rows[i].Cells[17].Value = "Xóa"; //Xóa DataGridViewRow row = dataGridView.Rows[i]; row.Height = 35; }
private void dgvResult_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { string id = dgv.Rows[e.RowIndex].Cells[1].Value.ToString(); ReceiptsCard ob = bankCardBLL.GetReceiptCardWithID(id); if (ob != null) { txtReceiptId.Text = ob.ReceiptId; txtReceiptId.ReadOnly = true; if (!string.IsNullOrEmpty(ob.Bank)) { //check trong cbo cbbBank.SelectedIndex = 0; foreach (var item in cbbBank.Items) { KeyValuePair <string, string> itm = (KeyValuePair <string, string>)item; if (itm.Key == ob.Bank) { cbbBank.SelectedValue = ob.Bank; break; } } } txtCardNo.Text = ob.CardNo; txtCardHolderName.Text = ob.CardHolderName; txtExpiredDate.Text = ob.ExpiredDate; if (!string.IsNullOrEmpty(ob.CardType)) { //LoadBankType(); //check trong cbo cbbCardType.SelectedIndex = 0; foreach (var item in cbbCardType.Items) { KeyValuePair <string, string> itm = (KeyValuePair <string, string>)item; if (itm.Key == ob.CardType) { cbbCardType.SelectedValue = ob.CardType; break; } } } dtpCreateDate.Text = ob.CreatedDate; txtAppCode.Text = ob.AppCode; txtBatchNo.Text = ob.BatchNo; txtTransType.Text = ob.TransType; txtMerchantID.Text = ob.MerchantId; txtTerminalId.Text = ob.TerminalId; txtTraceNo.Text = ob.TraceNo; txtRefNo.Text = ob.RefNo; sId = ob.id; } } }
private void frmManageBankCard_Load(object sender, EventArgs e) { SetUIChanges(); ToUpper(); // receiptCard = new ReceiptsCard(); receiptCardSea = new ReceiptsCard(); bankCardBLL = new BankCardBLL(); LoadBank(); }
public int Update(ReceiptsCard obj) { /// 1: update thành công /// 0: Update ko thành công int res = 0; string queryStr = "UPDATE receiptscard SET "; if (!string.IsNullOrEmpty(obj.Bank)) { queryStr += string.Format(" Bank = '{0}',", obj.Bank); } if (!string.IsNullOrEmpty(obj.CardType)) { queryStr += string.Format(" CardType = '{0}',", obj.CardType); } queryStr += string.Format(" CardNo = '{0}',", obj.CardNo); queryStr += string.Format(" CardHolderName = '{0}',", obj.CardHolderName); if (!string.IsNullOrEmpty(obj.ExpiredDate)) { queryStr += string.Format(" ExpiredDate = '{0}',", obj.ExpiredDate); } queryStr += string.Format(" AppCode = '{0}',", obj.AppCode); queryStr += string.Format(" BatchNo = '{0}',", obj.BatchNo); queryStr += string.Format(" TransType = '{0}',", obj.TransType); queryStr += string.Format(" MerchantId = '{0}',", obj.MerchantId); queryStr += string.Format(" TerminalId = '{0}',", obj.TerminalId); queryStr += string.Format(" TraceNo = '{0}',", obj.TraceNo); queryStr += string.Format(" RefNo = '{0}',", obj.RefNo); queryStr += string.Format(" ModifiedBy = '{0}',", Program.Username); queryStr += " ModifiedDate = NOW()"; queryStr += string.Format(" WHERE id = '{0}'", obj.id); Program.destopService.DataExecute(Program.Username, Program.Password, queryStr, ref errorString); if (string.IsNullOrEmpty(errorString)) { res = 1; } return(res); }
private void btnThem_Click(object sender, EventArgs e) { double amt = double.Parse(txtSoTienTT.Text); double tt = double.Parse(lblTongTienPX.Text); if (amt <= tt && amt > 0) { ReceiptsCard rc = new ReceiptsCard(); rc.id = autoid.ToString(); rc.ReceiptId = ""; rc.CardNo = txtCardNo.Text; rc.CardHolderName = txtCardHolderName.Text; rc.ExpiredDate = txtExpiredDate.Text; rc.CreatedBy = Program.Username; //rc.CardType = cbbCardType.SelectedValue.ToString(); rc.CardType = "VISA"; //rc.Bank = cbbBank.SelectedValue.ToString(); rc.Bank = "ACB"; rc.TotalAmount = txtSoTienTT.Text; rc.TerminalId = txtTerminalId.Text; rc.MerchantId = txtMerchantID.Text; rc.TransType = txtTransType.Text; rc.BatchNo = txtBatchNo.Text; rc.TraceNo = txtTraceNo.Text; rc.RefNo = txtRefNo.Text; rc.AppCode = txtAppCode.Text; if (Program.lstCard == null) { Program.lstCard = new List <ReceiptsCard>(); } Program.lstCard.Add(rc); // insert vào grid insertIntoList(rc); double daTT = double.Parse(lblDaThanhToan.Text); daTT = daTT + amt; tt = tt - amt; lblDaThanhToan.Text = daTT.ToString("0,0"); lblTongTienPX.Text = tt.ToString("0,0"); } else { CustomMessageBox.MessageBox.ShowCustomMessageBox(Common.clsLanguages.GetResource("CardAmountLimit"), Common.clsLanguages.GetResource("Information"), Common.Config.CUSTOM_MESSAGEBOX_ICON.Information, Common.Config.CUSTOM_MESSAGEBOX_BUTTON.OK); } }
public DataTable SearchObjects(ReceiptsCard receiptCardSea, int page, out int TotalRecord) { int RecordPerPage = int.Parse(ConfigurationManager.AppSettings["MaxRecordDesk"]); int limit = (page - 1) * RecordPerPage; TotalRecord = 0; DataTable res = new DataTable(); DataSet ds = new DataSet(); string[][] param = { new string[] { "p_id", string.IsNullOrEmpty(receiptCardSea.id)?null:receiptCardSea.id }, new string[] { "p_ReceiptId", string.IsNullOrEmpty(receiptCardSea.ReceiptId)?null:receiptCardSea.ReceiptId }, new string[] { "p_CardNo", string.IsNullOrEmpty(receiptCardSea.CardNo)?null: receiptCardSea.CardNo }, new string[] { "p_CardHolderName", string.IsNullOrEmpty(receiptCardSea.CardHolderName)?null: receiptCardSea.CardHolderName }, new string[] { "p_ExpiredDate", string.IsNullOrEmpty(receiptCardSea.ExpiredDate)?null: receiptCardSea.ExpiredDate }, new string[] { "p_CardType", string.IsNullOrEmpty(receiptCardSea.CardType)?null:receiptCardSea.CardType }, new string[] { "p_Bank", string.IsNullOrEmpty(receiptCardSea.Bank)?null:receiptCardSea.Bank }, new string[] { "p_TotalAmount", string.IsNullOrEmpty(receiptCardSea.TotalAmount)?null:receiptCardSea.TotalAmount }, new string[] { "p_TerminalId", string.IsNullOrEmpty(receiptCardSea.TerminalId)?null:receiptCardSea.TerminalId }, new string[] { "p_MerchantId", string.IsNullOrEmpty(receiptCardSea.MerchantId)?null:receiptCardSea.MerchantId }, new string[] { "p_TransType", string.IsNullOrEmpty(receiptCardSea.TransType)?null:receiptCardSea.TransType }, new string[] { "p_BatchNo", string.IsNullOrEmpty(receiptCardSea.BatchNo)?null:receiptCardSea.BatchNo }, new string[] { "p_TraceNo", string.IsNullOrEmpty(receiptCardSea.TraceNo)?null:receiptCardSea.TraceNo }, new string[] { "p_RefNo", string.IsNullOrEmpty(receiptCardSea.RefNo)?null:receiptCardSea.RefNo }, new string[] { "p_CreatedBy", string.IsNullOrEmpty(receiptCardSea.CreatedBy)?null:receiptCardSea.CreatedBy }, new string[] { "p_CreatedDate", string.IsNullOrEmpty(receiptCardSea.CreatedDate)?null:receiptCardSea.CreatedDate }, new string[] { "p_ModifiedBy", string.IsNullOrEmpty(receiptCardSea.ModifiedBy)?null:receiptCardSea.ModifiedBy }, new string[] { "p_ModifiedDate", string.IsNullOrEmpty(receiptCardSea.ModifiedDate)?null:receiptCardSea.ModifiedDate }, new string[] { "p_Appcode", string.IsNullOrEmpty(receiptCardSea.AppCode)?null:receiptCardSea.AppCode }, new string[] { "p_NoStart", limit.ToString() }, new string[] { "p_NoEnd", RecordPerPage.ToString() } }; Program.destopService.DataStoreProcQuery_Param(Program.Username, Program.Password, "spSearch_ReceiptCard", ref ds, param, ref errorString); if (string.IsNullOrEmpty(errorString)) { res = ds.Tables[0]; TotalRecord = int.Parse(ds.Tables[1].Rows[0][0].ToString()); } else { res = null; } return(res); }
private void btnSearch_Click(object sender, EventArgs e) { lblTB1.Text = "..."; lblTB.Text = "..."; curPage = 1; totalPage = 1; receiptCardSea = new ReceiptsCard(); receiptCardSea.id = sId; receiptCardSea.ReceiptId = txtReceiptId.Text; receiptCardSea.CardNo = txtCardNo.Text; receiptCardSea.CardHolderName = txtCardHolderName.Text; receiptCardSea.ExpiredDate = txtExpiredDate.Text; if (cbbCardType.SelectedIndex != 0) { receiptCardSea.CardType = cbbCardType.SelectedValue.ToString(); } else { receiptCardSea.CardType = ""; } if (cbbBank.SelectedIndex != 0) { receiptCardSea.Bank = cbbBank.SelectedValue.ToString(); } else { receiptCardSea.Bank = ""; } receiptCardSea.TerminalId = txtTerminalId.Text; receiptCardSea.MerchantId = txtMerchantID.Text; receiptCardSea.TransType = txtTransType.Text; receiptCardSea.BatchNo = txtBatchNo.Text; receiptCardSea.TraceNo = txtTraceNo.Text; receiptCardSea.RefNo = txtRefNo.Text; receiptCardSea.AppCode = txtAppCode.Text; if (chkDate.Checked == true) { receiptCardSea.CreatedDate = dtpCreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss"); } else { receiptCardSea.CreatedDate = ""; } SearchObjects(1); }
public ReceiptsCard GetReceiptCardWithID(string id) { ReceiptsCard reCard = new ReceiptsCard(); DataSet ds = new DataSet(); string query = @"SELECT * FROM `receiptscard` WHERE `Id`='" + id + "' "; Program.destopService.DataQuery(Program.Username, Program.Password, query, ref ds, "X", ref errorString); if (string.IsNullOrEmpty(errorString) && ds.Tables[0].Rows.Count > 0) { reCard.id = ds.Tables[0].Rows[0]["id"].ToString(); reCard.ReceiptId = ds.Tables[0].Rows[0]["ReceiptId"].ToString(); reCard.CardNo = ds.Tables[0].Rows[0]["CardNo"].ToString(); reCard.CardHolderName = ds.Tables[0].Rows[0]["CardHolderName"].ToString(); reCard.ExpiredDate = ds.Tables[0].Rows[0]["ExpiredDate"].ToString(); reCard.CardType = ds.Tables[0].Rows[0]["CardType"].ToString(); reCard.Bank = ds.Tables[0].Rows[0]["Bank"].ToString(); reCard.TotalAmount = ds.Tables[0].Rows[0]["TotalAmount"].ToString(); reCard.TerminalId = ds.Tables[0].Rows[0]["TerminalId"].ToString(); reCard.MerchantId = ds.Tables[0].Rows[0]["MerchantId"].ToString(); reCard.TransType = ds.Tables[0].Rows[0]["TransType"].ToString(); reCard.BatchNo = ds.Tables[0].Rows[0]["BatchNo"].ToString(); reCard.TraceNo = ds.Tables[0].Rows[0]["TraceNo"].ToString(); reCard.RefNo = ds.Tables[0].Rows[0]["RefNo"].ToString(); reCard.AppCode = ds.Tables[0].Rows[0]["AppCode"].ToString(); reCard.CreatedBy = ds.Tables[0].Rows[0]["CreatedBy"].ToString(); reCard.CreatedDate = ds.Tables[0].Rows[0]["CreatedDate"].ToString(); reCard.ModifiedBy = ds.Tables[0].Rows[0]["ModifiedBy"].ToString(); reCard.ModifiedDate = ds.Tables[0].Rows[0]["ModifiedDate"].ToString(); } else { reCard = null; } return(reCard); }
public static ReceiptsAll GetAllInfo(string ReceiptID) { ReceiptsAll res = new ReceiptsAll(); DataSet ds = new DataSet(); string[][] param = { new string[] { "p_ReceiptId", ReceiptID }, }; string errorString = ""; string cnStr = GetConnectionString(); DataStoreProcQuery_Param(cnStr, "spSelect_Receipt_AllInfo", ref ds, param, ref errorString); if (string.IsNullOrEmpty(errorString) && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; DataRow dr = dt.Rows[0]; Receipts rc = new Receipts(); rc.ReceiptId = dr["ReceiptId"].ToString(); rc.CreatedBy = dr["CreatedBy"].ToString(); rc.CreatedDate = dr["CreatedDate"].ToString(); rc.TotalAmountBeforeTax = double.Parse(dr["TotalAmountBeforeTax"].ToString()).ToString("0,0"); rc.TotalTax = double.Parse(dr["TotalTax"].ToString()).ToString("0,0"); rc.TotalAmount = double.Parse(dr["TotalAmount"].ToString()).ToString("0,0"); rc.DiscountAmount = double.Parse(dr["DiscountAmount"].ToString()).ToString("0,0"); rc.TotalMoney = double.Parse(dr["TotalMoney"].ToString()).ToString("0,0"); rc.CashPayAmt = double.Parse(dr["CashPayAmt"].ToString()).ToString("0,0"); rc.CardPayAmt = double.Parse(dr["CardPayAmt"].ToString()).ToString("0,0"); rc.ReturnAmt = double.Parse(dr["ReturnAmt"].ToString()).ToString("0,0"); res.receipt = rc; } ///// if (ds.Tables[1].Rows.Count > 0) { DataTable dt = ds.Tables[1]; List <ReceiptDetails> lst = new List <ReceiptDetails>(); foreach (DataRow dr in dt.Rows) { ReceiptDetails rc = new ReceiptDetails(); rc.ReceiptId = dr["ReceiptId"].ToString(); rc.ProductId = dr["ProductId"].ToString(); rc.ProductName = GetProductName(dr["ProductId"].ToString()); rc.Qty = double.Parse(dr["Qty"].ToString()).ToString("0,0"); rc.Price = double.Parse(dr["Price"].ToString()).ToString("0,0"); rc.TotalAmountBeforeTax = double.Parse(dr["TotalAmountBeforeTax"].ToString()).ToString("0,0"); rc.TaxAmount = double.Parse(dr["TaxAmount"].ToString()).ToString("0,0"); rc.TotalAmount = double.Parse(dr["TotalAmount"].ToString()).ToString("0,0"); lst.Add(rc); } res.lst_Detail = lst; } ///thẻ if (ds.Tables[2].Rows.Count > 0) { DataTable dt = ds.Tables[2]; List <ReceiptsCard> lst = new List <ReceiptsCard>(); foreach (DataRow dr in dt.Rows) { ReceiptsCard rc = new ReceiptsCard(); rc.ReceiptId = dr["ReceiptId"].ToString(); rc.CardNo = dr["CardNo"].ToString(); rc.CardHolderName = dr["CardHolderName"].ToString(); rc.ExpiredDate = dr["ExpiredDate"].ToString(); rc.CardType = dr["CardType"].ToString(); rc.Bank = dr["Bank"].ToString(); rc.TotalAmount = double.Parse(dr["TotalAmount"].ToString()).ToString("0,0"); lst.Add(rc); } res.lst_card = lst; } // ReceiptInfo if (ds.Tables[3].Rows.Count > 0) { DataTable dt = ds.Tables[3]; DataRow dr = dt.Rows[0]; ReceiptInfo rc = new ReceiptInfo(); rc.ReceiptId = dr["ReceiptId"].ToString(); rc.CustomerName = dr["CustomerName"].ToString(); rc.Address = dr["Address"].ToString(); rc.Phone = dr["Phone"].ToString(); rc.Note = dr["Note"].ToString(); res.receiptInfo = rc; } // ReceiptMember if (ds.Tables[4].Rows.Count > 0) { DataTable dt = ds.Tables[4]; DataRow dr = dt.Rows[0]; ReceiptMember rc = new ReceiptMember(); rc.ReceiptId = dr["ReceiptId"].ToString(); rc.MemberId = dr["MemberId"].ToString(); rc.CreatedBy = dr["CreatedBy"].ToString(); DataTable dte = GetMemberInfo(dr["MemberId"].ToString()); if (dte != null) { DataRow drr = dte.Rows[0]; rc.MemberCode = drr["MemberCode"].ToString(); rc.ObjectId = drr["ObjectId"].ToString(); rc.NumberOfVissits = drr["NumberOfVissits"].ToString(); rc.LastestDate = drr["LastestDate"].ToString(); rc.MemberType = drr["MemberType"].ToString(); rc.MemberScore = drr["MemberScore"].ToString(); rc.ObjectGroup = drr["ObjectGroup"].ToString(); rc.ObjectType = drr["ObjectType"].ToString(); rc.Tel = drr["Tel"].ToString(); rc.Email = drr["Email"].ToString(); rc.MemberCode = drr["Gender"].ToString(); rc.FullName = drr["FullName"].ToString(); rc.TemAdd = drr["TemAdd"].ToString(); } res.receiptMember = rc; } } else { res = null; } return(res); }
private void Update() { // check xem có trong db chưa? //string id = txtId.Text.Trim(); ReceiptsCard recard = new ReceiptsCard(); recard = bankCardBLL.GetReceiptCardWithID(sId); receiptCardSea = new ReceiptsCard(); receiptCardSea.id = sId; receiptCardSea.ReceiptId = txtReceiptId.Text; receiptCardSea.CardNo = txtCardNo.Text; receiptCardSea.CardHolderName = txtCardHolderName.Text; receiptCardSea.ExpiredDate = txtExpiredDate.Text; if (cbbCardType.SelectedIndex != 0) { receiptCardSea.CardType = cbbCardType.SelectedValue.ToString(); } else { receiptCardSea.CardType = ""; } if (cbbBank.SelectedIndex != 0) { receiptCardSea.Bank = cbbBank.SelectedValue.ToString(); } else { receiptCardSea.Bank = ""; } receiptCardSea.TerminalId = txtTerminalId.Text; receiptCardSea.MerchantId = txtMerchantID.Text; receiptCardSea.TransType = txtTransType.Text; receiptCardSea.BatchNo = txtBatchNo.Text; receiptCardSea.TraceNo = txtTraceNo.Text; receiptCardSea.RefNo = txtRefNo.Text; receiptCardSea.AppCode = txtAppCode.Text; if (recard != null) {// Cập nhật if (CustomMessageBox.MessageBox.ShowCustomMessageBox(clsLanguages.GetResource("SureUpdate"), clsLanguages.GetResource("Information"), Config.CUSTOM_MESSAGEBOX_ICON.Information, Config.CUSTOM_MESSAGEBOX_BUTTON.YESNO) == DialogResult.Yes) { //receiptCardSea.id = id; int i = bankCardBLL.Update(receiptCardSea); if (i == 1) { //txtId.ReadOnly = false; txtReceiptId.ReadOnly = false; sId = null; lblTB1.Text = Common.clsLanguages.GetResource("UpdateSuccess"); } else { lblTB1.Text = Common.clsLanguages.GetResource("UpdateFailed"); } } } SearchObjects(1); }
public ReceiptsAll GetAllInfo(string ReceiptID) { ReceiptsAll res = new ReceiptsAll(); DataSet ds = new DataSet(); string[][] param = { new string[] { "p_ReceiptId", ReceiptID }, }; Program.destopService.DataStoreProcQuery_Param(Program.Username, Program.Password, "spSelect_Receipt_AllInfo", ref ds, param, ref errorString); if (string.IsNullOrEmpty(errorString) && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; DataRow dr = dt.Rows[0]; Receipts rc = new Receipts(); rc.ReceiptId = dr["ReceiptId"].ToString(); rc.CreatedBy = dr["CreatedBy"].ToString(); rc.CreatedDate = Convert.ToDateTime(dr["CreatedDate"].ToString()).ToString("dd/MM/yy H:s"); rc.TotalAmountBeforeTax = double.Parse(dr["TotalAmountBeforeTax"].ToString()).ToString("0,0"); rc.TotalTax = double.Parse(dr["TotalTax"].ToString()).ToString("0,0"); rc.TotalAmount = double.Parse(dr["TotalAmount"].ToString()).ToString("0,0"); rc.DiscountAmount = double.Parse(dr["DiscountAmount"].ToString()).ToString("0,0"); rc.TotalMoney = double.Parse(dr["TotalMoney"].ToString()).ToString("0,0"); rc.CashPayAmt = double.Parse(dr["CashPayAmt"].ToString()).ToString("0,0"); rc.CardPayAmt = double.Parse(dr["CardPayAmt"].ToString()).ToString("0,0"); rc.ReturnAmt = double.Parse(dr["ReturnAmt"].ToString()).ToString("0,0"); rc.ServiceCostAmount = double.Parse(dr["ServiceCostAmount"].ToString()).ToString("0,0"); res.receipt = rc; } ///// if (ds.Tables[1].Rows.Count > 0) { Tuple <string, string> result; DataTable dt = ds.Tables[1]; List <ReceiptDetails> lst = new List <ReceiptDetails>(); foreach (DataRow dr in dt.Rows) { ReceiptDetails rc = new ReceiptDetails(); rc.ReceiptId = dr["ReceiptId"].ToString(); rc.ProductId = dr["ProductId"].ToString(); if (dr["ProductId"].ToString() != "DISCOUNT") { result = GetProductInfoForReceipt(dr["ProductId"].ToString()); //rc.ProductName = GetProductName(dr["ProductId"].ToString()); rc.ProductName = result.Item1; rc.IsBuffet = result.Item2; } else { rc.ProductName = dr["ProductId"].ToString(); rc.IsBuffet = "0"; } rc.Qty = double.Parse(dr["Qty"].ToString()).ToString("0,0"); rc.Price = double.Parse(dr["Price"].ToString()).ToString("0,0"); rc.TotalAmountBeforeTax = double.Parse(dr["TotalAmountBeforeTax"].ToString()).ToString("0,0"); rc.TaxAmount = double.Parse(dr["TaxAmount"].ToString()).ToString("0,0"); rc.TotalAmount = double.Parse(dr["TotalAmount"].ToString()).ToString("0,0"); lst.Add(rc); } //Duyệt lại lst va set theo thu tu List <ReceiptDetails> lstNew = new List <ReceiptDetails>(); //Lấy sp khác buffet foreach (ReceiptDetails rd in lst) { ReceiptDetails rds = new ReceiptDetails(); if (rd.IsBuffet != "1") { rds.ReceiptId = rd.ReceiptId; rds.ProductId = rd.ProductId; rds.ProductName = rd.ProductName; rds.IsBuffet = rd.IsBuffet; rds.Qty = rd.Qty; rds.Price = rd.Price; rds.TotalAmountBeforeTax = rd.TotalAmountBeforeTax; rds.TaxAmount = rd.TaxAmount; rds.TotalAmount = rd.TotalAmount; lstNew.Add(rds); } } if (lst.Count > lstNew.Count) { //Lấy sp là buffet và price != 0 foreach (ReceiptDetails rd in lst) { ReceiptDetails rds1 = new ReceiptDetails(); if (rd.IsBuffet == "1" && double.Parse(rd.Price) > 0) { rds1.ReceiptId = rd.ReceiptId; rds1.ProductId = rd.ProductId; rds1.ProductName = rd.ProductName; rds1.IsBuffet = rd.IsBuffet; rds1.Qty = rd.Qty; rds1.Price = rd.Price; rds1.TotalAmountBeforeTax = rd.TotalAmountBeforeTax; rds1.TaxAmount = rd.TaxAmount; rds1.TotalAmount = rd.TotalAmount; lstNew.Add(rds1); } } foreach (ReceiptDetails rd in lst) { ReceiptDetails rds2 = new ReceiptDetails(); if (rd.IsBuffet == "1" && double.Parse(rd.Price) == 0) { rds2.ReceiptId = rd.ReceiptId; rds2.ProductId = rd.ProductId; rds2.ProductName = rd.ProductName; rds2.IsBuffet = rd.IsBuffet; rds2.Qty = rd.Qty; rds2.Price = rd.Price; rds2.TotalAmountBeforeTax = rd.TotalAmountBeforeTax; rds2.TaxAmount = rd.TaxAmount; rds2.TotalAmount = rd.TotalAmount; lstNew.Add(rds2); } } } res.lst_Detail = lstNew; } ///thẻ if (ds.Tables[2].Rows.Count > 0) { DataTable dt = ds.Tables[2]; List <ReceiptsCard> lst = new List <ReceiptsCard>(); foreach (DataRow dr in dt.Rows) { ReceiptsCard rc = new ReceiptsCard(); rc.ReceiptId = dr["ReceiptId"].ToString(); rc.CardNo = dr["CardNo"].ToString(); rc.CardHolderName = dr["CardHolderName"].ToString(); rc.ExpiredDate = dr["ExpiredDate"].ToString(); rc.CardType = dr["CardType"].ToString(); rc.Bank = dr["Bank"].ToString(); rc.TotalAmount = double.Parse(dr["TotalAmount"].ToString()).ToString("0,0"); lst.Add(rc); } res.lst_card = lst; } // ReceiptInfo if (ds.Tables[3].Rows.Count > 0) { DataTable dt = ds.Tables[3]; DataRow dr = dt.Rows[0]; ReceiptInfo rc = new ReceiptInfo(); rc.ReceiptId = dr["ReceiptId"].ToString(); rc.CustomerName = dr["CustomerName"].ToString(); rc.Address = dr["Address"].ToString(); rc.Phone = dr["Phone"].ToString(); rc.Note = dr["Note"].ToString(); res.receiptInfo = rc; } // ReceiptMember if (ds.Tables[4].Rows.Count > 0) { DataTable dt = ds.Tables[4]; DataRow dr = dt.Rows[0]; ReceiptMember rc = new ReceiptMember(); rc.ReceiptId = dr["ReceiptId"].ToString(); rc.MemberId = dr["MemberId"].ToString(); rc.CreatedBy = dr["CreatedBy"].ToString(); DataTable dte = GetMemberInfo(dr["MemberId"].ToString()); if (dte != null) { DataRow drr = dte.Rows[0]; rc.MemberCode = drr["MemberCode"].ToString(); rc.ObjectId = drr["ObjectId"].ToString(); rc.NumberOfVissits = drr["NumberOfVissits"].ToString(); rc.LastestDate = drr["LastestDate"].ToString(); rc.MemberType = drr["MemberType"].ToString(); rc.MemberScore = drr["MemberScore"].ToString(); rc.ObjectGroup = drr["ObjectGroup"].ToString(); rc.ObjectType = drr["ObjectType"].ToString(); rc.Tel = drr["Tel"].ToString(); rc.Email = drr["Email"].ToString(); rc.MemberCode = drr["Gender"].ToString(); rc.FullName = drr["FullName"].ToString(); rc.TemAdd = drr["TemAdd"].ToString(); } res.receiptMember = rc; } } else { res = null; } return(res); }