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