/// <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"); } }