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