/// <summary>
/// BOM插入
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool InsertBom(BomModel model, out string ID)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
ID = "0";
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(model.BomNo, 0);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
succ = BomDBHelper.InsertBom(model, loginUserID, out ID);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, 0, ex);
return(false);
}
}
/// <summary>
/// 判断该结点下，是否还有子结点
/// </summary>
/// <param name="ParentCode">上级编码</param>
/// <returns>大于0还有子节点，否则无子节点</returns>
public static int ChildrenCount(BomModel model)
{
try
{
return(BomDBHelper.ChildrenCount(model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 加载BOM树
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static DataTable GetBomTree(BomModel model)
{
try
{
return(BomDBHelper.GetBomTree(model));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 设置是否合法
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int CountInvalid(BomModel model)
{
try
{
return(BomDBHelper.CountInvalid(model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 判断要删除的ID是否已经被引用
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="ID"></param>
/// <param name="TableName"></param>
/// <returns></returns>
public static int CountRefrence(string CompanyCD, string ID, string TableName, string ColumnName)
{
try
{
return(BomDBHelper.CountRefrence(CompanyCD, ID, TableName, ColumnName));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// BOM控件查询Bom信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static DataTable GetBomControlList(BomModel model, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
try
{
return(BomDBHelper.GetBomControlList(model, pageIndex, pageCount, OrderBy, ref totalCount));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 父件唯一性验证
/// </summary>
/// <param name="ParentCode">上级编码</param>
/// <returns>大于0：已经有父件引用该物品了，否则无父件引用该物品</returns>
public static int ProductCount(BomModel model)
{
try
{
return(BomDBHelper.ProductCount(model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除BOM
/// </summary>
/// <param name="ID"></param>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static bool DeleteBom(string ID, string CompanyCD)
{
if (string.IsNullOrEmpty(ID))
{
return(false);
}
if (string.IsNullOrEmpty(CompanyCD))
{
CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
}
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
bool isSucc = BomDBHelper.DeleteBom(ID, CompanyCD);
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//获取删除的编号列表
string[] noList = ID.Split(',');
//遍历所有编号，登陆操作日志
for (int i = 0; i < noList.Length; i++)
{
//获取编号
string no = noList[i];
//替换两边的 '
no = no.Replace("'", string.Empty);
//操作日志
LogInfoModel logModel = InitLogInfo("物料清单ID：" + no, 1);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
}
return(isSucc);
}
