/// <summary> /// 更新一条数据 /// </summary> public void Update(DigiPower.Onlinecol.Standard.Model.T_Question_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Question set "); strSql.Append("SingleProjectID=@SingleProjectID,"); strSql.Append("QuestionTypeCode=@QuestionTypeCode,"); strSql.Append("FileListID=@FileListID,"); strSql.Append("Title=@Title,"); strSql.Append("Description=@Description,"); strSql.Append("CreateUserID=@CreateUserID,"); strSql.Append("CreateUserName=@CreateUserName,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("AnswerCount=@AnswerCount,"); strSql.Append("ClickCount=@ClickCount,"); strSql.Append("AttachName=@AttachName,"); strSql.Append("AttachPath=@AttachPath,"); strSql.Append("ReadFlag=@ReadFlag,"); strSql.Append("DescriptionHtml=@DescriptionHtml"); strSql.Append(" where QuestionID=@QuestionID "); SqlParameter[] parameters = { new SqlParameter("@QuestionID", SqlDbType.Int,8), new SqlParameter("@SingleProjectID", SqlDbType.Int,8), new SqlParameter("@QuestionTypeCode", SqlDbType.NVarChar,100), new SqlParameter("@FileListID", SqlDbType.Int,8), new SqlParameter("@Title", SqlDbType.NVarChar,100), new SqlParameter("@Description", SqlDbType.NVarChar,4000), new SqlParameter("@CreateUserID", SqlDbType.Int,8), new SqlParameter("@CreateUserName", SqlDbType.NVarChar,50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@AnswerCount", SqlDbType.Int,8), new SqlParameter("@ClickCount", SqlDbType.Int,8), new SqlParameter("@AttachName", SqlDbType.NVarChar,250), new SqlParameter("@AttachPath", SqlDbType.NVarChar,250), new SqlParameter("@ReadFlag", SqlDbType.Bit,1), new SqlParameter("@DescriptionHtml", SqlDbType.NVarChar,4000)}; parameters[0].Value = model.QuestionID; parameters[1].Value = model.SingleProjectID; parameters[2].Value = model.QuestionTypeCode; parameters[3].Value = model.FileListID; parameters[4].Value = model.Title; parameters[5].Value = model.Description; parameters[6].Value = model.CreateUserID; parameters[7].Value = model.CreateUserName; parameters[8].Value = model.CreateDate; parameters[9].Value = model.AnswerCount; parameters[10].Value = model.ClickCount; parameters[11].Value = model.AttachName; parameters[12].Value = model.AttachPath; parameters[13].Value = model.ReadFlag; parameters[14].Value = model.DescriptionHtml; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DigiPower.Onlinecol.Standard.Model.T_Question_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Question("); strSql.Append("SingleProjectID,QuestionTypeCode,FileListID,Title,Description,CreateUserID,CreateUserName,CreateDate,AnswerCount,ClickCount,AttachName,AttachPath,ReadFlag,DescriptionHtml)"); strSql.Append(" values ("); strSql.Append("@SingleProjectID,@QuestionTypeCode,@FileListID,@Title,@Description,@CreateUserID,@CreateUserName,@CreateDate,@AnswerCount,@ClickCount,@AttachName,@AttachPath,@ReadFlag,@DescriptionHtml)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SingleProjectID", SqlDbType.Int,8), new SqlParameter("@QuestionTypeCode", SqlDbType.NVarChar,100), new SqlParameter("@FileListID", SqlDbType.Int,8), new SqlParameter("@Title", SqlDbType.NVarChar,100), new SqlParameter("@Description", SqlDbType.NVarChar,4000), new SqlParameter("@CreateUserID", SqlDbType.Int,8), new SqlParameter("@CreateUserName", SqlDbType.NVarChar,50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@AnswerCount", SqlDbType.Int,8), new SqlParameter("@ClickCount", SqlDbType.Int,8), new SqlParameter("@AttachName", SqlDbType.NVarChar,250), new SqlParameter("@AttachPath", SqlDbType.NVarChar,250), new SqlParameter("@ReadFlag", SqlDbType.Bit,1), new SqlParameter("@DescriptionHtml", SqlDbType.NVarChar,4000)}; parameters[0].Value = model.SingleProjectID; parameters[1].Value = model.QuestionTypeCode; parameters[2].Value = model.FileListID; parameters[3].Value = model.Title; parameters[4].Value = model.Description; parameters[5].Value = model.CreateUserID; parameters[6].Value = model.CreateUserName; parameters[7].Value = model.CreateDate; parameters[8].Value = model.AnswerCount; parameters[9].Value = model.ClickCount; parameters[10].Value = model.AttachName; parameters[11].Value = model.AttachPath; parameters[12].Value = model.ReadFlag; parameters[13].Value = model.DescriptionHtml; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 1; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DigiPower.Onlinecol.Standard.Model.T_Question_MDL GetModel(int QuestionID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 QuestionID,SingleProjectID,QuestionTypeCode,FileListID,Title,Description,CreateUserID,CreateUserName,CreateDate,AnswerCount,ClickCount,AttachName,AttachPath,ReadFlag,DescriptionHtml from T_Question "); strSql.Append(" where QuestionID=@QuestionID "); SqlParameter[] parameters = { new SqlParameter("@QuestionID", SqlDbType.Int,8)}; parameters[0].Value = QuestionID; DigiPower.Onlinecol.Standard.Model.T_Question_MDL model = new DigiPower.Onlinecol.Standard.Model.T_Question_MDL(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["QuestionID"].ToString() != "") { model.QuestionID = int.Parse(ds.Tables[0].Rows[0]["QuestionID"].ToString()); } if (ds.Tables[0].Rows[0]["SingleProjectID"].ToString() != "") { model.SingleProjectID = int.Parse(ds.Tables[0].Rows[0]["SingleProjectID"].ToString()); } if (ds.Tables[0].Rows[0]["FileListID"].ToString() != "") { model.FileListID = int.Parse(ds.Tables[0].Rows[0]["FileListID"].ToString()); } model.QuestionTypeCode = ds.Tables[0].Rows[0]["QuestionTypeCode"].ToString(); model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); model.Description = ds.Tables[0].Rows[0]["Description"].ToString(); if (ds.Tables[0].Rows[0]["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(ds.Tables[0].Rows[0]["CreateUserID"].ToString()); } model.CreateUserName = ds.Tables[0].Rows[0]["CreateUserName"].ToString(); if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString()); } if (ds.Tables[0].Rows[0]["AnswerCount"].ToString() != "") { model.AnswerCount = int.Parse(ds.Tables[0].Rows[0]["AnswerCount"].ToString()); } if (ds.Tables[0].Rows[0]["ClickCount"].ToString() != "") { model.ClickCount = int.Parse(ds.Tables[0].Rows[0]["ClickCount"].ToString()); } model.AttachName = ds.Tables[0].Rows[0]["AttachName"].ToString(); model.AttachPath = ds.Tables[0].Rows[0]["AttachPath"].ToString(); if (ds.Tables[0].Rows[0]["ReadFlag"].ToString() != "") { if ((ds.Tables[0].Rows[0]["ReadFlag"].ToString() == "1") || (ds.Tables[0].Rows[0]["ReadFlag"].ToString().ToLower() == "true")) { model.ReadFlag = true; } else { model.ReadFlag = false; } } model.DescriptionHtml = ds.Tables[0].Rows[0]["DescriptionHtml"].ToString(); return model; } else { return null; } }