public ActionResult RightConfig() { Mes_Sys_RoleMap obj = new Mes_Sys_RoleMap(); obj.Sys_Role_ID = TConvertHelper.FormatDBInt(Request.Params["RoleID"]); return(View(obj)); }
public List <Mes_Tra_SourceBarcode> FindByPage(Mes_Tra_SourceBarcode obj, ref PagerBase pager) { string sql = @"SELECT T1.* FROM Mes_Tra_SourceBarcode T1 WITH(NOLOCK) WHERE 1=1 "; if (!string.IsNullOrEmpty(obj.Barcode)) { sql += string.Format(" AND T1.Barcode Like '{0}%'", obj.Barcode); } if (!string.IsNullOrEmpty(obj.PackSN)) { sql += string.Format(" AND T1.PackSN Like '{0}%'", obj.PackSN); } 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_Tra_SourceBarcode>()); }
private ImportMessageModel BarcodeInfo_FormatRow(DataRow row, Mes_Tra_SourceBarcode itemObj, int rowIndex) { ImportMessageModel errorObj = null; try { itemObj.Barcode = TConvertHelper.FormatDBString(row["条码"]); if (string.IsNullOrEmpty(itemObj.Barcode)) { 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 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>()); }
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>()); }
public List <Mes_Tra_OutStock> FindByPage(Mes_Tra_OutStock obj, ref PagerBase pager) { string sql = @"select T1.*,T2.OrgName as Show_OrgID from Mes_Tra_OutStock T1 with (nolock) Left join Mes_Sys_Organization T2 with (nolock) on T1.OrgID=T2.ID WHERE 1=1 "; if (!string.IsNullOrEmpty(obj.Barcode)) { sql += string.Format(" AND T1.Barcode='{0}'", obj.Barcode); } if (!string.IsNullOrEmpty(obj.SN)) { sql += string.Format(" AND T1.SN='{0}'", obj.SN); } if (!string.IsNullOrEmpty(obj.PackSN)) { sql += string.Format(" AND T1.PackSN='{0}'", obj.PackSN); } 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.OrderNumber)) { sql += string.Format(" AND T1.OrderNumber='{0}'", obj.OrderNumber); } if (!string.IsNullOrEmpty(obj.ScanTimeStart)) { sql += string.Format(" AND T1.ScanTime>='{0}'", obj.ScanTimeStart); } if (!string.IsNullOrEmpty(obj.ScanTimeEnd)) { sql += string.Format(" AND T1.ScanTime<'{0}'", TConvertHelper.FormatDBDate(obj.ScanTimeEnd).AddDays(1)); } string orderBy = pager.OrderBy; if (string.IsNullOrEmpty(orderBy)) { orderBy = "ScanTime 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_Tra_OutStock>()); }
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); }
/// <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>()); }
public List <Mes_Sys_FlowConfig> FindByPage(Mes_Sys_FlowConfig obj, ref PagerBase pager) { string sql = @"SELECT T1.* FROM Mes_Sys_FlowConfig T1 WHERE 1=1 "; if (!string.IsNullOrEmpty(obj.BusinessType)) { sql += string.Format(" AND T1.BusinessType ='{0}'", obj.BusinessType); } if (!string.IsNullOrEmpty(obj.OptUserName)) { sql += string.Format(" AND T1.OptUserName LIKE '%{0}%'", obj.OptUserName); } 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_Sys_FlowConfig>()); }
/// <summary> /// 通用导出 /// </summary> /// <param name="businessObj"></param> public static string Export <T>(ref BussinessModel businessObj, List <T> list) where T : class { string message = string.Empty; try { //1.生成文件(由模板生成新的文件) string templateName = "ExportTemplate.xls"; string templatePath = HttpContext.Current.Server.MapPath("~" + SysConfigHelper.TemplateFolder) + templateName; string tempPath = HttpContext.Current.Server.MapPath("~" + SysConfigHelper.TempFolder); string fileName = string.Format("{0}_{1}.xls", businessObj.BusinessType, DateTime.Now.ToString("yyMMddHHmmssffff")); businessObj.FilePath = tempPath + fileName; businessObj.FileName = fileName; message = FileHelper.CopyFile(templatePath, tempPath.Trim('/'), fileName); if (!string.IsNullOrEmpty(message)) { return(message); } //2.填写文件内容 CellDLL.Workbook workbook = new CellDLL.Workbook(businessObj.FilePath); CellDLL.Cells cells = workbook.Worksheets[0].Cells;//单元格 int index = 0; int colNum = 0; object value = null; IDictionary <string, PropertyInfo> colProperties = new Dictionary <string, PropertyInfo>(); PropertyInfo property = null; Type type = typeof(T); if (businessObj.ColList != null && businessObj.ColList.Count > 0) { //(1)先写列头 businessObj.ColList.ForEach(item => { cells[index, colNum++].Value = item.Value; if (!colProperties.ContainsKey(item.Key)) { property = type.GetProperty(item.Key); colProperties.Add(item.Key, property); } }); //(2)写内容 if (list != null && list.Count > 0) { index = 1; colNum = 0; foreach (var item in list) { foreach (KeyModel keyObj in businessObj.ColList) { property = colProperties[keyObj.Key]; if (property != null) { value = property.GetValue(item, null); cells[index, colNum].Value = TConvertHelper.FormatDBString(value); } colNum++; } colNum = 0; index++; } } }/*businessObj.ColList*/ //3.保存文件 workbook.Save(businessObj.FilePath); } catch (Exception ex) { return("导出文件时出错,文件可能正被打开!"); } finally { //xlApp.Quit(); GC.Collect();//强行销毁 } return(string.Empty); }
public IHttpActionResult Create(Models.RequestModel.TeachingScheduleRequest teachingschedule) { logs.Info(Newtonsoft.Json.JsonConvert.SerializeObject(teachingschedule)); if (!ModelState.IsValid) { return(Ok(Comm.ResponseModel.ResponseModelBase.GetRes(ValidationMsg))); } try { //上课周期 string[] curriculumDateArr = teachingschedule.CurriculumDateStr .Split("to".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); DateTime startDate = Convert.ToDateTime(curriculumDateArr[0]); DateTime endDate = Convert.ToDateTime(curriculumDateArr[1]); List <Sys.Models.TeachingSchedule> entityList = new List <Sys.Models.TeachingSchedule>(); bool isContain = true; while (isContain) { try { //上午上课 entityList.AddRange(BuildClass(teachingschedule.TimepickerAMCheckd, startDate, teachingschedule.CurriculumAMTime, teachingschedule)); //下午上课 entityList.AddRange(BuildClass(teachingschedule.TimepickerPMCheckd, startDate, teachingschedule.CurriculumPMTime, teachingschedule)); } catch (Exception ex) { logs.Error("排课失败", ex); return(Ok(Comm.ResponseModel.ResponseModelBase.GetRes(ex.Message))); } startDate = startDate.AddDays(1); if (startDate > endDate) { isContain = false; } } bool isOk = false; var campusInfo = DapperHelper.Instance.Get <Campus>(teachingschedule.CampusID); System.Data.IDbConnection connection = Comm.Helper.DapperHelper.Instance; using (connection) { connection.Open(); System.Data.IDbTransaction transaction = connection.BeginTransaction(); try { TeachingScheduleMaster tcm = TConvertHelper.Mapper <TeachingScheduleMaster, TeachingScheduleRequest>(teachingschedule); tcm.AddTime = DateTime.Now; tcm.CurriculumBeginDate = Convert.ToDateTime(curriculumDateArr[0]); tcm.CurriculumEndDate = Convert.ToDateTime(curriculumDateArr[1]); tcm.TotalClassHour = entityList.Count; tcm.Latitude = campusInfo.Latitude; tcm.Longitude = campusInfo.Longitude; connection.Insert <TeachingScheduleMaster>(tcm, transaction); connection.Insert <Sys.Models.TeachingSchedule>(entityList, transaction); transaction.Commit(); isOk = true; } catch (Exception ex) { logs.Error("排课失败", ex); transaction.Rollback(); return(BadRequest()); } } return(isOk ? Ok(Comm.ResponseModel.ResponseModelBase.Success()) : Ok(Comm.ResponseModel.ResponseModelBase.SysError())); } catch (Exception ex) { logs.Error("排课失败", ex); return(BadRequest()); } }