/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperSQLite.GetMaxID("ID", "SiteConfig"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperSQLite.GetMaxID("ID", "Agent"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperSQLite.GetMaxID("ID", "Company"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperSQLite.GetMaxID("RecordID", "ExchangeInfo"));
}
/// <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>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbHelperSQLite.GetMaxID("ID", "House"));
}
/// <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);
}
}
