/// <summary> /// 对象实体绑定数据 /// </summary> public ECommerce.Admin.Model.DevelopAnswer ReaderBind(IDataReader dataReader) { ECommerce.Admin.Model.DevelopAnswer model = new ECommerce.Admin.Model.DevelopAnswer(); object ojb; ojb = dataReader["ID"]; if (ojb != null && ojb != DBNull.Value) { model.ID = Convert.ToInt32(ojb); } model.ComID = dataReader["ComID"].ToString(); ojb = dataReader["UId"]; if (ojb != null && ojb != DBNull.Value) { model.UId = Convert.ToInt32(ojb); } model.Question_answer_7 = dataReader["Question_answer_7"].ToString(); model.Question_answer_8 = dataReader["Question_answer_8"].ToString(); model.Question_answer_9 = dataReader["Question_answer_9"].ToString(); model.Question_answer_10 = dataReader["Question_answer_10"].ToString(); model.Question_answer_11 = dataReader["Question_answer_11"].ToString(); model.Question_answer_12 = dataReader["Question_answer_12"].ToString(); model.Question_answer_13 = dataReader["Question_answer_13"].ToString(); model.Question_answer_14 = dataReader["Question_answer_14"].ToString(); model.Question_answer_15 = dataReader["Question_answer_15"].ToString(); model.Question_answer_16 = dataReader["Question_answer_16"].ToString(); model.Question_answer_17 = dataReader["Question_answer_17"].ToString(); model.Question_answer_18 = dataReader["Question_answer_18"].ToString(); model.Question_answer_19 = dataReader["Question_answer_19"].ToString(); model.Question_answer_20 = dataReader["Question_answer_20"].ToString(); model.Question_answer_21 = dataReader["Question_answer_21"].ToString(); model.Question_answer_22 = dataReader["Question_answer_22"].ToString(); model.Question_answer_23 = dataReader["Question_answer_23"].ToString(); model.Question_answer_24 = dataReader["Question_answer_24"].ToString(); ojb = dataReader["CreateDate"]; if (ojb != null && ojb != DBNull.Value) { model.CreateDate = Convert.ToDateTime(ojb); } ojb = dataReader["UpdateDate"]; if (ojb != null && ojb != DBNull.Value) { model.UpdateDate = Convert.ToDateTime(ojb); } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.DevelopAnswer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DevelopAnswer("); strSql.Append("ComID,UId,Question_answer_7,Question_answer_8,Question_answer_9,Question_answer_10,Question_answer_11,Question_answer_12,Question_answer_13,Question_answer_14,Question_answer_15,Question_answer_16,Question_answer_17,Question_answer_18,Question_answer_19,Question_answer_20,Question_answer_21,Question_answer_22,Question_answer_23,Question_answer_24,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@ComID,@UId,@Question_answer_7,@Question_answer_8,@Question_answer_9,@Question_answer_10,@Question_answer_11,@Question_answer_12,@Question_answer_13,@Question_answer_14,@Question_answer_15,@Question_answer_16,@Question_answer_17,@Question_answer_18,@Question_answer_19,@Question_answer_20,@Question_answer_21,@Question_answer_22,@Question_answer_23,@Question_answer_24,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ComID", DbType.String, model.ComID); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "Question_answer_7", DbType.String, model.Question_answer_7); db.AddInParameter(dbCommand, "Question_answer_8", DbType.String, model.Question_answer_8); db.AddInParameter(dbCommand, "Question_answer_9", DbType.String, model.Question_answer_9); db.AddInParameter(dbCommand, "Question_answer_10", DbType.String, model.Question_answer_10); db.AddInParameter(dbCommand, "Question_answer_11", DbType.String, model.Question_answer_11); db.AddInParameter(dbCommand, "Question_answer_12", DbType.String, model.Question_answer_12); db.AddInParameter(dbCommand, "Question_answer_13", DbType.String, model.Question_answer_13); db.AddInParameter(dbCommand, "Question_answer_14", DbType.String, model.Question_answer_14); db.AddInParameter(dbCommand, "Question_answer_15", DbType.String, model.Question_answer_15); db.AddInParameter(dbCommand, "Question_answer_16", DbType.String, model.Question_answer_16); db.AddInParameter(dbCommand, "Question_answer_17", DbType.String, model.Question_answer_17); db.AddInParameter(dbCommand, "Question_answer_18", DbType.String, model.Question_answer_18); db.AddInParameter(dbCommand, "Question_answer_19", DbType.String, model.Question_answer_19); db.AddInParameter(dbCommand, "Question_answer_20", DbType.String, model.Question_answer_20); db.AddInParameter(dbCommand, "Question_answer_21", DbType.String, model.Question_answer_21); db.AddInParameter(dbCommand, "Question_answer_22", DbType.String, model.Question_answer_22); db.AddInParameter(dbCommand, "Question_answer_23", DbType.String, model.Question_answer_23); db.AddInParameter(dbCommand, "Question_answer_24", DbType.String, model.Question_answer_24); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public ECommerce.Admin.Model.DevelopAnswer GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,ComID,UId,Question_answer_7,Question_answer_8,Question_answer_9,Question_answer_10,Question_answer_11,Question_answer_12,Question_answer_13,Question_answer_14,Question_answer_15,Question_answer_16,Question_answer_17,Question_answer_18,Question_answer_19,Question_answer_20,Question_answer_21,Question_answer_22,Question_answer_23,Question_answer_24,CreateDate,UpdateDate from DevelopAnswer "); strSql.Append(" where ID=@ID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ID", DbType.Int32, ID); ECommerce.Admin.Model.DevelopAnswer model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ECommerce.Admin.Model.DevelopAnswer DataRowToModel(DataRow row) { ECommerce.Admin.Model.DevelopAnswer model = new ECommerce.Admin.Model.DevelopAnswer(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = Convert.ToInt32(row["ID"].ToString()); } if (row["ComID"] != null) { model.ComID = row["ComID"].ToString(); } if (row["UId"] != null && row["UId"].ToString() != "") { model.UId = Convert.ToInt32(row["UId"].ToString()); } if (row["Question_answer_7"] != null) { model.Question_answer_7 = row["Question_answer_7"].ToString(); } if (row["Question_answer_8"] != null) { model.Question_answer_8 = row["Question_answer_8"].ToString(); } if (row["Question_answer_9"] != null) { model.Question_answer_9 = row["Question_answer_9"].ToString(); } if (row["Question_answer_10"] != null) { model.Question_answer_10 = row["Question_answer_10"].ToString(); } if (row["Question_answer_11"] != null) { model.Question_answer_11 = row["Question_answer_11"].ToString(); } if (row["Question_answer_12"] != null) { model.Question_answer_12 = row["Question_answer_12"].ToString(); } if (row["Question_answer_13"] != null) { model.Question_answer_13 = row["Question_answer_13"].ToString(); } if (row["Question_answer_14"] != null) { model.Question_answer_14 = row["Question_answer_14"].ToString(); } if (row["Question_answer_15"] != null) { model.Question_answer_15 = row["Question_answer_15"].ToString(); } if (row["Question_answer_16"] != null) { model.Question_answer_16 = row["Question_answer_16"].ToString(); } if (row["Question_answer_17"] != null) { model.Question_answer_17 = row["Question_answer_17"].ToString(); } if (row["Question_answer_18"] != null) { model.Question_answer_18 = row["Question_answer_18"].ToString(); } if (row["Question_answer_19"] != null) { model.Question_answer_19 = row["Question_answer_19"].ToString(); } if (row["Question_answer_20"] != null) { model.Question_answer_20 = row["Question_answer_20"].ToString(); } if (row["Question_answer_21"] != null) { model.Question_answer_21 = row["Question_answer_21"].ToString(); } if (row["Question_answer_22"] != null) { model.Question_answer_22 = row["Question_answer_22"].ToString(); } if (row["Question_answer_23"] != null) { model.Question_answer_23 = row["Question_answer_23"].ToString(); } if (row["Question_answer_24"] != null) { model.Question_answer_24 = row["Question_answer_24"].ToString(); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = Convert.ToDateTime(row["CreateDate"].ToString()); } if (row["UpdateDate"] != null && row["UpdateDate"].ToString() != "") { model.UpdateDate = Convert.ToDateTime(row["UpdateDate"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ECommerce.Admin.Model.DevelopAnswer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DevelopAnswer set "); strSql.Append("ComID=@ComID,"); strSql.Append("UId=@UId,"); strSql.Append("Question_answer_7=@Question_answer_7,"); strSql.Append("Question_answer_8=@Question_answer_8,"); strSql.Append("Question_answer_9=@Question_answer_9,"); strSql.Append("Question_answer_10=@Question_answer_10,"); strSql.Append("Question_answer_11=@Question_answer_11,"); strSql.Append("Question_answer_12=@Question_answer_12,"); strSql.Append("Question_answer_13=@Question_answer_13,"); strSql.Append("Question_answer_14=@Question_answer_14,"); strSql.Append("Question_answer_15=@Question_answer_15,"); strSql.Append("Question_answer_16=@Question_answer_16,"); strSql.Append("Question_answer_17=@Question_answer_17,"); strSql.Append("Question_answer_18=@Question_answer_18,"); strSql.Append("Question_answer_19=@Question_answer_19,"); strSql.Append("Question_answer_20=@Question_answer_20,"); strSql.Append("Question_answer_21=@Question_answer_21,"); strSql.Append("Question_answer_22=@Question_answer_22,"); strSql.Append("Question_answer_23=@Question_answer_23,"); strSql.Append("Question_answer_24=@Question_answer_24,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("UpdateDate=@UpdateDate"); strSql.Append(" where ID=@ID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ID", DbType.Int32, model.ID); db.AddInParameter(dbCommand, "ComID", DbType.String, model.ComID); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "Question_answer_7", DbType.String, model.Question_answer_7); db.AddInParameter(dbCommand, "Question_answer_8", DbType.String, model.Question_answer_8); db.AddInParameter(dbCommand, "Question_answer_9", DbType.String, model.Question_answer_9); db.AddInParameter(dbCommand, "Question_answer_10", DbType.String, model.Question_answer_10); db.AddInParameter(dbCommand, "Question_answer_11", DbType.String, model.Question_answer_11); db.AddInParameter(dbCommand, "Question_answer_12", DbType.String, model.Question_answer_12); db.AddInParameter(dbCommand, "Question_answer_13", DbType.String, model.Question_answer_13); db.AddInParameter(dbCommand, "Question_answer_14", DbType.String, model.Question_answer_14); db.AddInParameter(dbCommand, "Question_answer_15", DbType.String, model.Question_answer_15); db.AddInParameter(dbCommand, "Question_answer_16", DbType.String, model.Question_answer_16); db.AddInParameter(dbCommand, "Question_answer_17", DbType.String, model.Question_answer_17); db.AddInParameter(dbCommand, "Question_answer_18", DbType.String, model.Question_answer_18); db.AddInParameter(dbCommand, "Question_answer_19", DbType.String, model.Question_answer_19); db.AddInParameter(dbCommand, "Question_answer_20", DbType.String, model.Question_answer_20); db.AddInParameter(dbCommand, "Question_answer_21", DbType.String, model.Question_answer_21); db.AddInParameter(dbCommand, "Question_answer_22", DbType.String, model.Question_answer_22); db.AddInParameter(dbCommand, "Question_answer_23", DbType.String, model.Question_answer_23); db.AddInParameter(dbCommand, "Question_answer_24", DbType.String, model.Question_answer_24); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } }