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