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