private void btnPanelOrder_Click(object sender, EventArgs e)
{
//var btn = (PanelControl)sender;
var btn = (LabelControl)sender;
int iNum = Convert.ToInt32(btn.Name.Replace("lblOrderNo", ""));
//new SystemData().GetTaCheckOrder();
//var lstCo = CommonData.TaCheckOrder.Where(s => s.CheckCode.Equals(lblOderNo[iNum - 1].Text));
string strSqlWhere = "";
DynamicParameters dynamicParams = new DynamicParameters();
strSqlWhere = " CheckCode=@CheckCode AND BusDate=@BusDate";
dynamicParams.Add("BusDate", strBustDate);
dynamicParams.Add("CheckCode", lblOderNo[iNum - 1].Text);
var lstCo = new SQLiteDbHelper().QueryMultiByWhere <TaCheckOrderInfo>("Ta_CheckOrder", strSqlWhere, dynamicParams);
if (lstCo.Any())
{
TaCheckOrderInfo taCheckOrderInfo = lstCo.FirstOrDefault();
FrmTaMain frmTaMain = new FrmTaMain(lblOderNo[iNum - 1].Text, taCheckOrderInfo.StaffID,
Convert.ToInt32(taCheckOrderInfo.CustomerID), strBustDate, true);
this.Hide();
frmTaMain.ShowDialog();
}
else
{
FrmTaPendOrder frmTaPendOrder = new FrmTaPendOrder(lblOderNo[iNum - 1].Text, strBustDate, txtTelNum.Text);
this.Hide();
frmTaPendOrder.ShowDialog();
}
}
private string GetPayType(string sCheckOrder, string sBusDate)
{
//new SystemData().GetTaCheckOrder();
//var lstChk = CommonData.TaCheckOrder.Where(s => s.CheckCode.Equals(sChkId) && s.BusDate.Equals(deDay.Text));
string strSqlWhere = "";
DynamicParameters dynamicParams = new DynamicParameters();
strSqlWhere = "CheckCode=@CheckCode AND BusDate=@BusDate";
dynamicParams.Add("CheckCode", sCheckOrder);
dynamicParams.Add("BusDate", sBusDate);
var lstChk = new SQLiteDbHelper().QueryMultiByWhere <TaCheckOrderInfo>("Ta_CheckOrder", strSqlWhere, dynamicParams);
string strPt = "Paid By ";
if (lstChk.Any())
{
TaCheckOrderInfo taCheckOrder = lstChk.FirstOrDefault();
if (Convert.ToDecimal(taCheckOrder.PayTypePay1) > 0)
{
strPt += taCheckOrder.PayType1 + " ";
}
if (Convert.ToDecimal(taCheckOrder.PayTypePay2) > 0)
{
strPt += taCheckOrder.PayType2 + " ";
}
if (Convert.ToDecimal(taCheckOrder.PayTypePay3) > 0)
{
strPt += taCheckOrder.PayType3 + " ";
}
if (Convert.ToDecimal(taCheckOrder.PayTypePay4) > 0)
{
strPt += taCheckOrder.PayType4 + " ";
}
if (Convert.ToDecimal(taCheckOrder.PayTypePay5) > 0)
{
strPt += taCheckOrder.PayType5 + " ";
}
}
return(strPt);
}
private TaCustomerInfo GetCustInfo(string custPhone)
{
//new SystemData().GetTaCustomer();
//var lstCust = CommonData.TaCustomer.Where(s => s.cusPhone.Equals(custPhone));
string strSqlWhere = "";
DynamicParameters dynamicParams = new DynamicParameters();
strSqlWhere = "cusPhone=@cusPhone";
dynamicParams.Add("cusPhone", custPhone);
List <TaCustomerInfo> lstCust = new SQLiteDbHelper().QueryMultiByWhere <TaCustomerInfo>("Ta_Customer", strSqlWhere, dynamicParams);
return(lstCust.Any() ? lstCust.FirstOrDefault() : null);
}
private void SetReadyTime()
{
if (!string.IsNullOrEmpty(txtTelNum.Text))
{
//new SystemData().GetTaCustomer();
//TaCustomerInfo taCustomerInfo = new TaCustomerInfo();
//var lstCust = CommonData.TaCustomer.Where(s => s.cusPhone.Equals(txtTelNum.Text));
string strSqlWhere = "";
DynamicParameters dynamicParams = new DynamicParameters();
strSqlWhere = "cusPhone=@cusPhone";
dynamicParams.Add("cusPhone", txtTelNum.Text.Trim());
List <TaCustomerInfo> lstCust = new SQLiteDbHelper().QueryMultiByWhere <TaCustomerInfo>("Ta_Customer", strSqlWhere, dynamicParams);
TaCustomerInfo taCustomerInfo = new TaCustomerInfo();
string strReadyTime = (!string.IsNullOrEmpty(txtHour.Text) && !string.IsNullOrEmpty(txtMinute.Text))
? CommonDAL.SetAddZeroFront(txtHour.Text) + @":" + CommonDAL.SetAddZeroFront(txtMinute.Text)
: " ";
if (lstCust.Any())
{
taCustomerInfo = lstCust.FirstOrDefault();
taCustomerInfo.cusReadyTime = strReadyTime;
_control.UpdateEntity(taCustomerInfo);
}
else
{
taCustomerInfo.cusPhone = txtTelNum.Text.Trim();
taCustomerInfo.cusReadyTime = strReadyTime;
_control.AddEntity(taCustomerInfo);
}
}
}
private void SetUsrComePhoneAndIsNewUser(string sCallPhone)
{
int iCustID = 0;
if (!string.IsNullOrEmpty(sCallPhone))
{
string strSqlWhere = "";
DynamicParameters dynamicParams = new DynamicParameters();
strSqlWhere = "BusDate=@BusDate AND CustPhoneNo=@CustPhoneNo";
dynamicParams.Add("BusDate", strBustDate);
dynamicParams.Add("CustPhoneNo", txtTelNum.Text.Trim());
List <TaComePhoneInfo> lstCpTmp = new SQLiteDbHelper().QueryMultiByWhere <TaComePhoneInfo>("Ta_ComePhone", strSqlWhere, dynamicParams);
//new SystemData().GetComePhoneInfo();
var lstCp = lstCpTmp.OrderByDescending(s => Convert.ToDateTime(s.ComePhoneTime)).Take(8);
//new SystemData().GetComePhoneInfo();
//var lstCp = CommonData.TaComePhoneInfo.Where(s => s.CustPhoneNo.Equals(txtTelNum.Text.Trim()) && s.BusDate.Equals(strBustDate))
// .OrderByDescending(s => Convert.ToDateTime(s.ComePhoneTime))
// .Take(8);
if (lstCp.Any())
{
int i = 0;
foreach (var taComePhoneInfo in lstCp)
{
pcCust[0].Visible = true;
lblCustPhone[i].Text = taComePhoneInfo.CustPhoneNo;
lblCustInfo[i].Text = taComePhoneInfo.ComePhoneTime;
//strCustID[i] = taCustomerInfo.ID.ToString();
i++;
}
}
//new SystemData().GetTaCustomer();
//TaCustomerInfo taCustomerInfo = new TaCustomerInfo();
//var lstCust = CommonData.TaCustomer.Where(s => s.cusPhone.Equals(txtTelNum.Text.Trim()));
strSqlWhere = "";
dynamicParams = new DynamicParameters();
strSqlWhere = "cusPhone=@cusPhone";
dynamicParams.Add("cusPhone", txtTelNum.Text.Trim());
List <TaCustomerInfo> lstCust = new SQLiteDbHelper().QueryMultiByWhere <TaCustomerInfo>("Ta_Customer", strSqlWhere, dynamicParams);
if (!lstCust.Any())
{
//taCustomerInfo = lstCust.FirstOrDefault();
lblNew.Visible = true;
btnDelivery.Enabled = false;
btnCollection.Enabled = false;
}
else
{
iCustID = lstCust.FirstOrDefault().ID;
lblNew.Visible = false;
btnDelivery.Enabled = true;
btnCollection.Enabled = true;
}
if (iCustID > 0)
{
//new SystemData().GetTaCheckOrder();
//var lstCo = CommonData.TaCheckOrder.Where(s => s.BusDate.Equals(strBustDate) && !s.IsPaid.Equals("Y")).OrderByDescending(s => Convert.ToDateTime(s.PayTime)).Take(5);
strSqlWhere = "";
dynamicParams = new DynamicParameters();
strSqlWhere = " BusDate=@BusDate AND IsPaid!=@IsPaid";
dynamicParams.Add("BusDate", strBustDate);
dynamicParams.Add("IsPaid", "Y");
var lstCoTmp = new SQLiteDbHelper().QueryMultiByWhere <TaCheckOrderInfo>("Ta_CheckOrder", strSqlWhere, dynamicParams);
var lstCo = lstCoTmp.OrderByDescending(s => Convert.ToDateTime(s.PayTime)).Take(5);
if (lstCo.Any())
{
int j = 0;
var lstCheck = iCustID <= 0 ? lstCo : lstCo.Where(s => s.CustomerID.Equals(iCustID.ToString()));
foreach (var taCheckOrderInfo in lstCheck)
{
pcOrder[j].Visible = true;
lblOderNo[j].Text = taCheckOrderInfo.CheckCode;
//按了SaveOrder保存的订单不显示单号
//lblOderNo[j].Visible = taCheckOrderInfo.IsSave.Equals("Y");
lblOderNo[j].Visible = true;
lblOrderTime[j].Text = taCheckOrderInfo.PayTime;
if (taCheckOrderInfo.PayOrderType.Equals(PubComm.ORDER_TYPE_DELIVERY))
{
pcOrder[j].BackColor = Color.ForestGreen;
}
else if (taCheckOrderInfo.PayOrderType.Equals(PubComm.ORDER_TYPE_SHOP))
{
pcOrder[j].BackColor = Color.HotPink;
}
else if (taCheckOrderInfo.PayOrderType.Equals(PubComm.ORDER_TYPE_COLLECTION))
{
pcOrder[j].BackColor = Color.Turquoise;
}
j++;
}
}
}
}
}
