public bool CouponPrint()
{
AccessCmd cmd = new AccessCmd();
try
{
//读取数据库
string strSql = "select * from t_bz_coupon_print";
OleDbDataReader reader = cmd.ExecuteReader(strSql);
StringBuilder sbPrintInfo = new StringBuilder();
StringBuilder sbId = new StringBuilder();
while (reader.Read())
{
sbId.Append("'").Append(reader.GetString(0)).Append("',");
sbPrintInfo.Append(reader.GetString(1)).Append("$").Append(reader.GetString(2)).Append("$").Append(reader.GetDateTime(3).ToString()).Append("$")
.Append(reader.GetString(4)).Append("@");
}
reader.Close();
if (sbPrintInfo.Length > 0)
{
string strPrintInfo = sbPrintInfo.ToString(0, sbPrintInfo.Length - 1);
string strIds = sbId.ToString(0, sbId.Length - 1);
//上传数据
request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/CouponPrint?strTerminalNo=" + GlobalVariables.StrTerminalNo + "&strPrintContent=" +
strPrintInfo, "");
XmlDocument doc = new XmlDocument();
string strXml = request.HtmlDocument;
doc.LoadXml(strXml);
string strReturn = doc.GetElementsByTagName("return").Item(0).InnerText.Trim();
if (strReturn.Equals("OK"))
{
//删除数据库记录
strSql = "delete from t_bz_coupon_print where strId in (" + strIds + ")";
cmd.ExecuteNonQuery(strSql);
}
}
return true;
}
catch (Exception e)
{
ErrorLog.log(e);
return false;
}
finally
{
cmd.Close();
}
}
internal void SynParam()
{
//下载参数信息
request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/TerminalParam?strTerminalNo=" + GlobalVariables.StrTerminalNo, "");
string strXml = request.HtmlDocument;
if (strXml.IndexOf("<params>") > 0)
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(strXml);
//删除原纪录
AccessCmd cmd = new AccessCmd();
string strSql = "delete from t_bz_terminal_param where strParamName<>'strTerminalNo' and strParamName<>'strServerUrl'";
cmd.ExecuteNonQuery(strSql);
//增加新纪录
XmlNodeList xnl = doc.GetElementsByTagName("param");
for (int i = 0; i < xnl.Count; i++)
{
XmlElement xe = (XmlElement)xnl.Item(i);
//获取信息
string strId = xe.ChildNodes.Item(0).InnerText.Trim();
string strParamName = xe.ChildNodes.Item(1).InnerText.Trim();
string strParamValue = xe.ChildNodes.Item(2).InnerText.Trim();
//更新数据库
strSql = "insert into t_bz_terminal_param (strId,strParamName,strParamValue) values ('" + strId + "','" + strParamName + "','" + strParamValue + "')";
cmd.ExecuteNonQuery(strSql);
}
cmd.Close();
}
}
public void download()
{
AccessCmd cmd = new AccessCmd();
AccessCmd comd = new AccessCmd(0);
//下载界面元素信息
try
{
request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/TemplateParam?strTerminalNo=" + GlobalVariables.StrTerminalNo, "");
XmlDocument doc = new XmlDocument();
string strXml = request.HtmlDocument;
Console.WriteLine(strXml);
if (strXml.IndexOf("<templates>") >= 0)
{
//加载服务器信息
doc.LoadXml(strXml);
//加载顶部框架信息
XmlNodeList xnlTop = doc.GetElementsByTagName("top").Item(0).ChildNodes;
XmlNodeList xnlBottom = doc.GetElementsByTagName("bottom").Item(0).ChildNodes;
XmlNodeList xnlMiddle = doc.GetElementsByTagName("middle").Item(0).ChildNodes;
List<XmlNodeList> lst_xnl = new List<XmlNodeList>();
lst_xnl.Add(xnlTop);
for (int j = 0; j < xnlMiddle.Count; j++)
{
lst_xnl.Add(xnlMiddle[j].ChildNodes);
}
lst_xnl.Add(xnlBottom);
//加载本地信息
string strSql = "select * from t_bz_templates order by strId asc";
OleDbDataReader reader = comd.ExecuteReader(strSql);
List<Element> lstLocal = new List<Element>();
while (reader.Read())
{
Element element = new Element(reader);
lstLocal.Add(element);
}
reader.Close();
int index = 0;
//依次对比服务器与本地信息，保证两者一致
for (int t = 0; t < lst_xnl.Count; t++)
{
XmlNodeList xnlTemp = lst_xnl[t];
for (int i = 0; i < xnlTemp.Count; i++)
{
try
{
//获得服务器记录信息
XmlElement xe = (XmlElement)xnlTemp[i];
String strLocation, strSize, strBgImage, strFontFamily, strContent, strFontSize, strFontColor, strSort;
getTemplateProps(xe, out strLocation, out strSize, out strBgImage, out strFontFamily, out strContent, out strFontSize, out strFontColor, out strSort);
//比对本地信息
Element localtemplate = lstLocal.ElementAt(Convert.ToInt16(strSort) - 1);
//找到本地信息，先更新图片
bool bolImg = true;
bolImg = createImg("template", strBgImage);
//图片操作正常，删除原图片并更新数据库
if (bolImg)
{
comd.ExecuteNonQuery("update t_bz_templates set strLocation='" + strLocation + "',strSize='" + strSize + "',strFontFamily='" + strFontFamily +
"',strContent='" + strContent + "',intFontSize=" + Convert.ToInt16(strFontSize) + ",strFontColor='" + strFontColor + "' where strName='"+localtemplate.strName+"'");
}
index++;
continue;
}
catch (Exception e)
{
ErrorLog.log(e);
}
}
}
}
}
catch (Exception e)
{
ErrorLog.log(e);
}
comd.Close();
//下载商家信息
try
{
request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/ShopDownload?strTerminalNo=" + GlobalVariables.StrTerminalNo, "");
XmlDocument doc = new XmlDocument();
string strXml = request.HtmlDocument;
if (strXml.IndexOf("<shops>") > 0)
{
//加载服务器信息
doc.LoadXml(strXml);
XmlNodeList xnlShop = doc.GetElementsByTagName("shop");
//加载本地信息
string strSql = "select strId,strSmallImg,strLargeImg from t_bz_shop";
OleDbDataReader reader = cmd.ExecuteReader(strSql);
List<Shop> lstShop = new List<Shop>();
while (reader.Read())
{
Shop shop = new Shop(reader);
lstShop.Add(shop);
}
reader.Close();
//依次对比服务器与本地信息，保证两者一致
for (int i = 0; i < xnlShop.Count; i++)
{
try
{
//获得服务器记录信息
XmlElement xeShop = (XmlElement)xnlShop.Item(i);
String strId, strBizName, strShopName, strTrade, strAddr, strIntro, strSmallImg, strLargeImg, intType, intSort;
getShopProps(xeShop, out strId, out strBizName, out strShopName, out strTrade, out strAddr, out strIntro, out strSmallImg, out strLargeImg, out intType, out intSort);
//比对本地信息
for (int j = 0; j < lstShop.Count; j++)
{
Shop localShop = lstShop.ElementAt(j);
if (localShop.StrId.Equals(strId))
{
//找到本地信息，先更新图片
bool bolImg = true;
if (strSmallImg.Length > 0 && !strSmallImg.Equals(localShop.StrSmallImg))
{
bolImg = createImg("shop", strSmallImg);
}
if (bolImg && strLargeImg.Length > 0 && !strLargeImg.Equals(localShop.StrLargeImg))
{
bolImg = createImg("shop", strLargeImg);
}
//考虑数据库中有记录，但图片不存在的情况
if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\shop\\" + strSmallImg))
{
bolImg = bolImg && createImg("shop", strSmallImg);
}
if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\shop\\" + strLargeImg))
{
bolImg = bolImg && createImg("shop", strLargeImg);
}
//图片操作正常，删除原图片并更新数据库
if (bolImg)
{
cmd.ExecuteNonQuery("update t_bz_shop set strBizName='" + strBizName + "',strShopName='" + strShopName + "',strTrade='" + strTrade + "',strAddr='" + strAddr +
"',strIntro='" + strIntro + "',strSmallImg='" + strSmallImg + "',strLargeImg='" + strLargeImg + "',intType=" + intType + ",intSort=" + intSort +
" where strId='" + strId + "'");
if (!strSmallImg.Equals(localShop.StrSmallImg))
File.Delete(System.Windows.Forms.Application.StartupPath + "\\shop\\" + localShop.StrSmallImg);
if (!strLargeImg.Equals(localShop.StrLargeImg))
File.Delete(System.Windows.Forms.Application.StartupPath + "\\shop\\" + localShop.StrLargeImg);
}
strId = "";
lstShop.Remove(localShop);
break;
}
}
if (strId.Length > 0)
{
//本地没有找到，先增加图片
bool bolImg = true;
if (strSmallImg.Length > 0)
{
bolImg = createImg("shop", strSmallImg);
}
if (bolImg && strLargeImg.Length > 0)
{
bolImg = createImg("shop", strLargeImg);
}
//图片操作正常，更新数据库
if (bolImg)
{
cmd.ExecuteNonQuery("insert into t_bz_shop(strId,strBizName,strShopName,strTrade,strAddr,strIntro,strSmallImg,strLargeImg,intType,intSort) values('" +
strId + "','" + strBizName + "','" + strShopName + "','" + strTrade + "','" + strAddr + "','" + strIntro + "','" + strSmallImg + "','" + strLargeImg +
"'," + intType + "," + intSort + ")");
}
}
}
catch (Exception e)
{
ErrorLog.log(e);
}
}
//删除本地没有匹配的记录
for (int i = 0; i < lstShop.Count; i++)
{
Shop localShop = lstShop.ElementAt(i);
cmd.ExecuteNonQuery("delete from t_bz_shop where strId='" + localShop.StrId + "'");
if (localShop.StrSmallImg.Length > 0)
File.Delete(System.Windows.Forms.Application.StartupPath + "\\shop\\" + localShop.StrSmallImg);
if (localShop.StrLargeImg.Length > 0)
File.Delete(System.Windows.Forms.Application.StartupPath + "\\shop\\" + localShop.StrLargeImg);
}
}
}
catch (Exception e)
{
ErrorLog.log(e);
}
//下载优惠券信息
try
{
request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/CouponDownload?strTerminalNo=" + GlobalVariables.StrTerminalNo, "");
XmlDocument doc = new XmlDocument();
string strXml = request.HtmlDocument;
if (strXml.IndexOf("<coupons>") > 0)
{
//加载服务器信息
doc.LoadXml(strXml);
XmlNodeList xnlCoupon = doc.GetElementsByTagName("coupon");
//加载本地信息
string strSql = "select strId,strSmallImg,strLargeImg,strPrintImg from t_bz_coupon";
OleDbDataReader reader = cmd.ExecuteReader(strSql);
List<Coupon> lstCoupon = new List<Coupon>();
while (reader.Read())
{
Coupon coupon = new Coupon(reader);
lstCoupon.Add(coupon);
}
reader.Close();
//依次对比服务器与本地信息，保证两者一致
for (int i = 0; i < xnlCoupon.Count; i++)
{
try
{
//获得服务器记录信息
XmlElement xeCoupon = (XmlElement)xnlCoupon.Item(i);
String strId, strName, dtActiveTime, dtExpireTime, strShopId, strSmallImg, strLargeImg, strPrintImg, strIntro, strInstruction;
int intVip, intRecommend, intSendBySM;
float flaPrice;
getCouponProps(xeCoupon, out strId, out strName, out dtActiveTime, out dtExpireTime, out strShopId, out intVip, out flaPrice, out intRecommend,
out strSmallImg, out strLargeImg, out strPrintImg, out strIntro, out strInstruction,out intSendBySM);
//比对本地信息
for (int j = 0; j < lstCoupon.Count; j++)
{
Coupon localCoupon = lstCoupon.ElementAt(j);
if (localCoupon.StrId.Equals(strId))
{
//找到本地信息，先更新图片
bool bolImg = true;
if (strSmallImg.Length > 0 && !strSmallImg.Equals(localCoupon.StrSmallImg))
{
bolImg = createImg("coupon", strSmallImg);
}
if (bolImg && strLargeImg.Length > 0 && !strLargeImg.Equals(localCoupon.StrLargeImg))
{
bolImg = createImg("coupon", strLargeImg);
}
if (bolImg && strPrintImg.Length > 0 && !strPrintImg.Equals(localCoupon.StrPrintImg))
{
bolImg = createImg("coupon", strPrintImg);
}
//考虑数据库中有记录，但图片不存在的情况
if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + strSmallImg))
{
bolImg = bolImg && createImg("coupon", strSmallImg);
}
if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + strLargeImg))
{
bolImg = bolImg && createImg("coupon", strLargeImg);
}
if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + strPrintImg))
{
bolImg = bolImg && createImg("coupon", strPrintImg);
}
//图片操作正常，删除原图片并更新数据库
if (bolImg)
{
cmd.ExecuteNonQuery("update t_bz_coupon set strName='" + strName + "',dtActiveTime='" + dtActiveTime + "',dtExpireTime='" + dtExpireTime +
"',strShopId='" + strShopId + "',intVip=" + intVip + ",intRecommend=" + intRecommend + ",flaPrice=" + flaPrice + ",strSmallImg='" + strSmallImg +
"',strLargeImg='" + strLargeImg + "',strPrintImg='" + strPrintImg + "',strIntro='" + strIntro + "',strInstruction='" + strInstruction + "',intSendBySM=" + intSendBySM +
" where strId='" + strId + "'");
if (!strSmallImg.Equals(localCoupon.StrSmallImg))
File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrSmallImg);
if (!strLargeImg.Equals(localCoupon.StrLargeImg))
File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrLargeImg);
if (!strPrintImg.Equals(localCoupon.StrPrintImg))
File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrPrintImg);
}
strId = "";
lstCoupon.Remove(localCoupon);
break;
}
}
if (strId.Length > 0)
{
//本地没有找到，先增加图片
bool bolImg = true;
if (strSmallImg.Length > 0)
{
bolImg = createImg("coupon", strSmallImg);
}
if (bolImg && strLargeImg.Length > 0)
{
bolImg = createImg("coupon", strLargeImg);
}
if (bolImg && strPrintImg.Length > 0)
{
bolImg = createImg("coupon", strPrintImg);
}
//图片操作正常，更新数据库
if (bolImg)
{
cmd.ExecuteNonQuery("insert into t_bz_coupon(strId,strName,dtActiveTime,dtExpireTime,strShopId,intVip,intRecommend,flaPrice,strSmallImg,strLargeImg," +
"strPrintImg,strIntro,strInstruction) values('" + strId + "','" + strName + "','" + dtActiveTime + "','" + dtExpireTime + "','" + strShopId + "'," +
intVip + "," + intRecommend + "," + flaPrice + ",'" + strSmallImg + "','" + strLargeImg + "','" + strPrintImg + "','" + strIntro + "','" +
strInstruction + "')");
}
}
}
catch (Exception e)
{
ErrorLog.log(e);
}
}
//删除本地没有匹配的记录
for (int i = 0; i < lstCoupon.Count; i++)
{
Coupon localCoupon = lstCoupon.ElementAt(i);
cmd.ExecuteNonQuery("delete from t_bz_coupon where strId='" + localCoupon.StrId + "'");
if (localCoupon.StrSmallImg.Length > 0)
File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrSmallImg);
if (localCoupon.StrLargeImg.Length > 0)
File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrLargeImg);
if (localCoupon.StrPrintImg.Length > 0)
File.Delete(System.Windows.Forms.Application.StartupPath + "\\coupon\\" + localCoupon.StrPrintImg);
}
}
}
catch (Exception e)
{
ErrorLog.log(e);
}
//下载广告信息
try
{
request.OpenRequest(GlobalVariables.StrServerUrl + "/servlet/AdDownload?strTerminalNo=" + GlobalVariables.StrTerminalNo, "");
XmlDocument doc = new XmlDocument();
string strXml = request.HtmlDocument;
if (strXml.IndexOf("<ads>") > 0)
{
//加载服务器信息
doc.LoadXml(strXml);
XmlNodeList xnlAd = doc.GetElementsByTagName("ad");
//加载本地信息
string strSql = "select strId,intType,strContent from t_bz_advertisement";
OleDbDataReader reader = cmd.ExecuteReader(strSql);
List<Advertisement> lstAd = new List<Advertisement>();
while (reader.Read())
{
Advertisement ad = new Advertisement(reader);
lstAd.Add(ad);
}
reader.Close();
//依次对比服务器与本地信息，保证两者一致
for (int i = 0; i < xnlAd.Count; i++)
{
try
{
//获得服务器记录信息
XmlElement xeAd = (XmlElement)xnlAd.Item(i);
String strId, strName, strContent, dtStartTime, dtEndTime;
int intType;
getAdProps(xeAd, out strId, out strName, out intType, out strContent, out dtStartTime, out dtEndTime);
//比对本地信息
for (int j = 0; j < lstAd.Count; j++)
{
Advertisement localAd = lstAd.ElementAt(j);
if (localAd.StrId.Equals(strId))
{
//找到本地信息，先更新图片
bool bolImg = true;
if (intType < 3 && strContent.Length > 0 && !strContent.Equals(localAd.StrContent))
{
if (intType == 1)
{
bolImg = createImg("ad", strContent);
}
else if (intType == 2)
{
string[] aryFile = strContent.Split(new char[] { ',' });
for (int k = 0; k < aryFile.Length; k++)
{
bolImg = bolImg && createImg("ad", aryFile[k]);
}
}
}
//考虑数据库中有记录，但图片不存在的情况
if (intType == 1 && !File.Exists(System.Windows.Forms.Application.StartupPath + "\\ad\\" + strContent))
{
bolImg = bolImg && createImg("ad", strContent);
}
else if (intType == 2)
{
string[] aryFile = strContent.Split(new char[] { ',' });
for (int k = 0; k < aryFile.Length; k++)
{
if (!File.Exists(System.Windows.Forms.Application.StartupPath + "\\ad\\" + aryFile[k]))
{
bolImg = bolImg && createImg("ad", aryFile[k]);
}
}
}
//图片操作正常，删除原图片并更新数据库
if (bolImg)
{
cmd.ExecuteNonQuery("update t_bz_advertisement set strName='" + strName + "',intType=" + intType + ",strContent='" + strContent +
"',dtStartTime='" + dtStartTime + "',dtEndTime='" + dtEndTime + "' where strId='" + strId + "'");
if (localAd.IntType == 1 && !strContent.Equals(localAd.StrContent))
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ad\\" + localAd.StrContent);
}
else if (localAd.IntType == 2 && !strContent.Equals(localAd.StrContent))
{
string[] aryFile = localAd.StrContent.Split(new char[] { ',' });
for (int k = 0; k < aryFile.Length; k++)
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ad\\" + aryFile[k]);
}
}
}
strId = "";
lstAd.Remove(localAd);
break;
}
}
if (strId.Length > 0)
{
//本地没有找到，先增加图片
bool bolImg = true;
if (intType < 3 && strContent.Length > 0)
{
if (intType == 1)
{
bolImg = createImg("ad", strContent);
}
else if (intType == 2)
{
string[] aryFile = strContent.Split(new char[] { ',' });
for (int k = 0; k < aryFile.Length; k++)
{
bolImg = bolImg && createImg("ad", aryFile[k]);
}
}
}
//图片操作正常，更新数据库
if (bolImg)
{
cmd.ExecuteNonQuery("insert into t_bz_advertisement(strId,strName,intType,strContent,dtStartTime,dtEndTime) values('" + strId + "','" + strName + "'," +
intType + ",'" + strContent + "','" + dtStartTime + "','" + dtEndTime + "')");
}
}
}
catch (Exception e)
{
ErrorLog.log(e);
}
}
//删除本地没有匹配的记录
for (int i = 0; i < lstAd.Count; i++)
{
Advertisement localAd = lstAd.ElementAt(i);
cmd.ExecuteNonQuery("delete from t_bz_advertisement where strId='" + localAd.StrId + "'");
if (localAd.StrContent.Length > 0)
{
if (localAd.IntType == 1)
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ad\\" + localAd.StrContent);
}
else if (localAd.IntType == 2)
{
string[] aryFile = localAd.StrContent.Split(new char[] { ',' });
for (int k = 0; k < aryFile.Length; k++)
{
File.Delete(System.Windows.Forms.Application.StartupPath + "\\ad\\" + aryFile[k]);
}
}
}
}
}
}
catch (Exception e)
{
ErrorLog.log(e);
}
cmd.Close();
}
private void Option_MouseUp(object sender, MouseEventArgs e)
{
Button btn = (Button)sender;
switch (btn.Name)
{
case "Button_ModifyID":
btn.BackgroundImage = Image.FromFile(path + "\\images\\切图\\Option\\修改参数.jpg");
if (this.Pwd.Text.Equals(GlobalVariables.StrExitPwd))
{
if (this.ID.Text.Trim().Equals(""))
{
this.Label_Warning.Text = "请输入本机编码！";
}
else if (this.URL.Text.Trim().Equals(""))
{
this.Label_Warning.Text = "请输入远程URL！";
}
else
{
AccessCmd cmd = new AccessCmd();
cmd.ExecuteNonQuery("delete from t_bz_terminal_param where strParamName='strTerminalNo' or strParamName='strServerUrl'");
cmd.ExecuteNonQuery("insert into t_bz_terminal_param(strId,strParamName,strParamValue) values('" + 99 + "','strTerminalNo','" + this.ID.Text.Trim() + "')");
cmd.ExecuteNonQuery("insert into t_bz_terminal_param(strId,strParamName,strParamValue) values('" + 99 + "','strServerUrl','" + this.URL.Text.Trim() + "')");
cmd.Close();
GlobalVariables.StrTerminalNo = this.ID.Text.Trim();
GlobalVariables.StrServerUrl = this.URL.Text.Trim();
this.Label_Warning.Text = "操作成功！";
}
}
else
{
this.Label_Warning.Text = "密码错误，请重新输入！";
}
return;
case "Button_Exit":
btn.BackgroundImage = Image.FromFile(path + "\\images\\切图\\Option\\退出系统.jpg");
if (this.Pwd.Text.Equals(GlobalVariables.StrExitPwd))
{
Program.Exit();
}
else
{
this.Label_Warning.Text = "密码错误，请重新输入！";
}
return;
case "Buttom_Close":
btn.BackgroundImage = Image.FromFile(path + "\\images\\切图\\Option\\关闭.jpg");
this.Close();
return;
case "Button_Paper":
btn.BackgroundImage = Image.FromFile(path + "\\images\\切图\\Option\\换纸结束.jpg");
if (this.Pwd.Text.Equals(GlobalVariables.StrExitPwd))
{
AccessCmd cmd = new AccessCmd();
cmd.ExecuteNonQuery("update t_bz_print_total set intPrintTotal=0");
cmd.Close();
this.Label_Warning.Text = "操作成功！";
}
else
{
this.Label_Warning.Text = "密码错误，请重新输入！";
}
return;
}
}
private void DoWork()
{
try
{
printQueue pq = new printQueue();
Dictionary<string, int> myprinter;
string defaultPrinterName = Printer.GetDeaultPrinterName();
// MessageBox.Show(defaultPrinterName);
if (pq.CanelAllPrintJob() == false)
{
MyMsgBox mb = new MyMsgBox();
mb.ShowMsg("打印纸已用尽！暂停服务！", 3);
wait.CloseScrollBar();
return;
}
myprinter = pq.GetAllPrinterQueues();
if (0 == myprinter[defaultPrinterName])
{
if (!pd.PrinterSettings.IsValid)
{
MyMsgBox mb = new MyMsgBox();
mb.ShowMsg("打印机不可用！暂停服务！", 3);
wait.CloseScrollBar();
return;
}
pd.Print();
Application.DoEvents();
Thread.Sleep(500);
myprinter = pq.GetAllPrinterQueues();
if (myprinter[defaultPrinterName] == 0)
{
MyMsgBox mb = new MyMsgBox();
mb.ShowMsg("打印纸已用尽！暂停服务！", 3);
wait.CloseScrollBar();
return;
}
for (int i = 0; i <= 60; i += 1)
{
wait.SetProgressBarPositionP(i);//设置进度条当前位置
System.Threading.Thread.Sleep(100);//sleep一下减缓进度条进度，实际代码中，此处应该是实际的工作
}
myprinter = pq.GetAllPrinterQueues();
if (myprinter[defaultPrinterName] == 0)
{
string tempId = DateTime.Now.ToString("yyyyMMddHHmmss");
// long tempId = DateTime.Now.Ticks;
if (MD5code == "")
{
MD5code = "00000000";
}
string strSql = "insert into t_bz_coupon_print values('" + tempId + "','" + GlobalVariables.LoginUserId + "','" + pi.id + "',#" + DateTime.Now.ToString("yyyy-M-d H:m:s") + "#,'" + MD5code + "')";
AccessCmd cmd = new AccessCmd();
// MessageBox.Show(strSql);
cmd.ExecuteNonQuery(strSql);
strSql = "update t_bz_print_total set intPrintTotal=intPrintTotal+1";
cmd.ExecuteNonQuery(strSql);
strSql = "select * from t_bz_print_total";
OleDbDataReader reader = cmd.ExecuteReader(strSql);
int printNum = 0;
if (reader.Read())
{
printNum = reader.GetInt32(0);
}
if (printNum >= GlobalVariables.IntCouponPrint)
{
UploadInfo ui = new UploadInfo();
ui.PrintAlert(printNum);
}
reader.Close();
cmd.Close();
for (int i = 60; i <= 100; i += 1)
{
wait.SetProgressBarPositionP(i);//设置进度条当前位置
System.Threading.Thread.Sleep(50);//sleep一下减缓进度条进度，实际代码中，此处应该是实际的工作
}
}
else
{
MyMsgBox mb = new MyMsgBox();
mb.ShowMsg("打印纸已用尽！暂停服务！", 3);
wait.CloseScrollBar();
return;
}
}
else
{
MyMsgBox mb = new MyMsgBox();
mb.ShowMsg("打印纸已用尽！暂停服务！", 3);
wait.CloseScrollBar();
return;
}
}
catch (Exception e)
{
ErrorLog.log(e);
wait.CloseScrollBar();
return;
}
}