public int Update(QuestionnaireSurveyInfo oParam)
{
string sql = @"UPDATE QuestionnaireSurvey SET
BatchNo=@BatchNo, Subject1=@Subject1,
Subject2=@Subject2, Subject3=@Subject3,
Subject4=@Subject4, Subject5=@Subject5,
Subject6=@Subject6, Subject7=@Subject7,
Subject8=@Subject8, Subject9=@Subject9,
Subject10=@Subject10, Subject11=@Subject11,
Subject12=@Subject12, Subject13=@Subject13,
Subject14=@Subject14, Subject15=@Subject15,
Subject16=@Subject16, Subject17=@Subject17,
Subject18=@Subject18, Subject19=@Subject19,
Subject20=@Subject20, Suggest=@Suggest,
SubmitCustomerSysNo=@SubmitCustomerSysNo, SubmitTime=@SubmitTime,
ReplyNote=@ReplyNote, ReplyUserSysNo=@ReplyUserSysNo,
ReplyTime=@ReplyTime
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramBatchNo = new SqlParameter("@BatchNo", SqlDbType.Int, 4);
SqlParameter paramSubject1 = new SqlParameter("@Subject1", SqlDbType.NVarChar, 20);
SqlParameter paramSubject2 = new SqlParameter("@Subject2", SqlDbType.NVarChar, 20);
SqlParameter paramSubject3 = new SqlParameter("@Subject3", SqlDbType.NVarChar, 20);
SqlParameter paramSubject4 = new SqlParameter("@Subject4", SqlDbType.NVarChar, 20);
SqlParameter paramSubject5 = new SqlParameter("@Subject5", SqlDbType.NVarChar, 20);
SqlParameter paramSubject6 = new SqlParameter("@Subject6", SqlDbType.NVarChar, 20);
SqlParameter paramSubject7 = new SqlParameter("@Subject7", SqlDbType.NVarChar, 20);
SqlParameter paramSubject8 = new SqlParameter("@Subject8", SqlDbType.NVarChar, 20);
SqlParameter paramSubject9 = new SqlParameter("@Subject9", SqlDbType.NVarChar, 20);
SqlParameter paramSubject10 = new SqlParameter("@Subject10", SqlDbType.NVarChar, 20);
SqlParameter paramSubject11 = new SqlParameter("@Subject11", SqlDbType.NVarChar, 20);
SqlParameter paramSubject12 = new SqlParameter("@Subject12", SqlDbType.NVarChar, 20);
SqlParameter paramSubject13 = new SqlParameter("@Subject13", SqlDbType.NVarChar, 20);
SqlParameter paramSubject14 = new SqlParameter("@Subject14", SqlDbType.NVarChar, 20);
SqlParameter paramSubject15 = new SqlParameter("@Subject15", SqlDbType.NVarChar, 20);
SqlParameter paramSubject16 = new SqlParameter("@Subject16", SqlDbType.NVarChar, 20);
SqlParameter paramSubject17 = new SqlParameter("@Subject17", SqlDbType.NVarChar, 20);
SqlParameter paramSubject18 = new SqlParameter("@Subject18", SqlDbType.NVarChar, 20);
SqlParameter paramSubject19 = new SqlParameter("@Subject19", SqlDbType.NVarChar, 20);
SqlParameter paramSubject20 = new SqlParameter("@Subject20", SqlDbType.NVarChar, 20);
SqlParameter paramSuggest = new SqlParameter("@Suggest", SqlDbType.NVarChar, 200);
SqlParameter paramSubmitCustomerSysNo = new SqlParameter("@SubmitCustomerSysNo", SqlDbType.Int, 4);
SqlParameter paramSubmitTime = new SqlParameter("@SubmitTime", SqlDbType.DateTime);
SqlParameter paramReplyNote = new SqlParameter("@ReplyNote", SqlDbType.NVarChar, 200);
SqlParameter paramReplyUserSysNo = new SqlParameter("@ReplyUserSysNo", SqlDbType.Int, 4);
SqlParameter paramReplyTime = new SqlParameter("@ReplyTime", SqlDbType.DateTime);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.BatchNo != AppConst.IntNull)
paramBatchNo.Value = oParam.BatchNo;
else
paramBatchNo.Value = System.DBNull.Value;
if (oParam.Subject1 != AppConst.StringNull)
paramSubject1.Value = oParam.Subject1;
else
paramSubject1.Value = System.DBNull.Value;
if (oParam.Subject2 != AppConst.StringNull)
paramSubject2.Value = oParam.Subject2;
else
paramSubject2.Value = System.DBNull.Value;
if (oParam.Subject3 != AppConst.StringNull)
paramSubject3.Value = oParam.Subject3;
else
paramSubject3.Value = System.DBNull.Value;
if (oParam.Subject4 != AppConst.StringNull)
paramSubject4.Value = oParam.Subject4;
else
paramSubject4.Value = System.DBNull.Value;
if (oParam.Subject5 != AppConst.StringNull)
paramSubject5.Value = oParam.Subject5;
else
paramSubject5.Value = System.DBNull.Value;
if (oParam.Subject6 != AppConst.StringNull)
paramSubject6.Value = oParam.Subject6;
else
paramSubject6.Value = System.DBNull.Value;
if (oParam.Subject7 != AppConst.StringNull)
paramSubject7.Value = oParam.Subject7;
else
paramSubject7.Value = System.DBNull.Value;
if (oParam.Subject8 != AppConst.StringNull)
paramSubject8.Value = oParam.Subject8;
else
paramSubject8.Value = System.DBNull.Value;
if (oParam.Subject9 != AppConst.StringNull)
paramSubject9.Value = oParam.Subject9;
else
paramSubject9.Value = System.DBNull.Value;
if (oParam.Subject10 != AppConst.StringNull)
paramSubject10.Value = oParam.Subject10;
else
paramSubject10.Value = System.DBNull.Value;
if (oParam.Subject11 != AppConst.StringNull)
paramSubject11.Value = oParam.Subject11;
else
paramSubject11.Value = System.DBNull.Value;
if (oParam.Subject12 != AppConst.StringNull)
paramSubject12.Value = oParam.Subject12;
else
paramSubject12.Value = System.DBNull.Value;
if (oParam.Subject13 != AppConst.StringNull)
paramSubject13.Value = oParam.Subject13;
else
paramSubject13.Value = System.DBNull.Value;
if (oParam.Subject14 != AppConst.StringNull)
paramSubject14.Value = oParam.Subject14;
else
paramSubject14.Value = System.DBNull.Value;
if (oParam.Subject15 != AppConst.StringNull)
paramSubject15.Value = oParam.Subject15;
else
paramSubject15.Value = System.DBNull.Value;
if (oParam.Subject16 != AppConst.StringNull)
paramSubject16.Value = oParam.Subject16;
else
paramSubject16.Value = System.DBNull.Value;
if (oParam.Subject17 != AppConst.StringNull)
paramSubject17.Value = oParam.Subject17;
else
paramSubject17.Value = System.DBNull.Value;
if (oParam.Subject18 != AppConst.StringNull)
paramSubject18.Value = oParam.Subject18;
else
paramSubject18.Value = System.DBNull.Value;
if (oParam.Subject19 != AppConst.StringNull)
paramSubject19.Value = oParam.Subject19;
else
paramSubject19.Value = System.DBNull.Value;
if (oParam.Subject20 != AppConst.StringNull)
paramSubject20.Value = oParam.Subject20;
else
paramSubject20.Value = System.DBNull.Value;
if (oParam.Suggest != AppConst.StringNull)
paramSuggest.Value = oParam.Suggest;
else
paramSuggest.Value = System.DBNull.Value;
if (oParam.SubmitCustomerSysNo != AppConst.IntNull)
paramSubmitCustomerSysNo.Value = oParam.SubmitCustomerSysNo;
else
paramSubmitCustomerSysNo.Value = System.DBNull.Value;
if (oParam.SubmitTime != AppConst.DateTimeNull)
paramSubmitTime.Value = oParam.SubmitTime;
else
paramSubmitTime.Value = System.DBNull.Value;
if (oParam.ReplyNote != AppConst.StringNull)
paramReplyNote.Value = oParam.ReplyNote;
else
paramReplyNote.Value = System.DBNull.Value;
if (oParam.ReplyUserSysNo != AppConst.IntNull)
paramReplyUserSysNo.Value = oParam.ReplyUserSysNo;
else
paramReplyUserSysNo.Value = System.DBNull.Value;
if (oParam.ReplyTime != AppConst.DateTimeNull)
paramReplyTime.Value = oParam.ReplyTime;
else
paramReplyTime.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramBatchNo);
cmd.Parameters.Add(paramSubject1);
cmd.Parameters.Add(paramSubject2);
cmd.Parameters.Add(paramSubject3);
cmd.Parameters.Add(paramSubject4);
cmd.Parameters.Add(paramSubject5);
cmd.Parameters.Add(paramSubject6);
cmd.Parameters.Add(paramSubject7);
cmd.Parameters.Add(paramSubject8);
cmd.Parameters.Add(paramSubject9);
cmd.Parameters.Add(paramSubject10);
cmd.Parameters.Add(paramSubject11);
cmd.Parameters.Add(paramSubject12);
cmd.Parameters.Add(paramSubject13);
cmd.Parameters.Add(paramSubject14);
cmd.Parameters.Add(paramSubject15);
cmd.Parameters.Add(paramSubject16);
cmd.Parameters.Add(paramSubject17);
cmd.Parameters.Add(paramSubject18);
cmd.Parameters.Add(paramSubject19);
cmd.Parameters.Add(paramSubject20);
cmd.Parameters.Add(paramSuggest);
cmd.Parameters.Add(paramSubmitCustomerSysNo);
cmd.Parameters.Add(paramSubmitTime);
cmd.Parameters.Add(paramReplyNote);
cmd.Parameters.Add(paramReplyUserSysNo);
cmd.Parameters.Add(paramReplyTime);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(QuestionnaireSurveyInfo oParam)
{
string sql = @"INSERT INTO QuestionnaireSurvey
(
BatchNo, Subject1, Subject2, Subject3,
Subject4, Subject5, Subject6, Subject7,
Subject8, Subject9, Subject10, Subject11,
Subject12, Subject13, Subject14, Subject15,
Subject16, Subject17, Subject18, Subject19,
Subject20, Suggest, SubmitCustomerSysNo, SubmitTime,
ReplyNote, ReplyUserSysNo, ReplyTime
)
VALUES (
@BatchNo, @Subject1, @Subject2, @Subject3,
@Subject4, @Subject5, @Subject6, @Subject7,
@Subject8, @Subject9, @Subject10, @Subject11,
@Subject12, @Subject13, @Subject14, @Subject15,
@Subject16, @Subject17, @Subject18, @Subject19,
@Subject20, @Suggest, @SubmitCustomerSysNo, @SubmitTime,
@ReplyNote, @ReplyUserSysNo, @ReplyTime
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramBatchNo = new SqlParameter("@BatchNo", SqlDbType.Int, 4);
SqlParameter paramSubject1 = new SqlParameter("@Subject1", SqlDbType.NVarChar, 20);
SqlParameter paramSubject2 = new SqlParameter("@Subject2", SqlDbType.NVarChar, 20);
SqlParameter paramSubject3 = new SqlParameter("@Subject3", SqlDbType.NVarChar, 20);
SqlParameter paramSubject4 = new SqlParameter("@Subject4", SqlDbType.NVarChar, 20);
SqlParameter paramSubject5 = new SqlParameter("@Subject5", SqlDbType.NVarChar, 20);
SqlParameter paramSubject6 = new SqlParameter("@Subject6", SqlDbType.NVarChar, 20);
SqlParameter paramSubject7 = new SqlParameter("@Subject7", SqlDbType.NVarChar, 20);
SqlParameter paramSubject8 = new SqlParameter("@Subject8", SqlDbType.NVarChar, 20);
SqlParameter paramSubject9 = new SqlParameter("@Subject9", SqlDbType.NVarChar, 20);
SqlParameter paramSubject10 = new SqlParameter("@Subject10", SqlDbType.NVarChar, 20);
SqlParameter paramSubject11 = new SqlParameter("@Subject11", SqlDbType.NVarChar, 20);
SqlParameter paramSubject12 = new SqlParameter("@Subject12", SqlDbType.NVarChar, 20);
SqlParameter paramSubject13 = new SqlParameter("@Subject13", SqlDbType.NVarChar, 20);
SqlParameter paramSubject14 = new SqlParameter("@Subject14", SqlDbType.NVarChar, 20);
SqlParameter paramSubject15 = new SqlParameter("@Subject15", SqlDbType.NVarChar, 20);
SqlParameter paramSubject16 = new SqlParameter("@Subject16", SqlDbType.NVarChar, 20);
SqlParameter paramSubject17 = new SqlParameter("@Subject17", SqlDbType.NVarChar, 20);
SqlParameter paramSubject18 = new SqlParameter("@Subject18", SqlDbType.NVarChar, 20);
SqlParameter paramSubject19 = new SqlParameter("@Subject19", SqlDbType.NVarChar, 20);
SqlParameter paramSubject20 = new SqlParameter("@Subject20", SqlDbType.NVarChar, 20);
SqlParameter paramSuggest = new SqlParameter("@Suggest", SqlDbType.NVarChar, 200);
SqlParameter paramSubmitCustomerSysNo = new SqlParameter("@SubmitCustomerSysNo", SqlDbType.Int, 4);
SqlParameter paramSubmitTime = new SqlParameter("@SubmitTime", SqlDbType.DateTime);
SqlParameter paramReplyNote = new SqlParameter("@ReplyNote", SqlDbType.NVarChar, 200);
SqlParameter paramReplyUserSysNo = new SqlParameter("@ReplyUserSysNo", SqlDbType.Int, 4);
SqlParameter paramReplyTime = new SqlParameter("@ReplyTime", SqlDbType.DateTime);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.BatchNo != AppConst.IntNull)
paramBatchNo.Value = oParam.BatchNo;
else
paramBatchNo.Value = System.DBNull.Value;
if (oParam.Subject1 != AppConst.StringNull)
paramSubject1.Value = oParam.Subject1;
else
paramSubject1.Value = System.DBNull.Value;
if (oParam.Subject2 != AppConst.StringNull)
paramSubject2.Value = oParam.Subject2;
else
paramSubject2.Value = System.DBNull.Value;
if (oParam.Subject3 != AppConst.StringNull)
paramSubject3.Value = oParam.Subject3;
else
paramSubject3.Value = System.DBNull.Value;
if (oParam.Subject4 != AppConst.StringNull)
paramSubject4.Value = oParam.Subject4;
else
paramSubject4.Value = System.DBNull.Value;
if (oParam.Subject5 != AppConst.StringNull)
paramSubject5.Value = oParam.Subject5;
else
paramSubject5.Value = System.DBNull.Value;
if (oParam.Subject6 != AppConst.StringNull)
paramSubject6.Value = oParam.Subject6;
else
paramSubject6.Value = System.DBNull.Value;
if (oParam.Subject7 != AppConst.StringNull)
paramSubject7.Value = oParam.Subject7;
else
paramSubject7.Value = System.DBNull.Value;
if (oParam.Subject8 != AppConst.StringNull)
paramSubject8.Value = oParam.Subject8;
else
paramSubject8.Value = System.DBNull.Value;
if (oParam.Subject9 != AppConst.StringNull)
paramSubject9.Value = oParam.Subject9;
else
paramSubject9.Value = System.DBNull.Value;
if (oParam.Subject10 != AppConst.StringNull)
paramSubject10.Value = oParam.Subject10;
else
paramSubject10.Value = System.DBNull.Value;
if (oParam.Subject11 != AppConst.StringNull)
paramSubject11.Value = oParam.Subject11;
else
paramSubject11.Value = System.DBNull.Value;
if (oParam.Subject12 != AppConst.StringNull)
paramSubject12.Value = oParam.Subject12;
else
paramSubject12.Value = System.DBNull.Value;
if (oParam.Subject13 != AppConst.StringNull)
paramSubject13.Value = oParam.Subject13;
else
paramSubject13.Value = System.DBNull.Value;
if (oParam.Subject14 != AppConst.StringNull)
paramSubject14.Value = oParam.Subject14;
else
paramSubject14.Value = System.DBNull.Value;
if (oParam.Subject15 != AppConst.StringNull)
paramSubject15.Value = oParam.Subject15;
else
paramSubject15.Value = System.DBNull.Value;
if (oParam.Subject16 != AppConst.StringNull)
paramSubject16.Value = oParam.Subject16;
else
paramSubject16.Value = System.DBNull.Value;
if (oParam.Subject17 != AppConst.StringNull)
paramSubject17.Value = oParam.Subject17;
else
paramSubject17.Value = System.DBNull.Value;
if (oParam.Subject18 != AppConst.StringNull)
paramSubject18.Value = oParam.Subject18;
else
paramSubject18.Value = System.DBNull.Value;
if (oParam.Subject19 != AppConst.StringNull)
paramSubject19.Value = oParam.Subject19;
else
paramSubject19.Value = System.DBNull.Value;
if (oParam.Subject20 != AppConst.StringNull)
paramSubject20.Value = oParam.Subject20;
else
paramSubject20.Value = System.DBNull.Value;
if (oParam.Suggest != AppConst.StringNull)
paramSuggest.Value = oParam.Suggest;
else
paramSuggest.Value = System.DBNull.Value;
if (oParam.SubmitCustomerSysNo != AppConst.IntNull)
paramSubmitCustomerSysNo.Value = oParam.SubmitCustomerSysNo;
else
paramSubmitCustomerSysNo.Value = System.DBNull.Value;
if (oParam.SubmitTime != AppConst.DateTimeNull)
paramSubmitTime.Value = oParam.SubmitTime;
else
paramSubmitTime.Value = System.DBNull.Value;
if (oParam.ReplyNote != AppConst.StringNull)
paramReplyNote.Value = oParam.ReplyNote;
else
paramReplyNote.Value = System.DBNull.Value;
if (oParam.ReplyUserSysNo != AppConst.IntNull)
paramReplyUserSysNo.Value = oParam.ReplyUserSysNo;
else
paramReplyUserSysNo.Value = System.DBNull.Value;
if (oParam.ReplyTime != AppConst.DateTimeNull)
paramReplyTime.Value = oParam.ReplyTime;
else
paramReplyTime.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramBatchNo);
cmd.Parameters.Add(paramSubject1);
cmd.Parameters.Add(paramSubject2);
cmd.Parameters.Add(paramSubject3);
cmd.Parameters.Add(paramSubject4);
cmd.Parameters.Add(paramSubject5);
cmd.Parameters.Add(paramSubject6);
cmd.Parameters.Add(paramSubject7);
cmd.Parameters.Add(paramSubject8);
cmd.Parameters.Add(paramSubject9);
cmd.Parameters.Add(paramSubject10);
cmd.Parameters.Add(paramSubject11);
cmd.Parameters.Add(paramSubject12);
cmd.Parameters.Add(paramSubject13);
cmd.Parameters.Add(paramSubject14);
cmd.Parameters.Add(paramSubject15);
cmd.Parameters.Add(paramSubject16);
cmd.Parameters.Add(paramSubject17);
cmd.Parameters.Add(paramSubject18);
cmd.Parameters.Add(paramSubject19);
cmd.Parameters.Add(paramSubject20);
cmd.Parameters.Add(paramSuggest);
cmd.Parameters.Add(paramSubmitCustomerSysNo);
cmd.Parameters.Add(paramSubmitTime);
cmd.Parameters.Add(paramReplyNote);
cmd.Parameters.Add(paramReplyUserSysNo);
cmd.Parameters.Add(paramReplyTime);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
public QuestionnaireSurveyInfo LoadQuestionnaireSurvey(Hashtable paramHash)
{
DataSet ds = GetQuestionnaireSurveyList(paramHash);
if (Util.HasMoreRow(ds))
{
QuestionnaireSurveyInfo oInfo = new QuestionnaireSurveyInfo();
map(oInfo, ds.Tables[0].Rows[0]);
return oInfo;
}
else
return null;
}
private void map(QuestionnaireSurveyInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.BatchNo = Util.TrimIntNull(tempdr["BatchNo"]);
oParam.Subject1 = Util.TrimNull(tempdr["Subject1"]);
oParam.Subject2 = Util.TrimNull(tempdr["Subject2"]);
oParam.Subject3 = Util.TrimNull(tempdr["Subject3"]);
oParam.Subject4 = Util.TrimNull(tempdr["Subject4"]);
oParam.Subject5 = Util.TrimNull(tempdr["Subject5"]);
oParam.Subject6 = Util.TrimNull(tempdr["Subject6"]);
oParam.Subject7 = Util.TrimNull(tempdr["Subject7"]);
oParam.Subject8 = Util.TrimNull(tempdr["Subject8"]);
oParam.Subject9 = Util.TrimNull(tempdr["Subject9"]);
oParam.Subject10 = Util.TrimNull(tempdr["Subject10"]);
oParam.Subject11 = Util.TrimNull(tempdr["Subject11"]);
oParam.Subject12 = Util.TrimNull(tempdr["Subject12"]);
oParam.Subject13 = Util.TrimNull(tempdr["Subject13"]);
oParam.Subject14 = Util.TrimNull(tempdr["Subject14"]);
oParam.Subject15 = Util.TrimNull(tempdr["Subject15"]);
oParam.Subject16 = Util.TrimNull(tempdr["Subject16"]);
oParam.Subject17 = Util.TrimNull(tempdr["Subject17"]);
oParam.Subject18 = Util.TrimNull(tempdr["Subject18"]);
oParam.Subject19 = Util.TrimNull(tempdr["Subject19"]);
oParam.Subject20 = Util.TrimNull(tempdr["Subject20"]);
oParam.Suggest = Util.TrimNull(tempdr["Suggest"]);
oParam.SubmitCustomerSysNo = Util.TrimIntNull(tempdr["SubmitCustomerSysNo"]);
oParam.SubmitTime = Util.TrimDateNull(tempdr["SubmitTime"]);
oParam.ReplyNote = Util.TrimNull(tempdr["ReplyNote"]);
oParam.ReplyUserSysNo = Util.TrimIntNull(tempdr["ReplyUserSysNo"]);
oParam.ReplyTime = Util.TrimDateNull(tempdr["ReplyTime"]);
}
public void Insert(QuestionnaireSurveyInfo oParam)
{
string sql = "Select top 1 * from QuestionnaireSurvey Where SubmitCustomerSysNo = " + oParam.SubmitCustomerSysNo + " and BatchNo =" + oParam.BatchNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("���Ѿ��ύ��ORS�̳��û��ṹ���飬�����ٴ��ύ����л����ORS�̳ǵ�֧�֣�");
new QuestionnaireSurveyDac().Insert(oParam);
}
