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