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