/// <summary> /// 获取实体 /// </summary> /// <param name="index">从第几个获取,从0开始</param> /// <param name="num">获取几个</param> /// <param name="where">条件</param> /// <returns></returns> public Model.House GetModel(int index, int num, string where) { //string sql = "select * from House where type='Sale' and JingPin='精品' LIMIT 0,1"; StringBuilder strSql = new StringBuilder(); strSql.Append("select * from House"); if (where != "") { strSql.Append(" where " + where + " ORDER BY id desc "); } else { strSql.Append(" ORDER BY id desc "); } strSql.Append(" LIMIT @index,@num"); SQLiteParameter[] parameters = { new SQLiteParameter("@index", DbType.Int32), new SQLiteParameter("@num", DbType.Int32) }; parameters[0].Value = index; parameters[1].Value = num; Model.House model = new Model.House(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(new Model.House().DefaultHouse()); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.House GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,Type,JingPin,Qu,XiaoQu,Ceng,ZongCeng,Shi,Ting,Wei,MianJi,ZhuangXiu,Jianyu,JiaGe,JiaGeDanwei,Chaoxiang,Chanquan,JieGou,ZhuJiMa,FyHao,DengJiTime,JJR,JJRPhone,Title,Detail from House "); strSql.Append(" where ID=@ID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ID", DbType.Int32, 8) }; parameters[0].Value = ID; Model.House model = new Model.House(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(new Model.House().DefaultHouse()); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.House model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into House("); strSql.Append("ID,Type,JingPin,Qu,XiaoQu,Ceng,ZongCeng,Shi,Ting,Wei,MianJi,ZhuangXiu,Jianyu,JiaGe,JiaGeDanwei,Chaoxiang,Chanquan,JieGou,ZhuJiMa,FyHao,DengJiTime,JJR,JJRPhone,Title,Detail)"); strSql.Append(" values ("); strSql.Append("@ID,@Type,@JingPin,@Qu,@XiaoQu,@Ceng,@ZongCeng,@Shi,@Ting,@Wei,@MianJi,@ZhuangXiu,@Jianyu,@JiaGe,@JiaGeDanwei,@Chaoxiang,@Chanquan,@JieGou,@ZhuJiMa,@FyHao,@DengJiTime,@JJR,@JJRPhone,@Title,@Detail)"); SQLiteParameter[] parameters = { new SQLiteParameter("@ID", DbType.Int32, 8), new SQLiteParameter("@Type", DbType.String), new SQLiteParameter("@JingPin", DbType.String), new SQLiteParameter("@Qu", DbType.String), new SQLiteParameter("@XiaoQu", DbType.String), new SQLiteParameter("@Ceng", DbType.String), new SQLiteParameter("@ZongCeng", DbType.String), new SQLiteParameter("@Shi", DbType.String), new SQLiteParameter("@Ting", DbType.String), new SQLiteParameter("@Wei", DbType.String), new SQLiteParameter("@MianJi", DbType.String), new SQLiteParameter("@ZhuangXiu", DbType.String), new SQLiteParameter("@Jianyu", DbType.String), new SQLiteParameter("@JiaGe", DbType.String), new SQLiteParameter("@JiaGeDanwei", DbType.String), new SQLiteParameter("@Chaoxiang", DbType.String), new SQLiteParameter("@Chanquan", DbType.String), new SQLiteParameter("@JieGou", DbType.String), new SQLiteParameter("@ZhuJiMa", DbType.String), new SQLiteParameter("@FyHao", DbType.String), new SQLiteParameter("@DengJiTime", DbType.String), new SQLiteParameter("@JJR", DbType.String), new SQLiteParameter("@JJRPhone", DbType.String), new SQLiteParameter("@Title", DbType.String), new SQLiteParameter("@Detail", DbType.String) }; parameters[0].Value = model.ID; parameters[1].Value = model.Type; parameters[2].Value = model.JingPin; parameters[3].Value = model.Qu; parameters[4].Value = model.XiaoQu; parameters[5].Value = model.Ceng; parameters[6].Value = model.ZongCeng; parameters[7].Value = model.Shi; parameters[8].Value = model.Ting; parameters[9].Value = model.Wei; parameters[10].Value = model.MianJi; parameters[11].Value = model.ZhuangXiu; parameters[12].Value = model.Jianyu; parameters[13].Value = model.JiaGe; parameters[14].Value = model.JiaGeDanwei; parameters[15].Value = model.Chaoxiang; parameters[16].Value = model.Chanquan; parameters[17].Value = model.JieGou; parameters[18].Value = model.ZhuJiMa; parameters[19].Value = model.FyHao; parameters[20].Value = model.DengJiTime; parameters[21].Value = model.JJR; parameters[22].Value = model.JJRPhone; parameters[23].Value = model.Title; parameters[24].Value = model.Detail; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.House DataRowToModel(DataRow row) { Model.House model = new Model.House(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["Type"] != null) { model.Type = row["Type"].ToString(); } if (row["JingPin"] != null) { model.JingPin = row["JingPin"].ToString(); } if (row["Qu"] != null) { model.Qu = row["Qu"].ToString(); } if (row["XiaoQu"] != null) { model.XiaoQu = row["XiaoQu"].ToString(); } if (row["Ceng"] != null) { model.Ceng = row["Ceng"].ToString(); } if (row["ZongCeng"] != null) { model.ZongCeng = row["ZongCeng"].ToString(); } if (row["Shi"] != null) { model.Shi = row["Shi"].ToString(); } if (row["Ting"] != null) { model.Ting = row["Ting"].ToString(); } if (row["Wei"] != null) { model.Wei = row["Wei"].ToString(); } if (row["MianJi"] != null) { model.MianJi = row["MianJi"].ToString(); } if (row["ZhuangXiu"] != null) { model.ZhuangXiu = row["ZhuangXiu"].ToString(); } if (row["Jianyu"] != null) { model.Jianyu = row["Jianyu"].ToString(); } if (row["JiaGe"] != null) { model.JiaGe = row["JiaGe"].ToString(); } if (row["JiaGeDanwei"] != null) { model.JiaGeDanwei = row["JiaGeDanwei"].ToString(); } if (row["Chaoxiang"] != null) { model.Chaoxiang = row["Chaoxiang"].ToString(); } if (row["Chanquan"] != null) { model.Chanquan = row["Chanquan"].ToString(); } if (row["JieGou"] != null) { model.JieGou = row["JieGou"].ToString(); } if (row["ZhuJiMa"] != null) { model.ZhuJiMa = row["ZhuJiMa"].ToString(); } if (row["FyHao"] != null) { model.FyHao = row["FyHao"].ToString(); } if (row["DengJiTime"] != null) { model.DengJiTime = row["DengJiTime"].ToString(); } if (row["JJR"] != null) { model.JJR = row["JJR"].ToString(); } if (row["JJRPhone"] != null) { model.JJRPhone = row["JJRPhone"].ToString(); } if (row["Title"] != null) { model.Title = row["Title"].ToString(); } if (row["Detail"] != null) { model.Detail = row["Detail"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.House model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update House set "); strSql.Append("Type=@Type,"); strSql.Append("JingPin=@JingPin,"); strSql.Append("Qu=@Qu,"); strSql.Append("XiaoQu=@XiaoQu,"); strSql.Append("Ceng=@Ceng,"); strSql.Append("ZongCeng=@ZongCeng,"); strSql.Append("Shi=@Shi,"); strSql.Append("Ting=@Ting,"); strSql.Append("Wei=@Wei,"); strSql.Append("MianJi=@MianJi,"); strSql.Append("ZhuangXiu=@ZhuangXiu,"); strSql.Append("Jianyu=@Jianyu,"); strSql.Append("JiaGe=@JiaGe,"); strSql.Append("JiaGeDanwei=@JiaGeDanwei,"); strSql.Append("Chaoxiang=@Chaoxiang,"); strSql.Append("Chanquan=@Chanquan,"); strSql.Append("JieGou=@JieGou,"); strSql.Append("ZhuJiMa=@ZhuJiMa,"); strSql.Append("FyHao=@FyHao,"); strSql.Append("DengJiTime=@DengJiTime,"); strSql.Append("JJR=@JJR,"); strSql.Append("JJRPhone=@JJRPhone,"); strSql.Append("Title=@Title,"); strSql.Append("Detail=@Detail"); strSql.Append(" where ID=@ID "); SQLiteParameter[] parameters = { new SQLiteParameter("@Type", DbType.String), new SQLiteParameter("@JingPin", DbType.String), new SQLiteParameter("@Qu", DbType.String), new SQLiteParameter("@XiaoQu", DbType.String), new SQLiteParameter("@Ceng", DbType.String), new SQLiteParameter("@ZongCeng", DbType.String), new SQLiteParameter("@Shi", DbType.String), new SQLiteParameter("@Ting", DbType.String), new SQLiteParameter("@Wei", DbType.String), new SQLiteParameter("@MianJi", DbType.String), new SQLiteParameter("@ZhuangXiu", DbType.String), new SQLiteParameter("@Jianyu", DbType.String), new SQLiteParameter("@JiaGe", DbType.String), new SQLiteParameter("@JiaGeDanwei", DbType.String), new SQLiteParameter("@Chaoxiang", DbType.String), new SQLiteParameter("@Chanquan", DbType.String), new SQLiteParameter("@JieGou", DbType.String), new SQLiteParameter("@ZhuJiMa", DbType.String), new SQLiteParameter("@FyHao", DbType.String), new SQLiteParameter("@DengJiTime", DbType.String), new SQLiteParameter("@JJR", DbType.String), new SQLiteParameter("@JJRPhone", DbType.String), new SQLiteParameter("@Title", DbType.String), new SQLiteParameter("@Detail", DbType.String), new SQLiteParameter("@ID", DbType.Int32, 8) }; parameters[0].Value = model.Type; parameters[1].Value = model.JingPin; parameters[2].Value = model.Qu; parameters[3].Value = model.XiaoQu; parameters[4].Value = model.Ceng; parameters[5].Value = model.ZongCeng; parameters[6].Value = model.Shi; parameters[7].Value = model.Ting; parameters[8].Value = model.Wei; parameters[9].Value = model.MianJi; parameters[10].Value = model.ZhuangXiu; parameters[11].Value = model.Jianyu; parameters[12].Value = model.JiaGe; parameters[13].Value = model.JiaGeDanwei; parameters[14].Value = model.Chaoxiang; parameters[15].Value = model.Chanquan; parameters[16].Value = model.JieGou; parameters[17].Value = model.ZhuJiMa; parameters[18].Value = model.FyHao; parameters[19].Value = model.DengJiTime; parameters[20].Value = model.JJR; parameters[21].Value = model.JJRPhone; parameters[22].Value = model.Title; parameters[23].Value = model.Detail; parameters[24].Value = model.ID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }