/// <summary>
/// 增加入库单
/// </summary>
/// <param name="changeStock"></param>
/// <param name="conn"></param>
/// <returns></returns>
public int InsertStockIn(StockInInfo stockIn, SqlTransaction trans)
{
Guid g = Guid.NewGuid();
stockIn.id = g;
string sql = @"INSERT INTO [StockInHead]
([StockInNO]
,[WarehouseID]
,[StockInTP]
,[StockInDate]
,[StockInReason]
,[SupplierID]
,[InsertDateTime]
,[InsertUser])
VALUES
(@StockInNO
,@WarehouseID
,@StockInTP
,@StockInDate
,@StockInReason
,@SupplierID
,@InsertDateTime
,@InsertUser)";
SqlParameter[] spvalues = DBTool.GetSqlPm(stockIn);
int res = SqlHelper.ExecuteNonQuery(trans, CommandType.Text, sql, spvalues);
foreach (StockInBody ckb in stockIn.stockInDetail)
{
ckb.HeadId = g;
InsertDetail(ckb, trans);
}
return(res);
}
/// <summary>
/// 更新入库单
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public int UpdateStockIn(StockInInfo stockIn, bool changebody, SqlTransaction trans)
{
string sql = @"UPDATE [StockInHead]
SET [StockInNO] = @StockInNO
,[WarehouseID] = @WarehouseID
,[StockInTP] = @StockInTP
,[StockInDate] = @StockInDate
,[StockInReason] = @StockInReason
,[SupplierID] = @SupplierID
,[InsertDateTime] = @InsertDateTime
,[InsertUser] = @InsertUser
,[UpdateDateTime] = @UpdateDateTime
,[UpdateUser] = @UpdateUser
WHERE id=@id";
SqlParameter[] spvalues = DBTool.GetSqlPm(stockIn);
int res = SqlHelper.ExecuteNonQuery(trans, CommandType.Text, sql, spvalues);
if (changebody)
{
DeleteDetail(stockIn.id, trans);
foreach (StockInBody ckb in stockIn.stockInDetail)
{
InsertDetail(ckb, trans);
}
}
return(res);
}
public int InsertStockIn(StockInInfo stockIn)
{
SqlConnection conn;
int count = 0;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
count = DAL.InsertStockIn(stockIn, trans);
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
conn.Close();
}
return(count);
}
