public ActionResult RightConfig()
{
Mes_Sys_RoleMap obj = new Mes_Sys_RoleMap();
obj.Sys_Role_ID = TConvertHelper.FormatDBInt(Request.Params["RoleID"]);
return(View(obj));
}
public ActionResult ProductInStockItemMgt()
{
PageModel page = new PageModel();
page.OptType = TConvertHelper.FormatDBInt(Request.Params["OptType"]);
page.KeyID = Request.Params["ID"];
return(View(page));
}
public List <Mes_Stock_InStock> FindByPage(Mes_Stock_InStock obj, ref PagerBase pager)
{
string sql = @"SELECT T1.* FROM Mes_Stock_InStock T1 WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.BillType) > 0)
{
sql += string.Format(" AND T1.BillType = '{0}'", obj.BillType);
}
if (!string.IsNullOrEmpty(obj.BillNo))
{
sql += string.Format(" AND T1.BillNo Like '%{0}%'", obj.BillNo);
}
if (!string.IsNullOrEmpty(obj.InStockDateStart))
{
sql += string.Format(" AND T1.InStockDate >='{0}'", obj.InStockDateStart);
}
if (!string.IsNullOrEmpty(obj.InStockDateEnd))
{
sql += string.Format(" AND T1.InStockDate <'{0}'", TConvertHelper.FormatDBDate(obj.InStockDateEnd).AddDays(1));
}
if (obj.AuditStatus > 0)
{
sql += string.Format(" AND T1.AuditStatus = {0}", obj.AuditStatus);
}
if (obj.CheckStatus > 0)
{
sql += string.Format(" AND T1.CheckStatus = {0}", obj.CheckStatus);
}
if (!string.IsNullOrEmpty(obj.SupplierName))
{
sql += string.Format(" AND T1.SupplierName Like '%{0}%'", obj.SupplierName);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
{
sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
{
sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Stock_InStock>());
}
private ImportMessageModel TecProcessBom_FormatRow(DataRow row, Mes_Tec_ProcessBomItem itemObj, int rowIndex)
{
ImportMessageModel errorObj = null;
try
{
//导入样品
itemObj.MaterialProNo = TConvertHelper.FormatDBString(row["产品编码"]);
itemObj.Version = TConvertHelper.FormatDBString(row["版本"]);
itemObj.ProcessName = TConvertHelper.FormatDBString(row["工艺"]);
itemObj.SubMaterialProNo = TConvertHelper.FormatDBString(row["物料编码"]);
itemObj.Num = TConvertHelper.FormatDBInt(row["数量"]);
itemObj.Memo = TConvertHelper.FormatDBString(row["备注"]);
itemObj.CreatedTime = DateTime.Now;
if (string.IsNullOrEmpty(itemObj.MaterialProNo) || string.IsNullOrEmpty(itemObj.Version))
{
return(new ImportMessageModel()
{
RowData = string.Format(ReadErrorMessage, rowIndex), RowMessage = "产品编码、版本不能为空"
});
}
if (string.IsNullOrEmpty(itemObj.SubMaterialProNo))
{
return(new ImportMessageModel()
{
RowData = string.Format(ReadErrorMessage, rowIndex), RowMessage = "物料编码不能为空"
});
}
if (string.IsNullOrEmpty(itemObj.ProcessName))
{
return(new ImportMessageModel()
{
RowData = string.Format(ReadErrorMessage, rowIndex), RowMessage = "工艺不能为空"
});
}
if (itemObj.Num <= 0)
{
return(new ImportMessageModel()
{
RowData = string.Format(ReadErrorMessage, rowIndex), RowMessage = "数量不能为空"
});
}
}
catch (Exception ex)
{
return(new ImportMessageModel()
{
RowData = string.Format(ReadErrorMessage, rowIndex), RowMessage = ex.Message
});
}
return(errorObj);
}
public List <Mes_Plan_SaleOrder> FindByPage(Mes_Plan_SaleOrder obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.CustomerName FROM Mes_Plan_SaleOrder T1 WITH(NOLOCK)
LEFT JOIN dbo.Mes_Sys_Customer T2 WITH(NOLOCK) ON T1.CustomerID = T2.ID
WHERE OrderStatus<>20 ";
if (TConvertHelper.FormatDBInt(obj.OrderType) > 0)
{
sql += string.Format(" AND T1.OrderType = '{0}'", obj.OrderType);
}
if (!string.IsNullOrEmpty(obj.OrderNo))
{
sql += string.Format(" AND T1.OrderNo Like '%{0}%'", obj.OrderNo);
}
if (!string.IsNullOrEmpty(obj.OrderDateStart))
{
sql += string.Format(" AND T1.OrderDate >='{0}'", obj.OrderDateStart);
}
if (!string.IsNullOrEmpty(obj.OrderDateEnd))
{
sql += string.Format(" AND T1.OrderDate <'{0}'", TConvertHelper.FormatDBDate(obj.OrderDateEnd).AddDays(1));
}
if (obj.OrderStatus > 0)
{
sql += string.Format(" AND T1.OrderStatus = {0}", obj.OrderStatus);
}
if (!string.IsNullOrEmpty(obj.CustomerName))
{
sql += string.Format(" AND T1.CustomerName Like '%{0}%'", obj.CustomerName);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
{
sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
{
sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Plan_SaleOrder>());
}
/// <summary>
/// 按照工单号单个查找工单
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public Mes_Plan_WorkOrder Find(Mes_Plan_WorkOrder obj)
{
string sql = @"SELECT T1.*,T2.WorkShopName FROM Mes_Plan_WorkOrder T1
LEFT JOIN dbo.Mes_Sys_WorkShop T2 ON T1.WorkShopCode = T2.WorkShopCode
WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.WorkOrderNumber) > 0)
{
sql += string.Format(" AND T1.WorkOrderNumber = '{0}'", obj.WorkOrderNumber);
}
return(this.CurDbSession.FromSql(sql.ToString()).ToFirstDefault <Mes_Plan_WorkOrder>());
}
public List <Mes_Plan_WorkOrder> FindByPage(Mes_Plan_WorkOrder obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.WorkShopName FROM Mes_Plan_WorkOrder T1
LEFT JOIN dbo.Mes_Sys_WorkShop T2 ON T1.WorkShopCode = T2.WorkShopCode
WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.WorkOrderNumber) > 0)
{
sql += string.Format(" AND T1.WorkOrderNumber = '{0}'", obj.WorkOrderNumber);
}
if (!string.IsNullOrEmpty(obj.PlanCode))
{
sql += string.Format(" AND T1.PlanCode LIKE '%{0}%'", obj.PlanCode);
}
if (!string.IsNullOrEmpty(obj.MaterialProNo))
{
sql += string.Format(" AND T1.MaterialProNo= '{0}'", obj.MaterialProNo);
}
if (!string.IsNullOrEmpty(obj.MaterialCode))
{
sql += string.Format(" AND T1.MaterialCode= '{0}'", obj.MaterialCode);
}
if (obj.WorkOrderStatus > 0)
{
sql += string.Format(" AND T1.WorkOrderStatus = {0}", obj.WorkOrderStatus);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
{
sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
{
sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Plan_WorkOrder>());
}
public List <Mes_Stock_InStock> FindByCond(Mes_Stock_InStock obj)
{
string sql = @"SELECT T1.* FROM Mes_Stock_InStock T1 WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.BillType) > 0)
{
sql += string.Format(" AND T1.BillType = '{0}'", obj.BillType);
}
if (!string.IsNullOrEmpty(obj.BillNo))
{
sql += string.Format(" AND T1.BillNo Like '%{0}%'", obj.BillNo);
}
if (!string.IsNullOrEmpty(obj.InStockDateStart))
{
sql += string.Format(" AND T1.InStockDate >='{0}'", obj.InStockDateStart);
}
if (!string.IsNullOrEmpty(obj.InStockDateEnd))
{
sql += string.Format(" AND T1.InStockDate <'{0}'", TConvertHelper.FormatDBDate(obj.InStockDateEnd).AddDays(1));
}
if (obj.AuditStatus > 0)
{
sql += string.Format(" AND T1.AuditStatus = {0}", obj.AuditStatus);
}
if (obj.CheckStatus > 0)
{
sql += string.Format(" AND T1.CheckStatus = {0}", obj.CheckStatus);
}
if (!string.IsNullOrEmpty(obj.SupplierName))
{
sql += string.Format(" AND T1.SupplierName Like '%{0}%'", obj.SupplierName);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
{
sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
{
sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
}
sql += " ORDER BY CreatedTime DESC";
//返回当前页的记录数
return(this.CurDbSession.FromSql(sql).ToList <Mes_Stock_InStock>());
}
/// <summary>
/// 生成订单号
/// </summary>
/// <returns></returns>
public string GenOrderNo()
{
string sPrefix = DateTime.Now.ToString("yyMM");
string sql = "SELECT ISNULL(MAX(OrderNo),'') FROM Mes_Plan_SaleOrder WITH(NOLOCK) WHERE OrderNo LIKE '{0}%'";
sql = string.Format(sql, sPrefix);
string orderNo = this.CurDbSession.FromSql(sql).ToScalar <string>();
int maxNo = 0;
if (!string.IsNullOrEmpty(orderNo))
{
orderNo = orderNo.Replace(sPrefix, "");
maxNo = TConvertHelper.FormatDBInt(orderNo);
}
maxNo = maxNo + 1;
return(sPrefix + maxNo.ToString().PadLeft(6, '0'));
}
private ImportMessageModel ProductInfo_FormatRow(DataRow row, Mes_Tec_ProductInfo itemObj, int rowIndex)
{
ImportMessageModel errorObj = null;
try
{
//导入样品
string sTemp = "";
itemObj.MaterialProNo = TConvertHelper.FormatDBString(row["物料编码"]);
itemObj.MaterialCode = TConvertHelper.FormatDBString(row["物料名称"]);
sTemp = TConvertHelper.FormatDBString(row["物料分类"]);
if (!string.IsNullOrEmpty(sTemp))
{
itemObj.MaterialClass = StatusHelper.GetStatusByDescription <MaterialClassStatus>(sTemp);
}
sTemp = TConvertHelper.FormatDBString(row["批次属性"]);
if (!string.IsNullOrEmpty(sTemp))
{
itemObj.TraceProperty = TConvertHelper.FormatDBInt(StatusHelper.GetStatusByDescription <MaterialClassStatus>(sTemp));
}
itemObj.MaterialSize = TConvertHelper.FormatDBString(row["规格尺寸"]);
itemObj.Unit = TConvertHelper.FormatDBString(row["单位"]);
itemObj.PackNumber = TConvertHelper.FormatDBInt(row["每箱数量"]);
itemObj.Memo = TConvertHelper.FormatDBString(row["备注"]);
//itemObj.CreatedTime = DateTime.Now;
if (string.IsNullOrEmpty(itemObj.MaterialProNo) || string.IsNullOrEmpty(itemObj.MaterialCode))
{
return(new ImportMessageModel()
{
RowData = string.Format(ReadErrorMessage, rowIndex), RowMessage = "物料编码、物料名称不能为空"
});
}
}
catch (Exception ex)
{
return(new ImportMessageModel()
{
RowData = string.Format(ReadErrorMessage, rowIndex), RowMessage = ex.Message
});
}
return(errorObj);
}
public Mes_Plan_SaleOrder FindEntity(Mes_Plan_SaleOrder obj)
{
string sql = @"SELECT TOP 1 T1.*,T2.CustomerName FROM Mes_Plan_SaleOrder T1 WITH(NOLOCK)
LEFT JOIN dbo.Mes_Sys_Customer T2 WITH(NOLOCK) ON T1.CustomerID = T2.ID
WHERE OrderStatus<>20 ";
if (obj.ID > 0)
{
sql += string.Format(" AND T1.ID = {0}", obj.ID);
}
if (TConvertHelper.FormatDBInt(obj.OrderType) > 0)
{
sql += string.Format(" AND T1.OrderType = '{0}'", obj.OrderType);
}
if (!string.IsNullOrEmpty(obj.OrderNo))
{
sql += string.Format(" AND T1.OrderNo = '{0}'", obj.OrderNo);
}
return(this.CurDbSession.FromSql(sql).ToFirst <Mes_Plan_SaleOrder>());
}
public List <Mes_Plan_Material> FindByPage(Mes_Plan_Material obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.Name as Show_ProcessCode FROM Mes_Plan_Material T1
LEFT JOIN dbo.Mes_Tec_Process T2 ON T1.ProcessCode = T2.ProcessCode
WHERE 1=1 ";
if (TConvertHelper.FormatDBInt(obj.WorkOrderNumber) > 0)
{
sql += string.Format(" AND T1.WorkOrderNumber = '{0}'", obj.WorkOrderNumber);
}
if (!string.IsNullOrEmpty(obj.MaterialProNo))
{
sql += string.Format(" AND T1.MaterialProNo='{0}'", obj.MaterialProNo);
}
if (!string.IsNullOrEmpty(obj.MaterialCode))
{
sql += string.Format(" AND T1.MaterialCode= '{0}'", obj.MaterialCode);
}
if (!string.IsNullOrEmpty(obj.ProcessCode))
{
sql += string.Format(" AND T1.ProcessCode= '{0}'", obj.ProcessCode);
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Plan_Material>());
}