public void Print(TQueueModel model, string area, int wait)
{
var open = TxOpenPrinter(0, 0);
var state = TxGetStatus2();
TxInit(); //初始化
TxDoFunction(TX_FEED, 15, 0); //走纸，留空行 15毫米
TxDoFunction(TX_HOR_POS, 15, 0); //距离左边15毫米
TxDoFunction(TX_FONT_SIZE, TX_SIZE_3X, TX_SIZE_2X); //设置标题字体大小
TxOutputStringLn("阳江市票务大厅排队叫号系统");
TxDoFunction(TX_FONT_SIZE, TX_SIZE_1X, TX_SIZE_1X); //设置字体
TxOutputStringLn("排队区域：" + area);
TxOutputStringLn("排队部门：" + model.unitName);
TxOutputStringLn("排队业务：" + model.busTypeName);
TxOutputString("当前号码：");
TxDoFunction(TX_FONT_BOLD, TX_ON, 0); //使用粗体
TxDoFunction(TX_FONT_SIZE, TX_SIZE_3X, TX_SIZE_3X); //设置字体
TxOutputStringLn(model.ticketNumber);
TxDoFunction(TX_FONT_SIZE, TX_SIZE_1X, TX_SIZE_1X); //设置字体
TxDoFunction(TX_FONT_BOLD, TX_OFF, 0); //关闭粗体
TxOutputStringLn(string.Format("你前面还有 {0} 人在等待。", wait.ToString()));
TxOutputStringLn("请在休息区等候，注意呼叫及大屏显示信息。");
TxOutputStringLn("过号无效，请您重新取号。");
TxOutputStringLn(string.Format(" {0} ", DateTime.Now));
TxDoFunction(TX_CUT, TX_CUT_PARTIAL, 5);//切纸，切纸前 走纸5毫米
TxClosePrinter();
}
//组织票数据 * 暂时不用了
private DataTable GetQueue(TQueueModel model, string area, string windowStr, int wait, string vip)
{
DataTable table = new DataTable("table");
table.Columns.AddRange(new DataColumn[]
{
new DataColumn ("id",typeof(string)),
new DataColumn ("area",typeof(string)),
new DataColumn ("windowStr",typeof(string)),
new DataColumn ("waitCount",typeof(string)),
new DataColumn ("unitSeq",typeof(string)),
new DataColumn ("busySeq",typeof(string)),
new DataColumn ("unitName",typeof(string)),
new DataColumn ("busyName",typeof(string)),
new DataColumn ("ticketNumber",typeof(string)),
new DataColumn ("cardId",typeof(string)),
new DataColumn ("reserveSeq",typeof(string)),
new DataColumn ("vip",typeof(string)),
});
DataRow row = table.NewRow();
row["id"] = model.id;
row["area"] = area;
row["windowStr"] = windowStr;
row["waitCount"] = wait.ToString();
row["unitSeq"] = model.unitSeq;
row["busySeq"] = model.busTypeSeq;
row["unitName"] = model.unitName;
row["busyName"] = model.busTypeName;
row["ticketNumber"] = model.ticketNumber;
row["cardId"] = string.IsNullOrEmpty(model.idCard) ? "" : model.idCard.Length > 6 ? model.idCard.Substring(model.idCard.Length - 6, 6) : model.idCard;
row["reserveSeq"] = model.reserveSeq;
row["vip"] = vip;
table.Rows.Add(row);
return table;
}
private void button1_Click(object sender, EventArgs e)
{
PrintHelper he = new PrintHelper();
TQueueModel model = new TQueueModel();
model.unitName = "123";
model.ticketNumber = "vs";
he.Print(model, "阳江", 10);
}
/// <summary>
/// 叫号 * 已弃用
/// </summary>
/// <param name="wlBusy"></param>
/// <param name="windowNumber"></param>
/// <param name="windowUser"></param>
/// <returns></returns>
public TCallModel CallNo(List <TWindowBusinessModel> wlBusy, string windowNumber, string windowUser)
{
try
{
var busyList = wlBusy.Select(w => w.busiSeq).ToList();
var unitList = wlBusy.Select(w => w.unitSeq).ToList();
this.db.Session.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
var date = DateTime.Now;
var lineFirst = db.Query <TQueueModel>().Where(q => busyList.Contains(q.busTypeSeq) && unitList.Contains(q.unitSeq) && q.state == 0 && q.ticketTime.Date == date.Date && q.appType == 1 && q.reserveStartTime <= date && q.reserveEndTime >= date).OrderBy(o => o.id).FirstOrDefault();
TQueueModel line = null;
if (lineFirst == null)
{
var lineQueue = db.Query <TQueueModel>().Where(q => busyList.Contains(q.busTypeSeq) && unitList.Contains(q.unitSeq) && q.state == 0 && q.ticketTime.Date == date.Date).OrderBy(o => o.id).ToList();//取到当天 窗口业务排队队列
line = lineQueue.FirstOrDefault();
if (line == null)
{
return(null);
}
}
else
{
line = lineFirst;
}
line.state = 1;
line.sysFlag = 1;
new TQueueDAL(this.db).Update(line);
var call = new TCallModel();
call.busiSeq = line.busTypeSeq;
call.handleId = DateTime.Now.ToString("yyyyMMddHHmmss");
call.handleTime = DateTime.Now;
call.idCard = line.idCard;
call.qId = line.id;
call.qNmae = line.qNmae;
call.state = 0;
call.ticketNumber = line.ticketNumber;
call.ticketTime = line.ticketTime;
call.unitSeq = line.unitSeq;
call.windowNumber = windowNumber;
call.windowUser = windowUser;
call.sysFlag = 0;
var ret = this.Insert(call);
this.db.Session.CommitTransaction();
return(ret);
}
catch
{
this.db.Session.RollbackTransaction();
return(null);
}
finally
{
this.db.Dispose();
}
}
//获取业务属性类型
string GetVipLever(TQueueModel model)
{
var isGreen = "";
var att = baList.Where(b => b.unitSeq == model.unitSeq && b.busiSeq == model.busTypeSeq).FirstOrDefault();
if (att != null)
{
isGreen = att.isGreenChannel == 1 ? "绿色通道" : "";
}
if (model.appType == 1 && model.type == 0 && model.reserveEndTime >= DateTime.Now && isGreen == "")
isGreen = "网上预约";
else if (model.type == 1 && isGreen == "")
isGreen = "网上申办";
return isGreen;
}
public int Delete(TQueueModel model)
{
return(this.db.Delete(model));
}
public int Update(TQueueModel model)
{
return(this.db.Update(model));
}
public TQueueModel Insert(TQueueModel model)
{
return(db.Insert(model));
}
/// <summary>
/// 排队 微信接口使用
/// </summary>
/// <param name="selectBusy"></param>
/// <param name="selectUnit"></param>
/// <param name="ticketStart"></param>
/// <param name="idCard"></param>
/// <param name="name"></param>
/// <param name="app"></param>
/// <returns></returns>
public TQueueModel QueueLine(string unitSeq, string unitName, string busiSeq, string busiName, string ticketStart, string idCard, string name, string wxId, TAppointmentModel app)
{
TQueueModel qModel = null;
try
{
LockAction.Run(LockKey.Queue, () =>
{
var maxNo = new TLineUpMaxNoDAL(this.db).GetModelList().Where(l => l.unitSeq == unitSeq && l.busiSeq == busiSeq).FirstOrDefault();
int ticketNo = maxNo == null ? 1 : maxNo.lineDate.Date != DateTime.Now.Date ? 1 : maxNo.maxNo + 1;
TQueueModel line = new TQueueModel();
line.busTypeName = busiName;
line.busTypeSeq = busiSeq;
line.qNumber = ticketNo.ToString();
line.state = 0;
line.ticketNumber = ticketStart + ticketNo.ToString("000");
line.ticketTime = DateTime.Now;
line.unitName = unitName;
line.unitSeq = unitSeq;
line.vipLever = "";
line.windowName = "";
line.windowNumber = "";
line.idCard = idCard;
line.qNmae = name;
line.sysFlag = 0;
line.wxId = wxId;
line.qType = 1;
if (app != null)
{
line.appType = app.appType;
line.reserveSeq = app.reserveSeq;
line.reserveStartTime = app.reserveStartTime;
line.reserveEndTime = app.reserveEndTime;
line.type = app.type;
}
line = this.Insert(line);
if (maxNo == null)
{
maxNo = new TLineUpMaxNoModel();
maxNo.areaSeq = "";
maxNo.busiSeq = busiSeq;
maxNo.lineDate = DateTime.Now;
maxNo.maxNo = 1;
maxNo.unitSeq = unitSeq;
maxNo.sysFlag = 0;
new TLineUpMaxNoDAL(this.db).Insert(maxNo);
}
else
{
if (maxNo.lineDate.Date != DateTime.Now.Date)
{
maxNo.maxNo = 1;
}
else
{
maxNo.maxNo = maxNo.maxNo + 1;
}
maxNo.lineDate = DateTime.Now;
maxNo.sysFlag = 1;
new TLineUpMaxNoDAL(this.db).Update(maxNo);
}
qModel = line;
});
}
catch
{
return(null);
}
return(qModel);
}
/// <summary>
/// 排队 ** 已弃用
/// </summary>
/// <param name="selectBusy"></param>
/// <param name="selectUnit"></param>
/// <param name="ticketStart"></param>
/// <param name="idCard"></param>
/// <param name="name"></param>
/// <param name="reserveSeq"></param>
/// <returns></returns>
public TQueueModel QueueLine(TBusinessModel selectBusy, TUnitModel selectUnit, string ticketStart, string idCard, string name, string reserveSeq)
{
try
{
this.db.Session.BeginTransaction();
var maxNo = new TLineUpMaxNoDAL(this.db).GetModelList().Where(l => l.unitSeq == selectUnit.unitSeq && l.busiSeq == selectBusy.busiSeq).FirstOrDefault();
//按照主键对该记录进行行锁确保数据一致性
maxNo = this.db.SqlQuery <TLineUpMaxNoModel>(
"select * from T_LineUpMaxNo a where a.id = @id FOR UPDATE;",
new DbParam[] { new DbParam("id", maxNo == null ? -1 : maxNo.id) }
).FirstOrDefault();
int ticketNo = maxNo == null ? 1 : maxNo.lineDate.Date != DateTime.Now.Date ? 1 : maxNo.maxNo + 1;
TQueueModel line = new TQueueModel();
line.busTypeName = selectBusy.busiName;
line.busTypeSeq = selectBusy.busiSeq;
line.qNumber = ticketNo.ToString();
line.state = 0;
line.ticketNumber = ticketStart + ticketNo.ToString("000");
line.ticketTime = DateTime.Now;
line.unitName = selectUnit.unitName;
line.unitSeq = selectUnit.unitSeq;
line.vipLever = "";
line.windowName = "";
line.windowNumber = "";
line.idCard = idCard;
line.qNmae = name;
line.reserveSeq = reserveSeq;
line = this.Insert(line);
if (maxNo == null)
{
maxNo = new TLineUpMaxNoModel();
maxNo.areaSeq = "";
maxNo.busiSeq = selectBusy.busiSeq;
maxNo.lineDate = DateTime.Now;
maxNo.maxNo = 1;
maxNo.unitSeq = selectUnit.unitSeq;
new TLineUpMaxNoDAL(this.db).Insert(maxNo);
}
else
{
if (maxNo.lineDate.Date != DateTime.Now.Date)
{
maxNo.maxNo = 1;
}
else
{
maxNo.maxNo = maxNo.maxNo + 1;
}
maxNo.lineDate = DateTime.Now;
new TLineUpMaxNoDAL(this.db).Update(maxNo);
}
this.db.Session.CommitTransaction();
return(line);
}
catch
{
this.db.Session.RollbackTransaction();
return(null);
}
finally
{
this.db.Dispose();
}
}
/// <summary>
/// 叫号 * 加入绿色通道插队
/// </summary>
/// <param name="wlBusy"></param>
/// <param name="gwlBusy"></param>
/// <param name="windowNumber"></param>
/// <param name="windowUser"></param>
/// <returns></returns>
public TCallModel CallNo(List <TWindowBusinessModel> wlBusy, List <TWindowBusinessModel> gwlBusy, string windowNumber, string windowUser)
{
TCallModel tcModel = null;
try
{
LockAction.Run(LockKey.Call, () =>
{
if (gwlBusy == null)
{
gwlBusy = new List <TWindowBusinessModel>();
}
var busyList = wlBusy.Select(w => w.busiSeq).ToList();
var unitList = wlBusy.Select(w => w.unitSeq).ToList();
var gbList = gwlBusy.Select(w => w.busiSeq).ToList();
var guList = gwlBusy.Select(w => w.unitSeq).ToList();
var date = DateTime.Now;
TQueueModel line = null;
var lineGreen = db.Query <TQueueModel>().Where(q => gbList.Contains(q.busTypeSeq) && guList.Contains(q.unitSeq) && q.state == 0 && q.ticketTime.Date == date.Date).OrderBy(o => o.id).FirstOrDefault();
if (lineGreen == null)
{
var lineFirst = db.Query <TQueueModel>().Where(q => busyList.Contains(q.busTypeSeq) && unitList.Contains(q.unitSeq) && q.state == 0 &&
q.ticketTime.Date == date.Date && (
(q.appType == 1 && q.type == 0 && q.reserveStartTime <= date && q.reserveEndTime >= date) || q.type == 1)).OrderBy(o => o.id).FirstOrDefault();
if (lineFirst == null)
{
var lineQueue = db.Query <TQueueModel>().Where(q => busyList.Contains(q.busTypeSeq) && unitList.Contains(q.unitSeq) && q.state == 0 && q.ticketTime.Date == date.Date).OrderBy(o => o.id).ToList();//取到当天 窗口业务排队队列
line = lineQueue.FirstOrDefault();
if (line == null)
{
return;
}
}
else
{
line = lineFirst;
}
}
else
{
line = lineGreen;
}
line.state = 1;
line.sysFlag = 1;
new TQueueDAL(this.db).Update(line);
var call = new TCallModel();
call.busiSeq = line.busTypeSeq;
call.handleId = DateTime.Now.ToString("yyyyMMddHHmmss");
call.handleTime = DateTime.Now;
call.idCard = line.idCard;
call.qId = line.id;
call.qNmae = line.qNmae;
call.reserveSeq = line.reserveSeq;
call.state = 0;
call.ticketNumber = line.ticketNumber;
call.ticketTime = line.ticketTime;
call.unitSeq = line.unitSeq;
call.windowNumber = windowNumber;
call.windowUser = windowUser;
call.sysFlag = 0;
var ret = this.Insert(call);
tcModel = ret;
});
}
catch
{
return(null);
}
return(tcModel);
}
public TQueueModel Insert(TQueueModel model)
{
return(this.dal.Insert(model));
}
private void BindData()
{
List <msInfo> mList = new List <msInfo>();
#region 正式数据
var vList = new List <TCallModel>();
try
{
vList = cBll.ScreenShowByArea(areaList).Take(rowCount).ToList();
ShowError = false;
}
catch (Exception ex)
{
WriterLog("获取大屏显示数据异常，方法[ScreenShowByArea]，错误原因：" + ex.Message);
ShowError = (isShowError == 0 ? false : true);
}
int i = 0;
Font vipFont = new Font(fontName, VIPFontSize, FontStyle.Bold);
Font msgFont = new Font(fontName, fontSize, FontStyle.Bold);
if (vList == null || vList.Count == 0)
{
this.pnMain.Controls.Clear();
this.pnMain.ResumeLayout();
return;
}
#region
foreach (var v in vList)
{
var bam = baList.Where(b => b.busiSeq == v.busiSeq && b.unitSeq == v.unitSeq).FirstOrDefault();
TQueueModel queue = null;
try
{
queue = qBll.GetModel(q => q.id == v.qId);
}
catch (Exception ex)
{
WriterLog("获取排队数据异常，方法[GetModel]，错误原因：" + ex.Message);
}
string strVip = "";
if (bam != null && bam.isGreenChannel == 1)
{
strVip = "绿色\r\n通道";
}
else
{
if ((queue != null && queue.type == 0 && queue.appType == 1 && queue.reserveStartTime <= v.handleTime && queue.reserveEndTime >= v.handleTime))
{
strVip = "网上\r\n预约";
}
else if (queue != null && queue.type == 1)
{
strVip = "网上\r\n申办";
}
}
msInfo ms = new msInfo();
ms.Index = (i + 1);
ms.RowHeight = rowHeight;
ms.TextFont = msgFont;
ms.WindowColor = window;
ms.TicketColor = ticket;
ms.VIPColor = vipColor;
ms.VIPFont = vipFont;
ms.VIPText = strVip;
ms.OtherColor = other;
ms.WindowNumber = v.windowNumber;
ms.QueueNumber = v.ticketNumber;
ms.msClick += ms_Click;
if (i % 2 != 0)
{
ms.BackColorPage = blue;
}
else
{
ms.BackColorPage = gray;
}
mList.Add(ms);
i++;
}
#endregion
#endregion
if (pnMain.Controls.Count == 0)
{
int t = 0;
foreach (var ms in mList)
{
ms.Location = new Point(0, t);
this.pnMain.Controls.Add(ms);
t += ms.Height;
}
pnMain.ResumeLayout();
}
else
{
var deleteControl = new List <Control>();
int jCount = pnMain.Controls.Count;
for (int j = 0; j < jCount; j++)
{
if ((j + 1) <= mList.Count)
{
var ctl = pnMain.Controls[j] as msInfo;
ctl.WindowNumber = mList[j].WindowNumber;
ctl.QueueNumber = mList[j].QueueNumber;
ctl.VIPText = mList[j].VIPText;
ctl.Refresh();
ctl.Invalidate();
}
else
{
deleteControl.Add(pnMain.Controls[j]);
}
}
foreach (var con in deleteControl)
{
pnMain.Controls.Remove(con);
}
pnMain.Refresh();
pnMain.Invalidate();
pnMain.ResumeLayout();
int tCount = pnMain.Controls.Count;
if (tCount < mList.Count)
{
int t = (pnMain.Controls[0] as msInfo).Height * pnMain.Controls.Count;
for (int m = 0; m < mList.Count - tCount; m++)
{
var ms = mList[m + tCount];
ms.Location = new Point(0, t);
this.pnMain.Controls.Add(ms);
t += ms.Height;
}
pnMain.Refresh();
pnMain.Invalidate();
pnMain.ResumeLayout();
}
}
}
