public int InsertMaster(SaleRuleInfo oParam) { string sql = @"INSERT INTO SaleRule_Master (SaleRuleName, Status ,CreateUserSysNo) VALUES (@SaleRuleName, @Status, @CreateUserSysNo) set @SysNo = SCOPE_IDENTITY()" ; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSaleRuleName = new SqlParameter("@SaleRuleName", SqlDbType.NVarChar, 500); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.SaleRuleName != AppConst.StringNull) { paramSaleRuleName.Value = oParam.SaleRuleName; } else { paramSaleRuleName.Value = System.DBNull.Value; } if (oParam.Status != AppConst.IntNull) { paramStatus.Value = oParam.Status; } else { paramStatus.Value = System.DBNull.Value; } if (oParam.CreateUserSysNo != AppConst.IntNull) { paramCreateUserSysNo.Value = oParam.CreateUserSysNo; } else { paramCreateUserSysNo.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSaleRuleName); cmd.Parameters.Add(paramStatus); cmd.Parameters.Add(paramCreateUserSysNo); return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo)); }
public int UpdateMaster(SaleRuleInfo oParam) { string sql = @"UPDATE SaleRule_Master SET SaleRuleName=@SaleRuleName, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSaleRuleName = new SqlParameter("@SaleRuleName", SqlDbType.NVarChar, 500); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) { paramSysNo.Value = oParam.SysNo; } else { throw new Exception("SysNo can't be null"); } if (oParam.SaleRuleName != AppConst.StringNull) { paramSaleRuleName.Value = oParam.SaleRuleName; } else { paramSaleRuleName.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(paramSaleRuleName); cmd.Parameters.Add(paramStatus); return(SqlHelper.ExecuteNonQuery(cmd)); }