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);
}
