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