private void map(ReviewReplyInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.ReviewSysNo = Util.TrimIntNull(tempdr["ReviewSysNo"]);
oParam.ReplyContent = Util.TrimNull(tempdr["ReplyContent"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
oParam.CreateUserType = Util.TrimIntNull(tempdr["CreateUserType"]);
oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]);
oParam.CreateDate = Util.TrimDateNull(tempdr["CreateDate"]);
oParam.LastEditUserSysNo = Util.TrimIntNull(tempdr["LastEditUserSysNo"]);
oParam.LastEditDate = Util.TrimDateNull(tempdr["LastEditDate"]);
}
public int UpdateReviewReply(ReviewReplyInfo oParam)
{
return new ReviewReplyDac().Update(oParam);
}
public ReviewReplyInfo LoadReviewReply(int ReviewReplySysNo)
{
string sql = "select * from review_reply where sysno=" + ReviewReplySysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
ReviewReplyInfo o = new ReviewReplyInfo();
map(o, ds.Tables[0].Rows[0]);
return o;
}
else
return null;
}
public int InsertReviewReply(ReviewReplyInfo oParam)
{
return new ReviewReplyDac().Insert(oParam);
}
public int Update(ReviewReplyInfo oParam)
{
string sql = @"UPDATE Review_Reply SET
ReviewSysNo=@ReviewSysNo, ReplyContent=@ReplyContent,
Status=@Status, CreateUserType=@CreateUserType,
CreateUserSysNo=@CreateUserSysNo, CreateDate=@CreateDate,
LastEditUserSysNo=@LastEditUserSysNo, LastEditDate=@LastEditDate
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 paramReplyContent = new SqlParameter("@ReplyContent", SqlDbType.NVarChar, 1000);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramCreateUserType = new SqlParameter("@CreateUserType", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateDate = new SqlParameter("@CreateDate", SqlDbType.DateTime);
SqlParameter paramLastEditUserSysNo = new SqlParameter("@LastEditUserSysNo", SqlDbType.Int, 4);
SqlParameter paramLastEditDate = new SqlParameter("@LastEditDate", 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.ReplyContent != AppConst.StringNull)
paramReplyContent.Value = oParam.ReplyContent;
else
paramReplyContent.Value = System.DBNull.Value;
if (oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.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;
if (oParam.LastEditUserSysNo != AppConst.IntNull)
paramLastEditUserSysNo.Value = oParam.LastEditUserSysNo;
else
paramLastEditUserSysNo.Value = System.DBNull.Value;
if (oParam.LastEditDate != AppConst.DateTimeNull)
paramLastEditDate.Value = oParam.LastEditDate;
else
paramLastEditDate.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramReviewSysNo);
cmd.Parameters.Add(paramReplyContent);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramCreateUserType);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateDate);
cmd.Parameters.Add(paramLastEditUserSysNo);
cmd.Parameters.Add(paramLastEditDate);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(ReviewReplyInfo oParam)
{
string sql = @"INSERT INTO Review_Reply
(
ReviewSysNo, ReplyContent, Status, CreateUserType,
CreateUserSysNo, CreateDate, LastEditUserSysNo, LastEditDate
)
VALUES (
@ReviewSysNo, @ReplyContent, @Status, @CreateUserType,
@CreateUserSysNo, @CreateDate, @LastEditUserSysNo, @LastEditDate
);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 paramReplyContent = new SqlParameter("@ReplyContent", SqlDbType.NVarChar, 1000);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramCreateUserType = new SqlParameter("@CreateUserType", SqlDbType.Int, 4);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateDate = new SqlParameter("@CreateDate", SqlDbType.DateTime);
SqlParameter paramLastEditUserSysNo = new SqlParameter("@LastEditUserSysNo", SqlDbType.Int, 4);
SqlParameter paramLastEditDate = new SqlParameter("@LastEditDate", SqlDbType.DateTime);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.ReviewSysNo != AppConst.IntNull)
paramReviewSysNo.Value = oParam.ReviewSysNo;
else
paramReviewSysNo.Value = System.DBNull.Value;
if (oParam.ReplyContent != AppConst.StringNull)
paramReplyContent.Value = oParam.ReplyContent;
else
paramReplyContent.Value = System.DBNull.Value;
if (oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.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;
if (oParam.LastEditUserSysNo != AppConst.IntNull)
paramLastEditUserSysNo.Value = oParam.LastEditUserSysNo;
else
paramLastEditUserSysNo.Value = System.DBNull.Value;
if (oParam.LastEditDate != AppConst.DateTimeNull)
paramLastEditDate.Value = oParam.LastEditDate;
else
paramLastEditDate.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramReviewSysNo);
cmd.Parameters.Add(paramReplyContent);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramCreateUserType);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateDate);
cmd.Parameters.Add(paramLastEditUserSysNo);
cmd.Parameters.Add(paramLastEditDate);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
