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