public int Update(ReviewComplainInfo oParam)
{
string sql = @"UPDATE Review_Complain SET
ReviewSysNo=@ReviewSysNo, ComplainContent=@ComplainContent,
CreateUserType=@CreateUserType, CreateUserSysNo=@CreateUserSysNo,
CreateDate=@CreateDate
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramReviewSysNo = new SqlParameter("@ReviewSysNo", SqlDbType.Int, 4);
SqlParameter paramComplainContent = new SqlParameter("@ComplainContent", SqlDbType.NVarChar, 1000);
SqlParameter paramCreateUserType = new SqlParameter("@CreateUserType", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateDate = new SqlParameter("@CreateDate", SqlDbType.DateTime);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.ReviewSysNo != AppConst.IntNull)
paramReviewSysNo.Value = oParam.ReviewSysNo;
else
paramReviewSysNo.Value = System.DBNull.Value;
if (oParam.ComplainContent != AppConst.StringNull)
paramComplainContent.Value = oParam.ComplainContent;
else
paramComplainContent.Value = System.DBNull.Value;
if (oParam.CreateUserType != AppConst.IntNull)
paramCreateUserType.Value = oParam.CreateUserType;
else
paramCreateUserType.Value = System.DBNull.Value;
if (oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
if (oParam.CreateDate != AppConst.DateTimeNull)
paramCreateDate.Value = oParam.CreateDate;
else
paramCreateDate.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramReviewSysNo);
cmd.Parameters.Add(paramComplainContent);
cmd.Parameters.Add(paramCreateUserType);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateDate);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(ReviewComplainInfo oParam)
{
string sql = @"INSERT INTO Review_Complain
(
ReviewSysNo, ComplainContent, CreateUserType, CreateUserSysNo,
CreateDate
)
VALUES (
@ReviewSysNo, @ComplainContent, @CreateUserType, @CreateUserSysNo,
@CreateDate
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramReviewSysNo = new SqlParameter("@ReviewSysNo", SqlDbType.Int, 4);
SqlParameter paramComplainContent = new SqlParameter("@ComplainContent", SqlDbType.NVarChar, 1000);
SqlParameter paramCreateUserType = new SqlParameter("@CreateUserType", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateDate = new SqlParameter("@CreateDate", SqlDbType.DateTime);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.ReviewSysNo != AppConst.IntNull)
paramReviewSysNo.Value = oParam.ReviewSysNo;
else
paramReviewSysNo.Value = System.DBNull.Value;
if (oParam.ComplainContent != AppConst.StringNull)
paramComplainContent.Value = oParam.ComplainContent;
else
paramComplainContent.Value = System.DBNull.Value;
if (oParam.CreateUserType != AppConst.IntNull)
paramCreateUserType.Value = oParam.CreateUserType;
else
paramCreateUserType.Value = System.DBNull.Value;
if (oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
if (oParam.CreateDate != AppConst.DateTimeNull)
paramCreateDate.Value = oParam.CreateDate;
else
paramCreateDate.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramReviewSysNo);
cmd.Parameters.Add(paramComplainContent);
cmd.Parameters.Add(paramCreateUserType);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateDate);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
public void AddNewReviewComplain(ReviewComplainInfo oParam)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
string sql = @"select * from review_complain where reviewSysNo=" + oParam.ReviewSysNo + " and createUserType=" + oParam.CreateUserType + " and createUserSysNo=" + oParam.CreateUserSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("�����ظ��ύ");
int iInsert = InsertReviewComplain(oParam);
if (iInsert == 0)
throw new BizException("�ύʧ��");
sql = "update review_master set totalcomplaincount=totalcomplaincount+1 where sysno=" + oParam.ReviewSysNo;
SqlHelper.ExecuteNonQuery(sql);
scope.Complete();
}
}
private void map(ReviewComplainInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.ReviewSysNo = Util.TrimIntNull(tempdr["ReviewSysNo"]);
oParam.ComplainContent = Util.TrimNull(tempdr["ComplainContent"]);
oParam.CreateUserType = Util.TrimIntNull(tempdr["CreateUserType"]);
oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]);
oParam.CreateDate = Util.TrimDateNull(tempdr["CreateDate"]);
}
public int UpdateReviewComplain(ReviewComplainInfo oParam)
{
return new ReviewComplainDac().Update(oParam);
}
public int InsertReviewComplain(ReviewComplainInfo oParam)
{
return new ReviewComplainDac().Insert(oParam);
}