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