/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Agent model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Agent set "); strSql.Append("TrueName=@TrueName,"); strSql.Append("Phone=@Phone,"); strSql.Append("Words=@Words,"); strSql.Append("ComID=@ComID,"); strSql.Append("Account=@Account,"); strSql.Append("PassWord=@PassWord,"); strSql.Append("QQ=@QQ,"); strSql.Append("WeChat=@WeChat,"); strSql.Append("Xiaoqu=@Xiaoqu"); strSql.Append(" where ID=@ID "); SQLiteParameter[] parameters = { new SQLiteParameter("@TrueName", DbType.String), new SQLiteParameter("@Phone", DbType.String), new SQLiteParameter("@Words", DbType.String), new SQLiteParameter("@ComID", DbType.Int32,8), new SQLiteParameter("@Account", DbType.String), new SQLiteParameter("@PassWord", DbType.String), new SQLiteParameter("@QQ", DbType.String), new SQLiteParameter("@WeChat", DbType.String), new SQLiteParameter("@Xiaoqu", DbType.String), new SQLiteParameter("@ID", DbType.Int32, 8) }; parameters[0].Value = model.TrueName; parameters[1].Value = model.Phone; parameters[2].Value = model.Words; parameters[3].Value = model.ComID; parameters[4].Value = model.Account; parameters[5].Value = model.PassWord; parameters[6].Value = model.QQ; parameters[7].Value = model.WeChat; parameters[8].Value = model.Xiaoqu; parameters[9].Value = model.ID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Article model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Article set "); strSql.Append("Title=@Title,"); strSql.Append("Detail=@Detail,"); strSql.Append("Summary=@Summary,"); strSql.Append("Author=@Author,"); strSql.Append("SubmitTime=@SubmitTime,"); strSql.Append("UpdateTime=@UpdateTime,"); strSql.Append("Type=@Type,"); strSql.Append("Click=@Click,"); strSql.Append("Order=@Order"); strSql.Append(" where ID=@ID"); SQLiteParameter[] parameters = { new SQLiteParameter("@Title", DbType.String), new SQLiteParameter("@Detail", DbType.String), new SQLiteParameter("@Summary", DbType.String), new SQLiteParameter("@Author", DbType.String), new SQLiteParameter("@SubmitTime", DbType.String), new SQLiteParameter("@UpdateTime", DbType.String), new SQLiteParameter("@Type", DbType.String), new SQLiteParameter("@Click", DbType.String), new SQLiteParameter("@Order", DbType.Int32,8), new SQLiteParameter("@ID", DbType.Int32, 8) }; parameters[0].Value = model.Title; parameters[1].Value = model.Detail; parameters[2].Value = model.Summary; parameters[3].Value = model.Author; parameters[4].Value = model.SubmitTime; parameters[5].Value = model.UpdateTime; parameters[6].Value = model.Type; parameters[7].Value = model.Click; parameters[8].Value = model.Order; parameters[9].Value = model.ID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 批量删除数据 /// </summary> public bool DeleteList(string RecordIDlist) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from SysParamInfo "); strSql.Append(" where RecordID in (" + RecordIDlist + ") "); int rows = DbHelperSQLite.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.Agent model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Agent("); strSql.Append("ID,TrueName,Phone,Words,ComID,Account,PassWord,QQ,WeChat,Xiaoqu)"); strSql.Append(" values ("); strSql.Append("@ID,@TrueName,@Phone,@Words,@ComID,@Account,@PassWord,@QQ,@WeChat,@Xiaoqu)"); SQLiteParameter[] parameters = { new SQLiteParameter("@ID", DbType.Int32, 8), new SQLiteParameter("@TrueName", DbType.String), new SQLiteParameter("@Phone", DbType.String), new SQLiteParameter("@Words", DbType.String), new SQLiteParameter("@ComID", DbType.Int32, 8), new SQLiteParameter("@Account", DbType.String), new SQLiteParameter("@PassWord", DbType.String), new SQLiteParameter("@QQ", DbType.String), new SQLiteParameter("@WeChat", DbType.String), new SQLiteParameter("@Xiaoqu", DbType.String) }; parameters[0].Value = model.ID; parameters[1].Value = model.TrueName; parameters[2].Value = model.Phone; parameters[3].Value = model.Words; parameters[4].Value = model.ComID; parameters[5].Value = model.Account; parameters[6].Value = model.PassWord; parameters[7].Value = model.QQ; parameters[8].Value = model.WeChat; parameters[9].Value = model.Xiaoqu; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Pic model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Pic set "); strSql.Append("ImageURL=@ImageURL,"); strSql.Append("AID=@AID,"); strSql.Append("Type=@Type,"); strSql.Append("Number=@Number,"); strSql.Append("Title=@Title,"); strSql.Append("Summary=@Summary"); strSql.Append(" where ID=@ID"); SQLiteParameter[] parameters = { new SQLiteParameter("@ImageURL", DbType.String), new SQLiteParameter("@AID", DbType.String), new SQLiteParameter("@Type", DbType.String), new SQLiteParameter("@Number", DbType.String), new SQLiteParameter("@Title", DbType.String), new SQLiteParameter("@Summary", DbType.String), new SQLiteParameter("@ID", DbType.Int32, 8) }; parameters[0].Value = model.ImageURL; parameters[1].Value = model.AID; parameters[2].Value = model.Type; parameters[3].Value = model.Number; parameters[4].Value = model.Title; parameters[5].Value = model.Summary; parameters[6].Value = model.ID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from ScriptInfo "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.Company model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Company set "); strSql.Append("Name=@Name,"); strSql.Append("Address=@Address,"); strSql.Append("Phone=@Phone,"); strSql.Append("OpenTime=@OpenTime,"); strSql.Append("Summary=@Summary"); strSql.Append(" where ID=@ID "); SQLiteParameter[] parameters = { new SQLiteParameter("@Name", DbType.String), new SQLiteParameter("@Address", DbType.String), new SQLiteParameter("@Phone", DbType.String), new SQLiteParameter("@OpenTime", DbType.String), new SQLiteParameter("@Summary", DbType.String), new SQLiteParameter("@ID", DbType.Int32, 8) }; parameters[0].Value = model.Name; parameters[1].Value = model.Address; parameters[2].Value = model.Phone; parameters[3].Value = model.OpenTime; parameters[4].Value = model.Summary; parameters[5].Value = model.ID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int RecordID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from SysParamInfo "); strSql.Append(" where RecordID=@RecordID"); SQLiteParameter[] parameters = { new SQLiteParameter("@RecordID", DbType.Int32, 4) }; parameters[0].Value = RecordID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <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 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); } }