private void btnChangePayment_Click(object sender, EventArgs e)
{
string strSqlWhere = "";
DynamicParameters dynamicParams = new DynamicParameters();
strSqlWhere = "CheckCode=@CheckCode AND BusDate=@BusDate";
dynamicParams.Add("CheckCode", strChkOrder);
dynamicParams.Add("BusDate", checkBusDate);
TaCheckOrderInfo taCheckOrderInfo = new SQLiteDbHelper().QueryFirstByWhere <TaCheckOrderInfo>("Ta_CheckOrder", strSqlWhere, dynamicParams);
//new SystemData().GetTaOrderItem();
//TaCheckOrderInfo taCheckOrderInfo = CommonData.TaCheckOrder.FirstOrDefault(s => s.CheckCode.Equals(strChkOrder) && s.BusDate.Equals(checkBusDate));
if (taCheckOrderInfo != null)
{
dynamicParams = new DynamicParameters();
strSqlWhere = "CheckCode=@CheckCode AND BusDate=@BusDate";
dynamicParams.Add("CheckCode", strChkOrder);
dynamicParams.Add("BusDate", deDay.Text);
var lstOI = new SQLiteDbHelper().QueryMultiByWhere <TaOrderItemInfo>("Ta_OrderItem", strSqlWhere, dynamicParams);
FrmTaPaymentShop frmTaPaymentShop = new FrmTaPaymentShop(usrID,
strChkOrder,
sOrderType,
SetPrtInfo(lstOI),
checkBusDate,
taCheckOrderInfo);
frmTaPaymentShop.Location = panelControl4.Location;
frmTaPaymentShop.Size = panelControl4.Size;
frmTaPaymentShop.ShowDialog();
GetBindData(deDay.Text);
}
}
private void btnPay_Click(object sender, EventArgs e)
{
Stopwatch sw = new Stopwatch();
sw.Start();
string strSqlWhere = "";
DynamicParameters dynamicParams = new DynamicParameters();
strSqlWhere = "CheckCode=@CheckCode AND BusDate=@BusDate";
dynamicParams.Add("BusDate", checkBusDate);
dynamicParams.Add("CheckCode", checkCode);
List <TaOrderItemInfo> lstOi = new SQLiteDbHelper().QueryMultiByWhere <TaOrderItemInfo>("Ta_OrderItem", strSqlWhere, dynamicParams);
sw.Stop();
TimeSpan ts = sw.Elapsed;
Console.WriteLine("Time {0}", ts.TotalMilliseconds);
//SystemData systemData = new SystemData();
//systemData.GetTaCheckOrder();
TaCheckOrderInfo taCheckOrderInfo = CommonData.TaCheckOrder.FirstOrDefault(s => s.CheckCode.Equals(checkCode) && s.BusDate.Equals(checkBusDate));
strSqlWhere = "";
dynamicParams = new DynamicParameters();
strSqlWhere = "BusDate=@BusDate";
dynamicParams.Add("BusDate", checkBusDate);
if (checkOrderType.Equals(PubComm.ORDER_TYPE_SHOP))
{
FrmTaPaymentShop frmTaPaymentShop = new FrmTaPaymentShop(lstOi, usrID, checkCode, checkOrderType, checkCustID.ToString(), SetPrtInfo(), checkBusDate, taCheckOrderInfo, "");
if (frmTaPaymentShop.ShowDialog() == DialogResult.OK)
{
if (frmTaPaymentShop.returnPaid)
{
//new SystemData().GetShowAndPendOrderData("", strBusDate);
//GetBindData("", 0, false);
List <ShowAndPendOrderDataInfo> lstTmp = new SQLiteDbHelper().QueryMultiByWhere <ShowAndPendOrderDataInfo>("VIEW_ShowAndPendOrder", strSqlWhere, dynamicParams);
GetBindData(lstTmp, "", 0, false);
}
}
}
else if (checkOrderType.Equals(PubComm.ORDER_TYPE_DELIVERY))
{
FrmTaPaymentDelivery frmTaPaymentDelivery = new FrmTaPaymentDelivery(lstOi, usrID, checkCode, checkOrderType, checkCustID.ToString(), SetPrtInfo(), checkBusDate, taCheckOrderInfo, "");
if (frmTaPaymentDelivery.ShowDialog() == DialogResult.OK)
{
if (frmTaPaymentDelivery.returnPaid)
{
//new SystemData().GetShowAndPendOrderData("", strBusDate);
//GetBindData("", 0, false);
List <ShowAndPendOrderDataInfo> lstTmp = new SQLiteDbHelper().QueryMultiByWhere <ShowAndPendOrderDataInfo>("VIEW_ShowAndPendOrder", strSqlWhere, dynamicParams);
GetBindData(lstTmp, "", 0, false);
}
}
}
else if (checkOrderType.Equals(PubComm.ORDER_TYPE_COLLECTION))
{
FrmTaPaymentCollection frmTaPaymentCollection = new FrmTaPaymentCollection(lstOi, usrID, checkCode, checkOrderType, checkCustID.ToString(), SetPrtInfo(), checkBusDate, taCheckOrderInfo, "");
if (frmTaPaymentCollection.ShowDialog() == DialogResult.OK)
{
if (frmTaPaymentCollection.returnPaid)
{
//new SystemData().GetShowAndPendOrderData("", strBusDate);
//GetBindData("", 0, false);
List <ShowAndPendOrderDataInfo> lstTmp = new SQLiteDbHelper().QueryMultiByWhere <ShowAndPendOrderDataInfo>("VIEW_ShowAndPendOrder", strSqlWhere, dynamicParams);
GetBindData(lstTmp, "", 0, false);
}
}
}
}
