public int Update(PrjItemInfo oParam) { string sql = @"UPDATE Prj_Item SET PrjSysNo=@PrjSysNo, SlnItemSysNo=@SlnItemSysNo, DefaultProductSysNo=@DefaultProductSysNo, DefaultQty=@DefaultQty, IsShowPic=@IsShowPic, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramPrjSysNo = new SqlParameter("@PrjSysNo", SqlDbType.Int, 4); SqlParameter paramSlnItemSysNo = new SqlParameter("@SlnItemSysNo", SqlDbType.Int, 4); SqlParameter paramDefaultProductSysNo = new SqlParameter("@DefaultProductSysNo", SqlDbType.Int, 4); SqlParameter paramDefaultQty = new SqlParameter("@DefaultQty", SqlDbType.Int, 4); SqlParameter paramIsShowPic = new SqlParameter("@IsShowPic", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) { paramSysNo.Value = oParam.SysNo; } else { paramSysNo.Value = System.DBNull.Value; } if (oParam.PrjSysNo != AppConst.IntNull) { paramPrjSysNo.Value = oParam.PrjSysNo; } else { paramPrjSysNo.Value = System.DBNull.Value; } if (oParam.SlnItemSysNo != AppConst.IntNull) { paramSlnItemSysNo.Value = oParam.SlnItemSysNo; } else { paramSlnItemSysNo.Value = System.DBNull.Value; } if (oParam.DefaultProductSysNo != AppConst.IntNull) { paramDefaultProductSysNo.Value = oParam.DefaultProductSysNo; } else { paramDefaultProductSysNo.Value = System.DBNull.Value; } if (oParam.DefaultQty != AppConst.IntNull) { paramDefaultQty.Value = oParam.DefaultQty; } else { paramDefaultQty.Value = System.DBNull.Value; } if (oParam.IsShowPic != AppConst.IntNull) { paramIsShowPic.Value = oParam.IsShowPic; } else { paramIsShowPic.Value = System.DBNull.Value; } if (oParam.Status != AppConst.IntNull) { paramStatus.Value = oParam.Status; } else { paramStatus.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramPrjSysNo); cmd.Parameters.Add(paramSlnItemSysNo); cmd.Parameters.Add(paramDefaultProductSysNo); cmd.Parameters.Add(paramDefaultQty); cmd.Parameters.Add(paramIsShowPic); cmd.Parameters.Add(paramStatus); return(SqlHelper.ExecuteNonQuery(cmd)); }
public int Insert(PrjItemInfo oParam) { string sql = @"INSERT INTO Prj_Item ( PrjSysNo, SlnItemSysNo, DefaultProductSysNo, DefaultQty, IsShowPic, Status ) VALUES ( @PrjSysNo, @SlnItemSysNo, @DefaultProductSysNo, @DefaultQty, @IsShowPic, @Status );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramPrjSysNo = new SqlParameter("@PrjSysNo", SqlDbType.Int, 4); SqlParameter paramSlnItemSysNo = new SqlParameter("@SlnItemSysNo", SqlDbType.Int, 4); SqlParameter paramDefaultProductSysNo = new SqlParameter("@DefaultProductSysNo", SqlDbType.Int, 4); SqlParameter paramDefaultQty = new SqlParameter("@DefaultQty", SqlDbType.Int, 4); SqlParameter paramIsShowPic = new SqlParameter("@IsShowPic", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.PrjSysNo != AppConst.IntNull) { paramPrjSysNo.Value = oParam.PrjSysNo; } else { paramPrjSysNo.Value = System.DBNull.Value; } if (oParam.SlnItemSysNo != AppConst.IntNull) { paramSlnItemSysNo.Value = oParam.SlnItemSysNo; } else { paramSlnItemSysNo.Value = System.DBNull.Value; } if (oParam.DefaultProductSysNo != AppConst.IntNull) { paramDefaultProductSysNo.Value = oParam.DefaultProductSysNo; } else { paramDefaultProductSysNo.Value = System.DBNull.Value; } if (oParam.DefaultQty != AppConst.IntNull) { paramDefaultQty.Value = oParam.DefaultQty; } else { paramDefaultQty.Value = System.DBNull.Value; } if (oParam.IsShowPic != AppConst.IntNull) { paramIsShowPic.Value = oParam.IsShowPic; } else { paramIsShowPic.Value = System.DBNull.Value; } if (oParam.Status != AppConst.IntNull) { paramStatus.Value = oParam.Status; } else { paramStatus.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramPrjSysNo); cmd.Parameters.Add(paramSlnItemSysNo); cmd.Parameters.Add(paramDefaultProductSysNo); cmd.Parameters.Add(paramDefaultQty); cmd.Parameters.Add(paramIsShowPic); cmd.Parameters.Add(paramStatus); return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo)); }