private static List <string> GetAddMaterialSupplieAndCustomerSql(MarerialInfoTableNew marerialinfotable)
{
List <string> sqls = new List <string>();
string sql = string.Empty;
if (!string.IsNullOrEmpty(marerialinfotable.SupplierMaterialNumber) && !string.IsNullOrEmpty(marerialinfotable.SupplierId))
{
if (!IsExitSupplierMaterialNumber(marerialinfotable.MaterialNumber, marerialinfotable.SupplierMaterialNumber))
{
sql = string.Format(@" insert into MaterialSupplierProperty (MaterialNumber ,SupplierId ,SupplierMaterialNumber,MinOrderQty )
values('{0}','{1}','{2}',{3}) ", marerialinfotable.MaterialNumber, marerialinfotable.SupplierId, marerialinfotable.SupplierMaterialNumber, marerialinfotable.MinOrderQty);
sqls.Add(sql);
}
}
if (!string.IsNullOrEmpty(marerialinfotable.CustomerMaterialNumber) && !string.IsNullOrEmpty(marerialinfotable.CustomerId))
{
if (!IsExitCustmoerMareialNumber(marerialinfotable.MaterialNumber, marerialinfotable.CustomerMaterialNumber))
{
sql = string.Format(@" insert into MaterialCustomerProperty(MaterialNumber ,CustomerMaterialNumber,CustomerId)
values('{0}','{1}','{2}') ", marerialinfotable.MaterialNumber, marerialinfotable.CustomerMaterialNumber, marerialinfotable.CustomerId);
sqls.Add(sql);
}
}
return(sqls);
}
/// <summary>
/// 批量添加原材料新
/// </summary>
/// <param name="marerialinfotable"></param>
/// <param name="error"></param>
/// <returns></returns>
public static bool AddMarielToBatch(MarerialInfoTableNew marerialinfotable, ref string error)
{
List <string> sqls = new List <string>();
string sql = string.Format(" select COUNT (*) from MarerialInfoTable where MaterialNumber='{0}' ", marerialinfotable.MaterialNumber);
if (SqlHelper.GetScalar(sql).Equals("0"))
{
sql = string.Format(@" insert into MarerialInfoTable (MaterialNumber,MaterialName,Description,Kind,Type,Brand,StockSafeQty,
ProcurementPrice,MaterialPosition,MinPacking,MinOrderQty,ScrapPosition,Remark,Cargo)
values ('{0}','{1}','{2}','{3}','{4}','{5}',{6},'{7}','{8}','{9}','{10}','{11}','{12}','{13}')",
marerialinfotable.MaterialNumber, marerialinfotable.MaterialName, marerialinfotable.Description, marerialinfotable.Kind,
marerialinfotable.Type, marerialinfotable.Brand, marerialinfotable.StockSafeQty, marerialinfotable.ProcurementPrice,
marerialinfotable.MaterialPosition, marerialinfotable.MinPacking, marerialinfotable.MinOrderQty,
marerialinfotable.ScrapPosition, marerialinfotable.Remark, marerialinfotable.Cargo);
sqls.Add(sql);
sqls.AddRange(GetAddMaterialSupplieAndCustomerSql(marerialinfotable));
}
else
{
sqls.AddRange(GetAddMaterialSupplieAndCustomerSql(marerialinfotable));
}
return(SqlHelper.BatchExecuteSql(sqls, ref error));
}
