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