protected override void BindingOrderHeader(string fieldName, string fieldValue)
{
switch (fieldName)
{
case "单据号":
_order.FromBillNo = fieldValue;
_order.SOCode = DbCommonMethod.GetStockOutCode(fieldValue);
break;
case "日期":
if (!string.IsNullOrEmpty(fieldValue))
{
DateTime dt;
if (DateTime.TryParse(fieldValue, out dt))
{
_order.SODate = dt;
}
}
break;
case "发出仓库":
_order.WHName = fieldValue;
_order.WHCode = DbCommonMethod.ParsingWarehouse(fieldValue);
if (string.IsNullOrEmpty(_order.WHCode))
{
throw new ApplicationException("仓库不存在：" + fieldValue);
}
break;
case "备注":
_order.Comment = fieldValue;
break;
case "收发类别":
_order.OutCategory = DbCommonMethod.GetOutCategory(fieldValue);
break;
case "领导":
_order.LeaderSign = fieldValue;
break;
case "仓管":
_order.WarehouseSign = fieldValue;
break;
case "财务":
_order.AccountSign = fieldValue;
break;
case "经办人":
_order.BusinessSign = fieldValue;
break;
case "制单人":
_order.EditorSign = fieldValue;
break;
case "合 计 （RMB)":
if (!string.IsNullOrEmpty(fieldValue))
{
decimal d;
if (decimal.TryParse(fieldValue, out d))
{
_order.TotalMoney = d;
}
}
break;
default:
break;
}
}
/// <summary>
/// 从DataTable中获取实体列表
/// </summary>
/// <param name="dt"></param>
/// <param name="msg"></param>
/// <returns></returns>
private List <DAL.StockOut> GetModelFromDataTable(DataTable dt, out string msg)
{
try
{
List <DAL.StockOut> list = new List <DAL.StockOut>();
msg = "";
//接口协议文档中定义的字段
Dictionary <string, string> dataFieldNameDic = new Dictionary <string, string>();
dataFieldNameDic.Add("BillCode", "其他出库单号");
dataFieldNameDic.Add("BillDate", "日期");
dataFieldNameDic.Add("OutCategory", "收发类别");
dataFieldNameDic.Add("OutWHName", "发出仓库");
dataFieldNameDic.Add("Comment", "备注");
dataFieldNameDic.Add("TotalNumber", "合计数量");
dataFieldNameDic.Add("LeaderSign", "领导");
dataFieldNameDic.Add("WareHouseKeeper", "仓管");
dataFieldNameDic.Add("AccountSign", "财务");
dataFieldNameDic.Add("BusinessSign", "经办人");
dataFieldNameDic.Add("EditorSign", "制单人");
if (dt == null || dt.Rows.Count == 0)
{
msg = "用友系统返回数据集中无数据！";
return(new List <StockOut>());
}
StringBuilder errorColName = new StringBuilder();
//检查数据集中是否存在指定字段
foreach (KeyValuePair <string, string> kvp in dataFieldNameDic)
{
if (dt.Columns.Contains(kvp.Key) == false)
{
errorColName.Append(Environment.NewLine);
errorColName.Append(kvp.Value);
errorColName.Append("-");
errorColName.Append(kvp.Key);
}
}
if (errorColName.Length > 0)
{
errorColName.Insert(0, "用友系统返回的数据集中未包含如下字段，不能进行有效解析！");
msg = errorColName.ToString();
return(new List <StockOut>());;
}
//遍历数据集创建实体
foreach (DataRow dr in dt.Rows)
{
StockOut newModel = new StockOut();
//newModel.SOCode = KeyGenerator.Instance.GetStockOutKey();
newModel.FromBillNo = DataCheckHelper.GetCellString(dr["BillCode"]);
//日期
if (!string.IsNullOrEmpty(DataCheckHelper.GetCellString(dr["BillDate"])))
{
DateTime d;
if (DateTime.TryParse(DataCheckHelper.GetCellString(dr["BillDate"]), out d))
{
newModel.SODate = d;
}
}
//收发类别
newModel.OutCategory = DbCommonMethod.GetOutCategory(DataCheckHelper.GetCellString(dr["OutCategory"]));
newModel.WHName = DataCheckHelper.GetCellString(dr["OutWHName"]);
newModel.WHCode = DbCommonMethod.ParsingWarehouse(newModel.WHName);
if (string.IsNullOrEmpty(newModel.WHCode))
{
throw new ApplicationException("单号" + newModel.FromBillNo + ",仓库不存在：" + newModel.WHName);
}
newModel.Comment = DataCheckHelper.GetCellString(dr["Comment"]);
//合计数量
if (!string.IsNullOrEmpty(DataCheckHelper.GetCellString(dr["TotalNumber"])))
{
decimal d;
if (decimal.TryParse(DataCheckHelper.GetCellString(dr["TotalNumber"]), out d))
{
newModel.TotalMoney = d;
}
}
newModel.LeaderSign = DataCheckHelper.GetCellString(dr["LeaderSign"]);
newModel.WarehouseSign = DataCheckHelper.GetCellString(dr["WareHouseKeeper"]);
newModel.AccountSign = DataCheckHelper.GetCellString(dr["AccountSign"]);
newModel.BusinessSign = DataCheckHelper.GetCellString(dr["BusinessSign"]);
newModel.EditorSign = DataCheckHelper.GetCellString(dr["EditorSign"]);
newModel.SOStatus = 1; //已保存
newModel.FromBillType = "13"; //11-销售出库单、12-调拨出库单、13-其他出库单
newModel.EditStatus = 0; //无人编辑
newModel.SOType = CommonConvert.GetSIOTypeCode("其他出库单");
newModel.FromType = CommonConvert.GetFromTypeCode("源于Excel导入的出库单");
List <StockOut> existStockOut = (from r in list where r.FromBillNo == newModel.FromBillNo select r).ToList <StockOut>();
if (existStockOut == null || existStockOut.Count == 0)//过滤重复数据
{
list.Add(newModel);
}
}
return(list);
}
catch (Exception ex)
{
msg = ex.Message;
return(new List <StockOut>());;
}
}