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 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>());
}
public ActionResult BarcodeInfo_FindByPage(Mes_Tra_SourceBarcode obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = SourceBarcodeDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }));
}
private IList <ImportMessageModel> Import_BarcodeInfo(DataTable dtData)
{
IList <ImportMessageModel> resultList = new List <ImportMessageModel>();
//提示用户导入消息有错，但不影响数据导入
IList <ImportMessageModel> msgList = new List <ImportMessageModel>();
List <Mes_Tra_SourceBarcode> dataList = new List <Mes_Tra_SourceBarcode>();
int rowIndex = 0;//第1行是行头
DateTime time = DateTime.Now;
ImportMessageModel errorObj = null;
string batchNo = DateTime.Now.ToString("yyMMddHHmmss");
if (dtData != null && dtData.Rows.Count > 0)
{
Mes_Tra_SourceBarcode itemObj = null;
foreach (DataRow row in dtData.Rows)
{
rowIndex++;
itemObj = new Mes_Tra_SourceBarcode();
itemObj.CreatedTime = time;
itemObj.Creater = curUserId;
itemObj.PackSN = batchNo;
//存样品信息
errorObj = BarcodeInfo_FormatRow(row, itemObj, rowIndex);
if (errorObj != null) //记录行错误信息
{
resultList.Add(errorObj);
continue;
}
//检测条码是否重复
if (SourceBarcodeDao.Instance.IsExist(itemObj.Barcode))
{
resultList.Add(new ImportMessageModel()
{
RowData = string.Format(ReadErrorMessage, rowIndex), RowMessage = string.Format("条码【{0}】已经存在", itemObj.Barcode)
});
}
if (dataList.Exists(p => p.Barcode == itemObj.Barcode))
{
resultList.Add(new ImportMessageModel()
{
RowData = string.Format(ReadErrorMessage, rowIndex), RowMessage = string.Format("条码【{0}】重复导入", itemObj.Barcode)
});
}
dataList.Add(itemObj);
}
}
//如果校验有错误，直接返回错误信息
if (resultList.Count > 0)
{
return(resultList);
}
//2.校验成功执行导入
SourceBarcodeDao.Instance.Import(dataList, resultList);
if (resultList.Count == 0)
{
resultList.Add(new ImportMessageModel {
RowData = "导入成功", RowMessage = "数据已成功导入"
});
}
return(resultList);
}
