void pbu_click(object sender)
{
ucBusyCard pb = sender as ucBusyCard;
TBusinessModel busy = pb.Tag as TBusinessModel;
selectBusy = busy;
if (SelectedBusy != null)
{
SelectedBusy();
}
}
void pbu_Click(object sender, EventArgs e)
{
BusyCard pb = sender as BusyCard;
TBusinessModel busy = pb.Tag as TBusinessModel;
selectBusy = busy;
if (SelectedBusy != null)
{
SelectedBusy();
}
}
public ActionResult SubmitForm(TBusinessModel model)
{
if (model.ID == -1)
{
this.bll.Insert(model);
}
else
{
this.bll.Update(model);
}
return(Content("操作成功！"));
}
private void button1_Click(object sender, EventArgs e)
{
selectUnit = new TUnitModel()
{
unitSeq = "2931",
unitName = "江城区社保局"
};
selectBusy = new TBusinessModel()
{
busiSeq = "3610",
busiName = "社保制卡"
};
InsertQueue("AA");
}
public ActionResult Form(int id)
{
var model = this.bll.GetModel(id);
if (model == null)
{
model = new TBusinessModel()
{
ID = -1
}
}
;
var unitModel = this.unitBll.GetModel(p => p.unitSeq == model.unitSeq);
model.unitName = unitModel == null ? "" : unitModel.unitName;
this.ViewBag.busiType = dicBll.GetModelListByName(FDictionaryString.AppointmentType);
this.ViewBag.unitList = JsonConvert.SerializeObject(unitBll.GetModelList());
return(View(model));
}
public override void Draw(Graphics g)
{
g.DrawImage(Image, Rectangle, 0, 0, Image.Width, Image.Height, GraphicsUnit.Pixel);
TBusinessModel busy = this.Tag as TBusinessModel;
Font font = new Font("黑体", 18, FontStyle.Bold);
if (Brush == null)
{
Brush = new SolidBrush(Color.Black);
}
string busiName = busy.busiName;
if (busy.busiName.Trim().Length > 21)
{
busiName = busiName.Substring(0, 21);
}
int rowLength = 7;
int cX = 10;
if (busiName.Length <= rowLength)
{
g.DrawString(busiName, font, Brush, this.Rectangle.X + cX, this.Rectangle.Y + 40);//只有一行字，那就居中
}
else
{
var firstLine = busiName.Substring(0, rowLength);
var remain = busiName.Substring(rowLength, busiName.Length - rowLength);
if (remain.Length <= rowLength)
{
g.DrawString(firstLine, font, Brush, this.Rectangle.X + cX, this.Rectangle.Y + 25);
g.DrawString(remain, font, Brush, this.Rectangle.X + cX, this.Rectangle.Y + 55);
}
else
{
g.DrawString(firstLine, font, Brush, this.Rectangle.X + cX, this.Rectangle.Y + 10);
var secondLine = remain.Substring(0, rowLength);
g.DrawString(secondLine, font, Brush, this.Rectangle.X + cX, this.Rectangle.Y + 40);
var last = remain.Substring(rowLength, remain.Length - rowLength);
g.DrawString(last, font, Brush, this.Rectangle.X + cX, this.Rectangle.Y + 70);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
selectUnit = new TUnitModel()
{
unitSeq = "2931",
unitName = "江城区社保局"
};
selectBusy = new TBusinessModel()
{
busiSeq = "3610",
busiName = "社保制卡"
};
TAppointmentModel app = new TAppointmentModel()
{
approveSeq = "111111",
appType = 0,
reserveSeq = "22222",
reserveDate = DateTime.Now,
reserveStartTime = DateTime.Now,
reserveEndTime = DateTime.Now,
};
InsertQueue(app, "AA");
}
public BQueueModel QueueLine(TBusinessModel selectBusy, TUnitModel selectUnit, string ticketStart, string idCard, string name)
{
return(new BQueueDAL().QueueLine(selectBusy, selectUnit, ticketStart, idCard, name));
}
/// <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="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(TBusinessModel selectBusy, TUnitModel selectUnit, string ticketStart, string idCard, string name, TAppointmentModel app, string isGetCard, string serialNo)
{
TQueueModel qModel = null;
try
{
LockAction.Run(LockKey.Queue, () =>
{
var maxNo = new TLineUpMaxNoDAL(this.db).GetModelList().Where(l => l.unitSeq == selectUnit.unitSeq && l.busiSeq == selectBusy.busiSeq).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.qType = 0;
line.sysFlag = 0;
if (isGetCard == "1")
{
line.reserveSeq = serialNo;
line.type = 2;
}
else
{
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 = selectBusy.busiSeq;
maxNo.lineDate = DateTime.Now;
maxNo.maxNo = 1;
maxNo.unitSeq = selectUnit.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);
}
public int Update(TBusinessModel model)
{
return(this.db.Update(model));
}
public int Delete(TBusinessModel model)
{
return(this.db.Delete(model));
}
public TBusinessModel Insert(TBusinessModel model)
{
return(db.Insert(model));
}
public TQueueModel QueueLine(TBusinessModel selectBusy, TUnitModel selectUnit, string ticketStart, string idCard, string name, TAppointmentModel app)
{
return(new TQueueDAL().QueueLine(selectBusy, selectUnit, ticketStart, idCard, name, app));
}
/// <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 BQueueModel QueueLine(TBusinessModel selectBusy, TUnitModel selectUnit, string ticketStart, string idCard, string name)
{
BQueueModel qModel = null;
try
{
lock (obj)
{
db.Session.BeginTransaction();
var dal = new BLineUpMaxNoDAL(this.db, this.areaNo);
var maxNo = dal.GetModelList().Where(a => a.AreaNo == this.areaNo).Where(l => l.unitSeq == selectUnit.unitSeq && l.busiSeq == selectBusy.busiSeq).FirstOrDefault();
int ticketNo = maxNo == null ? 1 : maxNo.lineDate.Date != DateTime.Now.Date ? 1 : maxNo.maxNo + 1;
BQueueModel line = new BQueueModel();
line.ID = this.GetMaxId();
line.AreaNo = this.areaNo;
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.qType = 0;
line = this.Insert(line);
if (maxNo == null)
{
maxNo = new BLineUpMaxNoModel();
maxNo.ID = dal.GetMaxId();
maxNo.AreaNo = this.areaNo;
maxNo.areaSeq = "";
maxNo.busiSeq = selectBusy.busiSeq;
maxNo.lineDate = DateTime.Now;
maxNo.maxNo = 1;
maxNo.unitSeq = selectUnit.unitSeq;
dal.Insert(maxNo);
}
else
{
if (maxNo.lineDate.Date != DateTime.Now.Date)
{
maxNo.maxNo = 1;
}
else
{
maxNo.maxNo = maxNo.maxNo + 1;
}
maxNo.lineDate = DateTime.Now;
dal.Update(maxNo);
}
qModel = line;
db.Session.CommitTransaction();
}
}
catch
{
db.Session.RollbackTransaction();
return(null);
}
finally
{
db.Session.Dispose();
}
return(qModel);
}
public TQueueModel QueueLine(TBusinessModel selectBusy, TUnitModel selectUnit, string ticketStart, string idCard, string name, string reserveSeq)
{
return(new TQueueDAL().QueueLine(selectBusy, selectUnit, ticketStart, idCard, name, reserveSeq));
}
public TBusinessModel Insert(TBusinessModel model)
{
return(this.dal.Insert(model));
}
