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