public Model.TempInfo GetModel(string strWhere, List <SqlParameter> parameters) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from TempInfo "); Database db = DatabaseFactory.CreateDatabase(); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); if (parameters.Count > 0) { foreach (SqlParameter sqlParameter in parameters) { dbCommand.Parameters.Add(sqlParameter); } } Model.TempInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.TempInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TempInfo("); strSql.Append("ITID,TID,AttID,TIPage,ParentID)"); strSql.Append(" values ("); strSql.Append("@ITID,@TID,@AttID,@TIPage,@ParentID)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ITID", DbType.Int32, model.ITID); db.AddInParameter(dbCommand, "TID", DbType.Int32, model.TID); db.AddInParameter(dbCommand, "AttID", DbType.String, model.AttID); db.AddInParameter(dbCommand, "TIPage", DbType.Int32, model.TIPage); db.AddInParameter(dbCommand, "ParentID", DbType.Int32, model.ParentID); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 对象实体绑定数据 /// </summary> public Model.TempInfo ReaderBind(IDataReader dataReader) { Model.TempInfo model = new Model.TempInfo(); object ojb; ojb = dataReader["TIID"]; if (ojb != null && ojb != DBNull.Value) { model.TIID = Convert.ToInt32(ojb); } ojb = dataReader["ITID"]; if (ojb != null && ojb != DBNull.Value) { model.ITID = Convert.ToInt32(ojb); } ojb = dataReader["TID"]; if (ojb != null && ojb != DBNull.Value) { model.TID = Convert.ToInt32(ojb); } model.AttID = dataReader["AttID"].ToString(); ojb = dataReader["TIPage"]; if (ojb != null && ojb != DBNull.Value) { model.TIPage = Convert.ToInt32(ojb); } ojb = dataReader["ParentID"]; if (ojb != null && ojb != DBNull.Value) { model.ParentID = Convert.ToInt32(ojb); } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.TempInfo DataRowToModel(DataRow row) { Model.TempInfo model = new Model.TempInfo(); if (row != null) { if (row["TIID"] != null && row["TIID"].ToString() != "") { model.TIID = Convert.ToInt32(row["TIID"].ToString()); } if (row["ITID"] != null && row["ITID"].ToString() != "") { model.ITID = Convert.ToInt32(row["ITID"].ToString()); } if (row["TID"] != null && row["TID"].ToString() != "") { model.TID = Convert.ToInt32(row["TID"].ToString()); } if (row["AttID"] != null) { model.AttID = row["AttID"].ToString(); } if (row["TIPage"] != null && row["TIPage"].ToString() != "") { model.TIPage = Convert.ToInt32(row["TIPage"].ToString()); } if (row["ParentID"] != null && row["ParentID"].ToString() != "") { model.ParentID = Convert.ToInt32(row["ParentID"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.TempInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TempInfo set "); strSql.Append("ITID=@ITID,"); strSql.Append("TID=@TID,"); strSql.Append("AttID=@AttID,"); strSql.Append("TIPage=@TIPage,"); strSql.Append("ParentID=@ParentID"); strSql.Append(" where TIID=@TIID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "TIID", DbType.Int32, model.TIID); db.AddInParameter(dbCommand, "ITID", DbType.Int32, model.ITID); db.AddInParameter(dbCommand, "TID", DbType.Int32, model.TID); db.AddInParameter(dbCommand, "AttID", DbType.String, model.AttID); db.AddInParameter(dbCommand, "TIPage", DbType.Int32, model.TIPage); db.AddInParameter(dbCommand, "ParentID", DbType.Int32, model.ParentID); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.TempInfo GetModel(int TIID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select TIID,ITID,TID,AttID,TIPage,ParentID from TempInfo "); strSql.Append(" where TIID=@TIID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "TIID", DbType.Int32, TIID); Model.TempInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
public Model.TempInfo GetModel(string iid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from TempInfo join TmpInfoList on TmpInfoList.TIID=TempInfo.TIID "); Database db = DatabaseFactory.CreateDatabase(); strSql.Append(" where TmpInfoList.IID=" + iid + " and TempInfo.TIPage=1 "); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); Model.TempInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }