public virtual string Add(MasterData data)
{
var newMasterData = new TESTENTITY()
{
Id = "123",
STRING = data.city,
ISACTIVE = SafeConvert.ToInt64(data.isActive),
COMMENT = data.comment,
TESTENTITY2ID = data.combobox,
REGISTERTIME = data.registerTime,
};
var Id = testRepository.Insert(newMasterData).Id;
// testRepository.InsertOrUpdate(newMasterData);
return(Id);
// testRepository.Update(t => t.Id == "57627fde-0332-4db0-9036-ce3ec5e48496", t =>
// new TESTENTITY()
// {
//
// COMMENT = DateTime.Now.ToString("HH:mm:ss")
// }
// );
//throw new Exception();
//test2Repository.Update(t => t.Id == "123",t => new TESTENTITY2() {
// Text = DateTime.Now.ToString("HH:mm:ss tt zz")
//});
return(null);
}
/// <summary>
/// 修改角色
/// </summary>
/// <param name="dto">传入角色信息</param>
public void ModifyRole(RoleDto dto)
{
Role entity = _roleRepository.Get(SafeConvert.ToInt64(dto.Id));
entity.Name = dto.Name;
_roleRepository.Update(entity);
}
/// <summary>
/// 修改权限
/// </summary>
/// <param name="dto">传入权限信息</param>
public void ModifyPermission(PermissionManage.PermissionDto dto)
{
Permission entity = _permissionRepository.Get(SafeConvert.ToInt64(dto.ParentId));
entity.MenuId = dto.MenuId;
_permissionRepository.Update(entity);
}
/// <summary>
/// 修改菜单
/// </summary>
/// <param name="dto">传入菜单信息</param>
public void ModifyMenu(MenuDto dto)
{
Menu entity = _menuRepository.Get(SafeConvert.ToInt64(dto.Id));
entity.Name = dto.Name;
entity.Url = dto.Url;
entity.Icon = dto.Icon;
_menuRepository.Update(entity);
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="dto">传入用户信息</param>
public void ModifyUser(UserManage.UserDto dto)
{
User entity = _userRepository.Get(SafeConvert.ToInt64(dto.Id));
entity.Email = dto.Email;
entity.RealName = dto.RealName;
entity.Phone = dto.Phone;
entity.RoleId = dto.RoleId;
_userRepository.Update(entity);
}
/// <summary>
/// 分配权限
/// </summary>
/// <param name="roleId"></param>
/// <param name="permissionIds"></param>
public void DistributePermission(long?roleId, long?[] permissionIds)
{
Role entity = _roleRepository.Get(SafeConvert.ToInt64(roleId));
var permissions = _permissionRepository.Table.Where(t => permissionIds.Contains(t.Id));
entity.Permissions.Clear();
entity.Permissions = permissions.ToList();
_roleRepository.Update(entity);
//WriteOperateLog(LogType.信息, LogModule.权限管理, "角色[{0}]分配权限成功！", entity.RoleName);
}
/// <summary>
/// 删除角色
/// </summary>
/// <param name="dto">传入角色信息</param>
public void DeleteRole(RoleDto dto)
{
Role entity = _roleRepository.Get(SafeConvert.ToInt64(dto.Id));
_roleRepository.Delete(entity);
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="dto">传入用户信息</param>
public void DeleteUser(UserManage.UserDto dto)
{
User entity = _userRepository.Get(SafeConvert.ToInt64(dto.Id));
_userRepository.Delete(entity);
}
public string createIPQC(RepairOrderRequest param)
{
DateTime now = SSGlobalConfig.Now;
IList <CV_QM_REPAIR_ORDER> orderList = param.orderList;
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("PN", "IPQC");
dict.Add("Y", now.ToString("yyyyMMdd"));
string message = "";
//创建IPQC表单
using (TransactionScope ts = new TransactionScope())
{
string ipqcSequence = createCode("IPQCRule", dict);
QM_REPAIR_IPQC ipqc = new QM_REPAIR_IPQC()
{
TGuid = Guid.NewGuid(),
Sequence = ipqcSequence,
OrderID = orderList[0].OrderID,
ReportLine = orderList[0].ReportLine,
ReportWorkshop = orderList[0].ReportWorkshop,
DefID = orderList[0].DefID,
DefName = orderList[0].DefDescript,
Status = "新建",
CreatedBy = param.user,
CreatedOn = now
};
ipqcbo.Insert(ipqc);
foreach (CV_QM_REPAIR_ORDER tmp in orderList)
{
QM_REPAIR_IPQC_DETAIL detail = new QM_REPAIR_IPQC_DETAIL()
{
TGuid = ipqc.TGuid,
SN = tmp.AbnormalitySN,
ReportID = tmp.ReportID,
Result = tmp.Result,
ReportTerminal = tmp.ReportTerminal,
ProductDecision = tmp.ProductDecision,
QualityDecision = tmp.QualityDecision
};
ipqc_detailbo.Insert(detail);
//修改SN状态为IPQC(7)
string cmd_ipqcSql1 = string.Format(CultureInfo.InvariantCulture, ipqcSql1, 7, tmp.AbnormalitySN);
alt_bscbo.ExecuteNonQueryBySql(cmd_ipqcSql1);
}
//创建预警信息
string cmd_altsql = string.Format(CultureInfo.InvariantCulture, ipqcAltSql, ipqc.DefID + ipqc.DefName, ipqc.OrderID, orderList[0].LineName, ipqcSequence);
log.Info("createIPQC Sql : " + cmd_altsql);
DataTable dt = alt_bscbo.GetDataTableBySql(cmd_altsql);
if (dt.Rows.Count > 0)
{
//开始推送
PM_ALT_MESSAGE msg = alt_messagebo.GetEntity(SafeConvert.ToInt64(dt.Rows[0]["MsgPK"].ToString()));
if (alt_bscbo.ExecuteNotify(msg))
{
message = ipqcSequence;
ts.Complete();
}
else
{
message = "NG,推送失败,请重新提交..";
}
}
}
return(message);
}
/// <summary>
/// 删除权限
/// </summary>
/// <param name="dto">传入权限信息</param>
public void DeletePermission(PermissionManage.PermissionDto dto)
{
Permission permission = _permissionRepository.Get(SafeConvert.ToInt64(dto.Id));
_permissionRepository.Delete(permission);
}
/// <summary>
/// 添加权限
/// </summary>
/// <param name="dto">传入权限信息</param>
public void AddPermission(PermissionManage.PermissionDto dto)
{
Permission parent = _permissionRepository.Get(SafeConvert.ToInt64(dto.ParentId));
//entity.Permission.Parent = parent;
//_permissionExRepository.Add(entity);
}
/// <summary>
/// 删除菜单
/// </summary>
/// <param name="dto">传入菜单信息</param>
public void DeleteMenu(MenuDto dto)
{
Menu entity = _menuRepository.Get(SafeConvert.ToInt64(dto.Id));
_menuRepository.Delete(entity);
}
public string addFirstCheck(AddFirstCheckRequest param)
{
string message = "";
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("PN", "SJ" + param.snOrderList[0].OrderID);
DateTime now = SSGlobalConfig.Now;
CV_QM_FIRSTCHECK_SN snOrder = param.snOrderList[0];
//先获得首检检验项
string SubBopID = null;
if (snOrder.Step == "装配" || snOrder.Step == "检定" || snOrder.Step == "包装")
{ //查询step是否为包装或者装配，若是，则查询需加上subbopid
SubBopID = snOrder.Step;
}
IList <CV_QM_PROCESSITEM> processItemList = _ICV_QM_PROCESSITEMBO.GetEntitiesByOrderID(snOrder.OrderID, "1", SubBopID);//首检InspectSource = 1
if (processItemList.Count() == 0)
{
message = "NG,无首检检验项信息";
}
else
{
QM_PROCESS_TOP top = new QM_PROCESS_TOP()
{
Source = 1,
SequenceStatus = "待检",
SapOrderID = snOrder.SalesOrderID, //SAP订单
WorkOrderID = snOrder.OrderID, //MES工单
MinSampleSize = param.minSampleSize, //最小抽样数量
SampleQua = param.snOrderList.Count, //抽样数量
MaterielID = snOrder.DefID, //物料编码
MaterielVer = snOrder.DefVer, //物料版本
MaterielDescript = snOrder.DefDescript, //物料描述
PlantID = snOrder.PlanPlant, //工厂ID
Plant = snOrder.PlantName, //工厂名称
Step = snOrder.Step, //工序
Workshop = snOrder.DepartID, //车间
LineID = snOrder.LineID, //产线ID
ProdLine = snOrder.LineName, //产线名称
CreateBy = param.user, //创建者
CreateTime = now //创建时间
};
using (TransactionScope ts = new TransactionScope())
{
top.Sequence = createCode("FirstInspectRule", dict);//首检单号
//创建首检单
_IQM_PROCESS_TOPBO.Insert(top);
//获得刚创建的首检单
QM_PROCESS_TOP_QueryParam topParam = new QM_PROCESS_TOP_QueryParam()
{
Source = 1,
Sequence = top.Sequence
};
//查询KID
top = _IQM_PROCESS_TOPBO.GetEntitiesByQueryParam(topParam)[0];
foreach (CV_QM_FIRSTCHECK_SN tmp in param.snOrderList)
{
QM_PROCESS_MIDDLE middle = new QM_PROCESS_MIDDLE()
{
KID = top.KID,
Sequence = top.Sequence,
SN = tmp.LotID,
SNStatus = "待检"
};
_IQM_PROCESS_MIDDLEBO.Insert(middle);
}
//查询KLID
IList <QM_PROCESS_MIDDLE> middleList = _IQM_PROCESS_MIDDLEBO.GetByKid(top.KID.Value);
//操作底表
foreach (QM_PROCESS_MIDDLE middleTmp in middleList)
{
foreach (CV_QM_PROCESSITEM item in processItemList)
{
QM_PROCESS_BOTTOM bottom = new QM_PROCESS_BOTTOM()
{
KLID = middleTmp.KLID,
Sequence = middleTmp.Sequence,
SN = middleTmp.SN,
MaterielID = top.MaterielID,
ItemIndex = item.InforDetailID,
Item = item.InspectItemDes,
ItemStatus = "待检",
ItemProperty = item.InspectItemProperty.Equals("2") ? "定量" : "定性",
};
if (!string.IsNullOrEmpty(item.TargetValue))
{
bottom.Target = SafeConvert.ToDouble(item.TargetValue);
}
if (!string.IsNullOrEmpty(item.UpperLimit))
{
bottom.UpperBound = SafeConvert.ToDouble(item.UpperLimit);
}
if (!string.IsNullOrEmpty(item.LowerLimit))
{
bottom.LowerBound = SafeConvert.ToDouble(item.LowerLimit);
}
_IQM_PROCESS_BOTTOMBO.Insert(bottom);
}
}
//创建预警信息
string cmd_altsql = string.Format(CultureInfo.InvariantCulture, firstAltSql, top.ProdLine, top.WorkOrderID, top.Sequence);
DataTable dt = bscbo.GetDataTableBySql(cmd_altsql);
if (dt.Rows.Count > 0)
{
//开始推送
PM_ALT_MESSAGE msg = alt_messagebo.GetEntity(SafeConvert.ToInt64(dt.Rows[0]["MsgPK"].ToString()));
if (alt_bscbo.ExecuteNotify(msg))
{
message = top.Sequence;
ts.Complete();
}
else
{
message = "NG,推送失败,请重新提交..";
}
}
}
}
return(message);
}
