/// <summary>
/// 添加贸易销售订单明细
/// </summary>
/// <param name="tod">实体类</param>
/// <param name="error"></param>
/// <returns></returns>
public static bool AddTradingOrderDetail(TradingOrderDetail tod, ref string error)
{
try
{
Convert.ToDateTime(tod.Delivery);
}
catch (Exception)
{
error = string.Format("交期{0}不是标准日期格式 yyyy-MM-dd ", tod.Delivery);
return(false);
}
string sql = string.Format(@"select top 1 MaterialNumber
from MaterialCustomerProperty where CustomerMaterialNumber='{0}' and CustomerId='{1}'", tod.CustomerMaterialNumber, tod.CustomerId);
string materialNumber = SqlHelper.GetScalar(sql);
if (string.IsNullOrEmpty(materialNumber))
{
error = string.Format("系统不存在该客户原材料编号{0}", tod.CustomerMaterialNumber);
return(false);
}
if (string.IsNullOrEmpty(tod.OrdersNumber) || string.IsNullOrEmpty(tod.CustomerMaterialNumber) ||
string.IsNullOrEmpty(tod.RowNumber) || string.IsNullOrEmpty(tod.Delivery) ||
string.IsNullOrEmpty(tod.SN) || string.IsNullOrEmpty(tod.Quantity))
{
error = string.Format("信息填写不完整！");
return(false);
}
sql = string.Format(@" select COUNT(*) from TradingOrderDetail where OdersNumber ='{0}' and ProductNumber ='{1}' and RowNumber ='{2}'"
, tod.OrdersNumber, tod.ProductNumber, tod.RowNumber);
if (!SqlHelper.GetScalar(sql).Equals("0"))
{
error = string.Format("订单记录已存在");
return(false);
}
List <string> sqls = new List <string>();
sql = string.Format(@"
select 单价 from V_FindPriceForNewForTrading where 原材料编号='{0}' and 客户编号='{1}' ", materialNumber, tod.CustomerId);
string unitPrice = SqlHelper.GetScalar(sql);
unitPrice = string.IsNullOrEmpty(unitPrice) ? "0" : unitPrice;
sql = string.Format(@" insert into TradingOrderDetail(OdersNumber ,ProductNumber,RowNumber ,Delivery ,SN,CustomerMaterialNumber,
MaterialName ,Brand ,Quantity ,NonDeliveryQty ,DeliveryQty ,UnitPrice ,TotalPrice ,CreateTime ,Remark )
select '{0}',MaterialNumber,'{1}','{2}',{3},'{4}',Description ,Brand ,{5},{5},0,{9},{9}*{5},'{6}','{8}'
from MarerialInfoTable where MaterialNumber ='{7}'", tod.OrdersNumber, tod.RowNumber, tod.Delivery, tod.SN, tod.CustomerMaterialNumber,
tod.Quantity, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), materialNumber, tod.Remark, unitPrice);
sqls.Add(sql);
return(SqlHelper.BatchExecuteSql(sqls, ref error));
}
/// <summary>
/// 批量导入销售订单
/// </summary>
/// <param name="so"></param>
/// <param name="FU_Excel"></param>
/// <param name="server"></param>
/// <param name="error"></param>
/// <returns></returns>
public static bool BacthAddSaleOrder(SaleOder so, FileUpload FU_Excel, HttpServerUtility server, ref string error)
{
bool result = false;
DataSet ds = ToolManager.ImpExcel(FU_Excel, server);
if (ds == null)
{
error = "选择的文件为空或不是标准的Excel文件！";
return(false);
}
DataTable dt = ds.Tables[0];
if (so.ProductType.Equals("贸易"))
{
if (!dt.Columns.Contains("客户物料编号"))
{
error = "导入模板与生产类型不一致！";
return(false);
}
}
else
{
if (!dt.Columns.Contains("客户产成品编号"))
{
error = "导入模板与生产类型不一致！";
return(false);
}
}
//插入主表信息
string sql = string.Format(@"insert into SaleOder (OdersNumber ,OrdersDate
,OdersType ,ProductType ,MakeCollectionsMode,CustomerId
,ContactId ,CreateTime ,Remark ,CustomerOrderNumber,KhddH )
values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", so.OrdersNumber, so.OrdersDate, so.OdersType
, so.ProductType, so.MakeCollectionsMode, so.CustomerId, so.ContactId, so.CreateTime, so.Remark, so.CustomerOrderNumber, so.KhddH);
SqlHelper.ExecuteSql(sql, ref error);
//按照生产类型分别批量添加
if (so.ProductType.Equals("贸易"))
{
List <TradingOrderDetail> tods = new List <TradingOrderDetail>();
foreach (DataRow dr in dt.Rows)
{
TradingOrderDetail tod = new TradingOrderDetail();
tod.OrdersNumber = so.OrdersNumber;
tod.SN = dr["序号"].ToString();
tod.RowNumber = dr["行号"].ToString();
tod.Delivery = GetLeadTime(dr["交期"].ToString());
tod.CustomerMaterialNumber = dr["客户物料编号"].ToString();
tod.Quantity = dr["订单数量"].ToString();
tod.Remark = dr["备注"].ToString();
tod.CustomerId = so.CustomerId;
tods.Add(tod);
}
result = BacthAddTradingOrderDetail(tods, ref error);
}
else // 序号 行号 交期 客户产成品编号 订单数量
{
List <MachineOderDetail> mods = new List <MachineOderDetail>();
foreach (DataRow dr in dt.Rows)
{
MachineOderDetail mod = new MachineOderDetail();
mod.OrdersNumber = so.OrdersNumber;
mod.SN = dr["序号"].ToString();
mod.RowNumber = dr["行号"].ToString();
mod.LeadTime = GetLeadTime(dr["交期"].ToString());
mod.CustomerProductNumber = dr["客户产成品编号"].ToString();
mod.Qty = dr["订单数量"].ToString();
mod.CustomerId = so.CustomerId;
mod.Version = dr["版本"].ToString().ToUpper();
if (mod.Version.Equals(""))
{
mod.Version = SellManager.GetMostNewVersion(dr["客户产成品编号"].ToString());
}
else if (mod.Version.Equals("OO"))
{
mod.Version = "00";
}
mods.Add(mod);
}
result = BacthAddMachineOderDetail(mods, ref error);
}
return(result);
}
