public int Insert(CouponRequestInfo oParam)
{
string sql = @"INSERT INTO CouponRequest
(
CustomerSysNo, CouponCode, RequestUserSysNo, RequestTime,
AuditUserSysNo, AuditTime, SOSysNo, BatchNo,
Note, Status, EXECSql
)
VALUES (
@CustomerSysNo, @CouponCode, @RequestUserSysNo, @RequestTime,
@AuditUserSysNo, @AuditTime, @SOSysNo, @BatchNo,
@Note, @Status, @EXECSql
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4);
SqlParameter paramCouponCode = new SqlParameter("@CouponCode", SqlDbType.NVarChar, 20);
SqlParameter paramRequestUserSysNo = new SqlParameter("@RequestUserSysNo", SqlDbType.Int, 4);
SqlParameter paramRequestTime = new SqlParameter("@RequestTime", SqlDbType.DateTime);
SqlParameter paramAuditUserSysNo = new SqlParameter("@AuditUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAuditTime = new SqlParameter("@AuditTime", SqlDbType.DateTime);
SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4);
SqlParameter paramBatchNo = new SqlParameter("@BatchNo", SqlDbType.Int, 4);
SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 200);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramEXECSql = new SqlParameter("@EXECSql", SqlDbType.Text, 0);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.CustomerSysNo != AppConst.IntNull)
{
paramCustomerSysNo.Value = oParam.CustomerSysNo;
}
else
{
paramCustomerSysNo.Value = System.DBNull.Value;
}
if (oParam.CouponCode != AppConst.StringNull)
{
paramCouponCode.Value = oParam.CouponCode;
}
else
{
paramCouponCode.Value = System.DBNull.Value;
}
if (oParam.RequestUserSysNo != AppConst.IntNull)
{
paramRequestUserSysNo.Value = oParam.RequestUserSysNo;
}
else
{
paramRequestUserSysNo.Value = System.DBNull.Value;
}
if (oParam.RequestTime != AppConst.DateTimeNull)
{
paramRequestTime.Value = oParam.RequestTime;
}
else
{
paramRequestTime.Value = System.DBNull.Value;
}
if (oParam.AuditUserSysNo != AppConst.IntNull)
{
paramAuditUserSysNo.Value = oParam.AuditUserSysNo;
}
else
{
paramAuditUserSysNo.Value = System.DBNull.Value;
}
if (oParam.AuditTime != AppConst.DateTimeNull)
{
paramAuditTime.Value = oParam.AuditTime;
}
else
{
paramAuditTime.Value = System.DBNull.Value;
}
if (oParam.SOSysNo != AppConst.IntNull)
{
paramSOSysNo.Value = oParam.SOSysNo;
}
else
{
paramSOSysNo.Value = System.DBNull.Value;
}
if (oParam.BatchNo != AppConst.IntNull)
{
paramBatchNo.Value = oParam.BatchNo;
}
else
{
paramBatchNo.Value = System.DBNull.Value;
}
if (oParam.Note != AppConst.StringNull)
{
paramNote.Value = oParam.Note;
}
else
{
paramNote.Value = System.DBNull.Value;
}
if (oParam.Status != AppConst.IntNull)
{
paramStatus.Value = oParam.Status;
}
else
{
paramStatus.Value = System.DBNull.Value;
}
if (oParam.EXECSql != AppConst.StringNull)
{
paramEXECSql.Value = oParam.EXECSql;
}
else
{
paramEXECSql.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramCustomerSysNo);
cmd.Parameters.Add(paramCouponCode);
cmd.Parameters.Add(paramRequestUserSysNo);
cmd.Parameters.Add(paramRequestTime);
cmd.Parameters.Add(paramAuditUserSysNo);
cmd.Parameters.Add(paramAuditTime);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramBatchNo);
cmd.Parameters.Add(paramNote);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramEXECSql);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
public int Update(CouponRequestInfo oParam)
{
string sql = @"UPDATE CouponRequest SET
CustomerSysNo=@CustomerSysNo, CouponCode=@CouponCode,
RequestUserSysNo=@RequestUserSysNo, RequestTime=@RequestTime,
AuditUserSysNo=@AuditUserSysNo, AuditTime=@AuditTime,
SOSysNo=@SOSysNo, BatchNo=@BatchNo,
Note=@Note, Status=@Status,
EXECSql=@EXECSql
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4);
SqlParameter paramCouponCode = new SqlParameter("@CouponCode", SqlDbType.NVarChar, 20);
SqlParameter paramRequestUserSysNo = new SqlParameter("@RequestUserSysNo", SqlDbType.Int, 4);
SqlParameter paramRequestTime = new SqlParameter("@RequestTime", SqlDbType.DateTime);
SqlParameter paramAuditUserSysNo = new SqlParameter("@AuditUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAuditTime = new SqlParameter("@AuditTime", SqlDbType.DateTime);
SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4);
SqlParameter paramBatchNo = new SqlParameter("@BatchNo", SqlDbType.Int, 4);
SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 200);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramEXECSql = new SqlParameter("@EXECSql", SqlDbType.Text, 0);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.CustomerSysNo != AppConst.IntNull)
{
paramCustomerSysNo.Value = oParam.CustomerSysNo;
}
else
{
paramCustomerSysNo.Value = System.DBNull.Value;
}
if (oParam.CouponCode != AppConst.StringNull)
{
paramCouponCode.Value = oParam.CouponCode;
}
else
{
paramCouponCode.Value = System.DBNull.Value;
}
if (oParam.RequestUserSysNo != AppConst.IntNull)
{
paramRequestUserSysNo.Value = oParam.RequestUserSysNo;
}
else
{
paramRequestUserSysNo.Value = System.DBNull.Value;
}
if (oParam.RequestTime != AppConst.DateTimeNull)
{
paramRequestTime.Value = oParam.RequestTime;
}
else
{
paramRequestTime.Value = System.DBNull.Value;
}
if (oParam.AuditUserSysNo != AppConst.IntNull)
{
paramAuditUserSysNo.Value = oParam.AuditUserSysNo;
}
else
{
paramAuditUserSysNo.Value = System.DBNull.Value;
}
if (oParam.AuditTime != AppConst.DateTimeNull)
{
paramAuditTime.Value = oParam.AuditTime;
}
else
{
paramAuditTime.Value = System.DBNull.Value;
}
if (oParam.SOSysNo != AppConst.IntNull)
{
paramSOSysNo.Value = oParam.SOSysNo;
}
else
{
paramSOSysNo.Value = System.DBNull.Value;
}
if (oParam.BatchNo != AppConst.IntNull)
{
paramBatchNo.Value = oParam.BatchNo;
}
else
{
paramBatchNo.Value = System.DBNull.Value;
}
if (oParam.Note != AppConst.StringNull)
{
paramNote.Value = oParam.Note;
}
else
{
paramNote.Value = System.DBNull.Value;
}
if (oParam.Status != AppConst.IntNull)
{
paramStatus.Value = oParam.Status;
}
else
{
paramStatus.Value = System.DBNull.Value;
}
if (oParam.EXECSql != AppConst.StringNull)
{
paramEXECSql.Value = oParam.EXECSql;
}
else
{
paramEXECSql.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramCustomerSysNo);
cmd.Parameters.Add(paramCouponCode);
cmd.Parameters.Add(paramRequestUserSysNo);
cmd.Parameters.Add(paramRequestTime);
cmd.Parameters.Add(paramAuditUserSysNo);
cmd.Parameters.Add(paramAuditTime);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramBatchNo);
cmd.Parameters.Add(paramNote);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramEXECSql);
return(SqlHelper.ExecuteNonQuery(cmd));
}
