/// <summary>
/// 批量增加多条数据到销售单
/// </summary>
/// <param name="buyValues">主单数据,数量为22个字段</param>
/// <param name="detailList">从单数据,商品的信息.17个字段</param>
/// <returns>受影响的行数</returns>
public int AddBatch(Buy buy, List <BuyDetail> buyDetail)
{
if (buy == null)
{
return(0);
}
if (buyDetail.Count() < 1)
{
return(0);
}
StringBuilder sb;
List <string> sqlList = new List <string>();
sb = new StringBuilder();
sb.Append("insert into T_Buy(");
sb.Append("Buy_Code,Buy_Date,");
sb.Append("Buy_SupplierCode,Buy_SupplierName,Buy_PurchaseStatus,Buy_AuditStatus,");
sb.Append("Buy_PurchaserID,Buy_SalesMan,Buy_Operation,Buy_AuditMan,Buy_Remark,Buy_Clear,Buy_IsPay,Buy_PayMethod,");
sb.Append("Buy_IsPutSto,Buy_Class");
sb.Append(") values ('");
sb.Append(buy.Buy_Code + "','" + buy.Buy_Date + "','" + buy.Buy_suppliercode + "','"
+ buy.Buy_suppliername + "'," + buy.Buy_PurchaseStatus + "," + buy.Buy_AuditStatus + ",'"
+ buy.Buy_PurchaserID + "','" + buy.Buy_SalesMan + "','" + buy.Buy_Operation + "','"
+ buy.Buy_AuditMan + "','" + buy.Buy_Remark + "'," + buy.Buy_Clear + ","
+ buy.Buy_IsPay + "," + buy.Buy_PayMethod + "," + buy.Buy_IsPutSto + ",'"
+ buy.Buy_class + "')");
sqlList.Add(sb.ToString());
foreach (BuyDetail value in buyDetail)
{
sb = new StringBuilder();
sb.Append("insert into T_BuyDetail(");
sb.Append("Buy_LineCode,Buy_StockCode,Buy_StockName,Buy_Code,Buy_MaID,Buy_MaName,");
sb.Append("Buy_Model,Buy_Unit,Buy_CurNumber,Buy_DiscountAPrice,");
sb.Append("Buy_Discount,Buy_DiscountBPrice,Buy_AmountMoney,Buy_Clear,Buy_Remark");
sb.Append(") values ('");
sb.Append(value.Buy_LineCode + "','" + value.Buy_StockCode + "','" +
value.Buy_StockName + "','" + value.Buy_Code + "','" + value.Buy_MaID + "','" +
value.Buy_MaName + "','" + value.Buy_Model + "','" + value.Buy_Unit + "','" +
value.Buy_CurNumber + "','" + value.Buy_DiscountAPrice + "','" + value.Buy_Discount + "','" +
value.Buy_DiscountBPrice + "','" + value.Buy_AmountMoney + "'," + value.Buy_Clear + ",'" +
value.Buy_Remark + "')");
sqlList.Add(sb.ToString());
}
try
{
int influenceRow = bs.AddBatch(sqlList);
return(influenceRow);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 批量增加多条数据
/// </summary>
/// <param name="sqlList">要增加的sql</param>
/// <returns>影响行数</returns>
public int AddBatch(List <string> sqlList)
{
return(bs.AddBatch(sqlList));
}