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