/// <summary>
/// 记录打印成功
/// </summary>
/// <param name="id"></param>
/// <param name="printModel"></param>
/// <param name="sbatches"></param>
public bool PrintSuccess(int id, PrintModelEnum printModel, string sbatches, string czrUserAccount, string czrUserName, string shrUserAccount, string shrUserName)
{
using (var db = new PrintTagDbEntities())
{
var orderIdParam = new SqlParameter("@orderId", id);
var statusParam = new SqlParameter("@status", PrintStatusEnum.Success);
var modelParam = new SqlParameter("@model", printModel);
var datetimeParam = new SqlParameter("@datetime", DateTime.Now);
var printerUserIdParam = new SqlParameter("@printerUserId", czrUserAccount);
var printerUserNameParam = new SqlParameter("@printerUserName", czrUserName);
var checkUserIdParam = new SqlParameter("@checkUserId", shrUserAccount);
var checkerUserNameParam = new SqlParameter("@checkerUserName", shrUserName);
var execCount = db.Database.ExecuteSqlCommand(@"update tOrder set
printing_status = @status,
printing_model = @model,
printing_time = @datetime,
sbatches = '',
PrintUserId = @printerUserId,
PrintUserName = @printerUserName,
CheckUserId = @checkUserId,
CheckUserName = @checkerUserName
where id=@orderId
", statusParam
, modelParam, datetimeParam, printerUserIdParam, printerUserNameParam, checkUserIdParam, checkerUserNameParam, orderIdParam);
return(execCount > 0);
//var item = db.tOrders.FirstOrDefault(s => s.Id == id);
//item.printing_status = PrintStatusEnum.Success;
//item.printing_model = printModel;
//item.printing_time = DateTime.Now;
//item.sbatches = "";
//item.PrintUserId = czrUserId;
//item.PrintUserName = czrUserName;
//item.CheckUserId = shrUserId;
//item.CheckUserName = shrUserName;
//DBContext.SaveChanges();
}
}
/// <summary>
/// 提交贴签状态
/// </summary>
public void SubmitPrinter()
{
using (var db = new PrintTagDbEntities())
{
var orders = db.Database.SqlQuery <tOrder>("select * from torder where (hasSubmit is null or hasSubmit <>1) and printing_status=1 ").ToList();
SqlParameter id = null;
SqlParameter barcode = null;
SqlParameter printer = null;
foreach (var order in orders)
{
id = new SqlParameter("@id", order.Id);
barcode = new SqlParameter("@barcode", order.barcode);
printer = new SqlParameter("@printer", order.PrintUserId);
PivasDbHelperSQL.ExecuteSql("exec p_for_ydwl_update 1,@barcode,@printer", barcode, printer);
}
db.Database.ExecuteSqlCommand("update torder set hasSubmit=1 where (hasSubmit is null or hasSubmit <>1) and printing_status=1");
}
}
