public int Update(ParamUpdate param) { var result = 0; Logger("更新记录", () => { db.UseTransaction(true); var rtnBefore = this.OnBeforeUpdate(new UpdateEventArgs() { db = db, data = param.GetData() }); if (!rtnBefore) { return; } result = BuilderParse(param).Execute(); Msg.Set(MsgType.Success, APP.MSG_UPDATE_SUCCESS); this.OnAfterUpdate(new UpdateEventArgs() { db = db, data = param.GetData(), executeValue = result }); db.Commit(); }); return(result); }
public dynamic GetUpdateIsCrux(int ID, int IsCrux) { return(new PRS_Process_BOMService() .Update(ParamUpdate.Instance() .Update("PRS_Process_BOM") .Column("IsCrux", IsCrux) .AndWhere("ID", ID))); }
public void PostChangeBlankingType(dynamic data) { string BlankingType = data.BlankingType; int ID = data.ID; new Mes_BlankingResultService().Update( ParamUpdate.Instance().Column("BlankingType", BlankingType) .AndWhere("ID", ID) ); }
public void PostUpdateSortID(List <MES_BN_ProductProcessRoute> model) { model.Where(m => m.ID != 0).ToList().ForEach(m => { new MES_BN_ProductProcessRouteService().Update(ParamUpdate.Instance() .Update("MES_BN_ProductProcessRoute") .Column("ProcessLineCode", m.ProcessLineCode) .AndWhere("ID", m.ID) ); }); }
public void PostWorkingTicketLower(dynamic data) { string WTList = data.WTList; new MES_WorkingTicketService() .Update(ParamUpdate.Instance() .Update("MES_WorkingTicket") .Column("ApproveState", 2) .Column("ApproveTime", DateTime.Now) .Column("ApprovePerson", MmsHelper.GetUserName()) .AndWhere("ID", WTList, Cp.In)); }
/// <summary> /// 修改自己的密码 /// </summary> /// <param name="newPassword">新密码,未加密</param> /// <returns>返回CommandResult</returns> public CommandResult ModifySelfPassword(string newPassword, int userid) { CommandResult commandResult = new CommandResult(); var paramUpdate = ParamUpdate.Instance().Update("Base_User") .Column("Password", Md5Util.MD5(newPassword)) .AndWhere("UserId", userid); int n = this.Update(paramUpdate); commandResult.ResultID = n > 0 ? 0 : -1; commandResult.ResultMsg = n > 0 ? "密码修改成功" : "密码修改失败"; LogHelper.Write("修改个人密码。用户:" + this.CurrentBaseLoginer.UserName + "。结果:" + commandResult.ResultMsg); return(commandResult); }
public void PostChangeWorkShopCode(dynamic data) { string PartCode = data.PartCode; string Blanking = data.Blanking; string Welding = data.Welding; string Machining = data.Machining; string Assembling = data.Assembling; string RootPartCode = data.RootPartCode; Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("1", Blanking); dic.Add("2", Welding); dic.Add("3", Machining); dic.Add("4", Assembling); var MES_BN_WorkShopMatchingList = new MES_BN_WorkShopMatchingService().GetModelList(ParamQuery.Instance().AndWhere("PartCode", PartCode).AndWhere("RootPartCode", RootPartCode).AndWhere("IsEnable", 1)); foreach (KeyValuePair <string, string> item in dic) { string DepartmentCode = item.Value; //if (!string.IsNullOrWhiteSpace(DepartmentCode)) //{ string ProcessType = item.Key; if (MES_BN_WorkShopMatchingList.Where(a => a.ProcessType == ProcessType).Count() > 0) { new MES_BN_WorkShopMatchingService().Update( ParamUpdate.Instance() .Update("MES_BN_WorkShopMatching") .Column("WorkShopCode", DepartmentCode) .AndWhere("PartCode", PartCode) .AndWhere("ProcessType", ProcessType) .AndWhere("RootPartCode", RootPartCode) .AndWhere("IsEnable", 1)); } else { new MES_BN_WorkShopMatchingService().Insert( ParamInsert.Instance() .Insert("MES_BN_WorkShopMatching") .Column("WorkShopCode", DepartmentCode) .Column("PartCode", PartCode) .Column("ProcessType", ProcessType) .Column("RootPartCode", RootPartCode) .Column("IsEnable", 1)); } //} //else //{ //} } }
//审核表单 public int Audit(string tableName, string billNo, string status, string comment) { db.UseTransaction(true); var userName = MmsHelper.GetUserName(); var pUpdate = ParamUpdate.Instance() .Update(tableName) .Column("ApproveState", status) .Column("ApproveRemark", comment) .Column("ApprovePerson", userName) .Column("ApproveDate", DateTime.Now) .Where("BillNo", billNo); var rowsAffected = BuilderParse(pUpdate).Execute(); if (rowsAffected <= 0) { db.Rollback(); return(rowsAffected); } switch (tableName) { case "mms_receive": case "mms_refund": rowsAffected = mms_warehouseStockService.UpdateWarehouseStock(db, tableName, billNo, status == "passed"); break; case "mms_send": case "mms_return": case "mms_transfer": case "mms_lossReport": rowsAffected = mms_warehouseStockService.UpdateWarehouseStock(db, tableName, billNo, status != "passed"); break; case "mms_rentOut": rowsAffected = mms_rentOutService.CalcRentOutMoney(db, billNo); break; } if (rowsAffected < 0) { db.Rollback(); return(rowsAffected); } db.Commit(); return(rowsAffected); }
public void Audit(dynamic data) { var pUpdate = ParamUpdate.Instance() .Update("MES_WorkshopPurchaseMain") .Column("ApproveState", data.form.status.ToString()) .Column("ApproveRemark", data.form.comment.ToString()) .Column("ApprovePerson", FormsAuth.GetUserData().UserName) .Column("ApproveDate", DateTime.Now) .AndWhere("ID", data.form.ID.ToString()); var service = new MES_WorkshopPurchaseMainService(); var rowsAffected = service.Update(pUpdate); MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}],请重试或联系管理员!"); }
public void Audit(string id, JObject data) { var pUpdate = ParamUpdate.Instance() .Update("trade_trailer") .Column("ApproveState", data["status"]) .Column("ApproveRemark", data["comment"]) .Column("ApprovePerson", FormsAuth.GetLoginer().UserName) .Column("ApproveDate", DateTime.Now) .Where("JOBNO", id); var service = new trade_trailerService(); var rowsAffected = service.Update(pUpdate); MvcHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}],请重试或联系管理员!", id); }
public void Audit(string id, JObject data) { var pUpdate = ParamUpdate.Instance() .Update("SYS_BOM") .Column("ApproveState", data["status"]) .Column("ApproveRemark", data["comment"]) .Column("ApprovePerson", FormsAuth.GetUserData().UserName) .Column("ApproveDate", DateTime.Now) .AndWhere("ID", id); var service = new SYS_BOMService(); var rowsAffected = service.Update(pUpdate); MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}],请重试或联系管理员!", id); }
public void Audit(string id, dynamic data) { var service = new psi_customerService(); var result = service.Update(ParamUpdate.Instance() .Column("AuditState", data.status) .Column("AuditReason", data.comment) .Column("AuditPerson", FormsAuth.GetUserData().UserName) .Column("AuditDate", DateTime.Now) .AndWhere("Id", id)); if (result <= 0) { throw new HttpResponseException(new HttpResponseMessage() { Content = new StringContent("审核收货单失败{Id=" + id + "},请重试或联系管理员!") }); } }
/// <summary> /// 重置某个用户的密码,新密码默认是:123456 /// </summary> /// <param name="userId">用户编号</param> /// <returns>返回CommandResult</returns> public CommandResult ResetUserPassword(int userId, string userName, string userCode) { CommandResult cmdResult = CommandResult.Instance_Succeed; cmdResult.ResultMsg = "密码重置成功"; string newPwd = Md5Util.MD5("123456"); var par = ParamUpdate.Instance().Update("Base_User") .Column("Password", newPwd) .Column("LastChangePassword", DateTime.Now) .AndWhere("UserId", userId); var result = Base_UserService.Instance.Update(par); if (result == 0) { cmdResult.Set(false, "密码重置失败"); } string logmsg = string.Format("用户密码重置。结果:{3}。用户:{0}-({1}),登录账号:{2}", userName, userId, userCode, cmdResult.ResultMsg); LogHelper.Write(logmsg); return(cmdResult); }
/// <summary> /// 审核用户 /// </summary> /// <param name="userId">用户编号</param> /// <param name="op">审核人</param> /// <returns>返回CommandResult</returns> public CommandResult AuditUser(int userId, string op) { CommandResult cmdResult = CommandResult.Instance_Succeed; cmdResult.ResultMsg = "审核成功"; var par = ParamUpdate.Instance().Update("Base_User") .Column("IsAudit", 1) .Column("AuditBy", op) .Column("AuditTime", DateTime.Now) .AndWhere("UserId", userId); var result = Base_UserService.Instance.Update(par); if (result == 0) { cmdResult.Set(false, "审核失败"); } string logmsg = string.Format("用户审核成功。结果:{0}。用户编号:{1}", cmdResult.ResultMsg, userId); LogHelper.Write(logmsg); return(cmdResult); }
public void PostSetMateType(dynamic data) { int ProcessBomID = data.ProcessBomID; string MateType = data.MateType; if (string.IsNullOrWhiteSpace(MateType)) { new PRS_Process_BOMService().Update( ParamUpdate.Instance() .Update("PRS_Process_BOM") .Column("MateType", DBNull.Value) .AndWhere("ID", ProcessBomID)); } else { new PRS_Process_BOMService().Update( ParamUpdate.Instance() .Update("PRS_Process_BOM") .Column("MateType", MateType) .AndWhere("ID", ProcessBomID)); } }
//审核表单 public int Audit(string tableName, string Jobno, string status, string comment) { db.UseTransaction(true); var userName = TradeHelper.GetUserName(); var pUpdate = ParamUpdate.Instance() .Update(tableName) .Column("ApproveState", status) .Column("ApproveRemark", comment) .Column("ApprovePerson", userName) .Column("ApproveDate", DateTime.Now) .Where("Jobno", Jobno); var rowsAffected = BuilderParse(pUpdate).Execute(); if (rowsAffected <= 0) { db.Rollback(); return(rowsAffected); } switch (tableName) { case "trade_trailer": break; } if (rowsAffected < 0) { db.Rollback(); return(rowsAffected); } db.Commit(); return(rowsAffected); }
//新增审核 public int Audit(string tableName, EditEventArgs data) { db.UseTransaction(true); var userName = MmsHelper.GetUserName(); var pUpdate = ParamUpdate.Instance() .Update(tableName) .Column("ApproveState", data.form["status"].ToString()) .Column("ApproveRemark", data.form["comment"].ToString()) .Column("ApprovePerson", userName) .Column("ApproveDate", DateTime.Now) .AndWhere("[Object_ID]", data.form["Object_ID"].ToString()); var rowsAffected = BuilderParse(pUpdate).Execute(); if (rowsAffected <= 0) { db.Rollback(); return(rowsAffected); } switch (tableName) //财务过账 { default: break; } if (rowsAffected < 0) { db.Rollback(); return(rowsAffected); } db.Commit(); return(rowsAffected); }
//审核表单 public int Audit(string tableName, string Object_ID, string status, string comment) { db.UseTransaction(true); var userName = MmsHelper.GetUserName(); var pUpdate = ParamUpdate.Instance() .Update(tableName) .Column("ApproveState", status) .Column("ApproveRemark", comment) .Column("ApprovePerson", userName) .Column("ApproveDate", DateTime.Now) .AndWhere("Object_ID", Object_ID); var rowsAffected = BuilderParse(pUpdate).Execute(); if (rowsAffected <= 0) { db.Rollback(); return(rowsAffected); } switch (tableName) //财务过账 { default: break; } if (rowsAffected < 0) { db.Rollback(); return(rowsAffected); } db.Commit(); return(rowsAffected); }
public int GetDelete(string id) { return(new MES_WorkshopBatchingService().Update(ParamUpdate.Instance().Column("IsEnable", 0).AndWhere("BatchingCode", id))); }
public bool PostCreateWorkShopMatchingData(List <PRS_Process_BOM> data, string ParentCode, string OperationType) { try { db.UseTransaction(true); if (OperationType == "add") { data.ForEach(item => { MES_BN_WorkShopMatching model = new MES_BN_WorkShopMatching(); model.PartCode = item.PartCode; model.RootPartCode = ParentCode; model.ProcessType = "1"; model.WorkShopCode = ""; model.CreateTime = DateTime.Now; model.CreatePerson = MmsHelper.GetUserCode(); model.ParentCode = item.ParentCode; model.ContractCode = item.ContractCode; model.IsEnable = 1; int result = db.Insert <MES_BN_WorkShopMatching>("MES_BN_WorkShopMatching", model).AutoMap(a => a.ID).ExecuteReturnLastId <int>(); }); } else if (OperationType == "update") { var UpdateList = new List <int>(); new MES_BN_WorkShopMatchingService().Update(ParamUpdate.Instance() .Update("MES_BN_WorkShopMatching") .Column("IsEnable", 0) .AndWhere("RootPartCode", ParentCode)); var MES_BN_WorkShopMatchingList = new MES_BN_WorkShopMatchingService().GetModelList(ParamQuery.Instance().AndWhere("RootPartCode", ParentCode)); data.ForEach(item => { var PCode = item.ParentCode; //父级编码 var PartCode = item.PartCode; //子级编码 var IsExist = MES_BN_WorkShopMatchingList.Where(a => a.ParentCode == PCode && a.PartCode == PartCode); if (IsExist.Count() > 0) { int ID = IsExist.FirstOrDefault().ID; UpdateList.Add(ID); } else { MES_BN_WorkShopMatching model = new MES_BN_WorkShopMatching(); model.PartCode = item.PartCode; model.RootPartCode = ParentCode; model.ProcessType = "1"; model.WorkShopCode = ""; model.CreateTime = DateTime.Now; model.CreatePerson = MmsHelper.GetUserCode(); model.ParentCode = item.ParentCode; model.ContractCode = item.ContractCode; model.IsEnable = 1; int result = db.Insert <MES_BN_WorkShopMatching>("MES_BN_WorkShopMatching", model) .AutoMap(a => a.ID).ExecuteReturnLastId <int>(); } }); if (UpdateList.Count > 0) { string UpdateStr = string.Join(",", UpdateList); db.Sql($"update MES_BN_WorkShopMatching set IsEnable=1 where ID in({UpdateStr})").Execute(); } } db.Commit(); return(true); } catch (Exception ex) { db.Rollback(); return(false); } }
public dynamic GetSyn(RequestWrapper query) { var TenantId = SysHelper.GetTenantId(); List <dynamic> dsInventory = new List <dynamic>(); List <dynamic> result = new List <dynamic>(); try { var pageID = 1; var pageRows = 4000; var dsInventoryPagging = ApiDataSource.GetInventoryList(TenantId, null, null, null, "" + pageID, "" + pageRows); while (dsInventoryPagging != null && dsInventoryPagging.Count > 0) { dsInventory.AddRange(dsInventoryPagging); pageID++; dsInventoryPagging = ApiDataSource.GetInventoryList(TenantId, null, null, null, "" + pageID, "" + pageRows); } ParamQuery paramQuery = ParamQuery.Instance() .AndWhere("TenantId", TenantId); List <minimes_product> list = new minimes_productService().GetModelList(paramQuery); foreach (var row in dsInventory) { //state 2新增 1修改 0不变 dynamic dy = new { InventoryId = row.InventoryId, InventoryCode = row.InventoryCode, InventoryName = row.InventoryName, InventoryClassId = row.InventoryClassId, StandardUPH = row.StandardUPH, StandardPersonNum = row.StandardPersonNum, StandardProcessNum = row.StandardProcessNum, StandardTime = row.StandardTime, Spec = row.Spec, Unit = row.Unit, IsEnable = row.IsEnable, State = 2 }; foreach (var item in list) { string InventoryCode = dy.InventoryCode + ""; string InventoryName = dy.InventoryName + ""; if (item.InventoryCode + "" == InventoryCode) { if (item.InventoryName + "" == InventoryName) { dy.State = 0; } else { dy.State = 1; } break; } } result.Add(dy); } foreach (var row in result) { string InventoryCode = row.InventoryCode + ""; string InventoryName = row.InventoryName + ""; string InventoryClassId = row.InventoryClassId + ""; if (row.State == 2) { new minimes_productService().Insert(ParamInsert.Instance() .Column("InventoryId", Guid.NewGuid()) .Column("InventoryCode", InventoryCode) .Column("InventoryName", InventoryName) .Column("InventoryClassId", InventoryClassId) //.Column("StandardUPH", row.StandardUPH) //.Column("StandardPersonNum", row.StandardPersonNum) // .Column("StandardProcessNum", row.StandardProcessNum) // .Column("StandardTime", row.StandardTime) .Column("Spec", row.Spec) .Column("Unit", row.Unit) .Column("IsEnable", row.IsEnable) .Column("TenantId", TenantId) .Column("TallyRatio", 1) ); } else if (row.State == 1) { var param = ParamUpdate.Instance() .Column("InventoryName", InventoryName) .AndWhere("InventoryCode", InventoryCode); new minimes_productService().Update(param); } } } catch (Exception ex) { return(-1); } return(1); }