/// <summary>
/// 得到一个对象实体
/// </summary>
public JC.Model.sites GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,url,logo,icon,lang,langcode,title,keywords,description,titleen,keywordsen,descriptionen,company,freetele,beiancode,sitetrack,mail,mailpwd,mailsmtp,mailport,nopic,picmaxlength,contact,logday,ext1,ext2,ext3,ext4,ext5,ext6,ext7,ext8,ext9,ext10 from sites ");
strSql.Append(" where id=@id");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@id", DbType.Int32, 4)
};
parameters[0].Value = id;
JC.Model.sites model = new JC.Model.sites();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JC.Model.sites model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sites(");
strSql.Append("url,logo,icon,lang,langcode,title,keywords,description,titleen,keywordsen,descriptionen,company,freetele,beiancode,sitetrack,mail,mailpwd,mailsmtp,mailport,nopic,picmaxlength,contact,logday,ext1,ext2,ext3,ext4,ext5,ext6,ext7,ext8,ext9,ext10)");
strSql.Append(" values (");
strSql.Append("@url,@logo,@icon,@lang,@langcode,@title,@keywords,@description,@titleen,@keywordsen,@descriptionen,@company,@freetele,@beiancode,@sitetrack,@mail,@mailpwd,@mailsmtp,@mailport,@nopic,@picmaxlength,@contact,@logday,@ext1,@ext2,@ext3,@ext4,@ext5,@ext6,@ext7,@ext8,@ext9,@ext10)");
strSql.Append(";select LAST_INSERT_ROWID()");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@url", DbType.String),
new SQLiteParameter("@logo", DbType.String),
new SQLiteParameter("@icon", DbType.String),
new SQLiteParameter("@lang", DbType.String),
new SQLiteParameter("@langcode", DbType.String),
new SQLiteParameter("@title", DbType.String),
new SQLiteParameter("@keywords", DbType.String),
new SQLiteParameter("@description", DbType.String),
new SQLiteParameter("@titleen", DbType.String),
new SQLiteParameter("@keywordsen", DbType.String),
new SQLiteParameter("@descriptionen", DbType.String),
new SQLiteParameter("@company", DbType.String),
new SQLiteParameter("@freetele", DbType.String),
new SQLiteParameter("@beiancode", DbType.String),
new SQLiteParameter("@sitetrack", DbType.String),
new SQLiteParameter("@mail", DbType.String),
new SQLiteParameter("@mailpwd", DbType.String),
new SQLiteParameter("@mailsmtp", DbType.String),
new SQLiteParameter("@mailport", DbType.Int32, 8),
new SQLiteParameter("@nopic", DbType.String),
new SQLiteParameter("@picmaxlength", DbType.Int32, 8),
new SQLiteParameter("@contact", DbType.String),
new SQLiteParameter("@logday", DbType.Int32, 8),
new SQLiteParameter("@ext1", DbType.String),
new SQLiteParameter("@ext2", DbType.String),
new SQLiteParameter("@ext3", DbType.String),
new SQLiteParameter("@ext4", DbType.String),
new SQLiteParameter("@ext5", DbType.String),
new SQLiteParameter("@ext6", DbType.String),
new SQLiteParameter("@ext7", DbType.String),
new SQLiteParameter("@ext8", DbType.String),
new SQLiteParameter("@ext9", DbType.String),
new SQLiteParameter("@ext10", DbType.String)
};
parameters[0].Value = model.url;
parameters[1].Value = model.logo;
parameters[2].Value = model.icon;
parameters[3].Value = model.lang;
parameters[4].Value = model.langcode;
parameters[5].Value = model.title;
parameters[6].Value = model.keywords;
parameters[7].Value = model.description;
parameters[8].Value = model.titleen;
parameters[9].Value = model.keywordsen;
parameters[10].Value = model.descriptionen;
parameters[11].Value = model.company;
parameters[12].Value = model.freetele;
parameters[13].Value = model.beiancode;
parameters[14].Value = model.sitetrack;
parameters[15].Value = model.mail;
parameters[16].Value = model.mailpwd;
parameters[17].Value = model.mailsmtp;
parameters[18].Value = model.mailport;
parameters[19].Value = model.nopic;
parameters[20].Value = model.picmaxlength;
parameters[21].Value = model.contact;
parameters[22].Value = model.logday;
parameters[23].Value = model.ext1;
parameters[24].Value = model.ext2;
parameters[25].Value = model.ext3;
parameters[26].Value = model.ext4;
parameters[27].Value = model.ext5;
parameters[28].Value = model.ext6;
parameters[29].Value = model.ext7;
parameters[30].Value = model.ext8;
parameters[31].Value = model.ext9;
parameters[32].Value = model.ext10;
object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JC.Model.sites DataRowToModel(DataRow row)
{
JC.Model.sites model = new JC.Model.sites();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["url"] != null)
{
model.url = row["url"].ToString();
}
if (row["logo"] != null)
{
model.logo = row["logo"].ToString();
}
if (row["icon"] != null)
{
model.icon = row["icon"].ToString();
}
if (row["lang"] != null)
{
model.lang = row["lang"].ToString();
}
if (row["langcode"] != null)
{
model.langcode = row["langcode"].ToString();
}
if (row["title"] != null)
{
model.title = row["title"].ToString();
}
if (row["keywords"] != null)
{
model.keywords = row["keywords"].ToString();
}
if (row["description"] != null)
{
model.description = row["description"].ToString();
}
if (row["titleen"] != null)
{
model.titleen = row["titleen"].ToString();
}
if (row["keywordsen"] != null)
{
model.keywordsen = row["keywordsen"].ToString();
}
if (row["descriptionen"] != null)
{
model.descriptionen = row["descriptionen"].ToString();
}
if (row["company"] != null)
{
model.company = row["company"].ToString();
}
if (row["freetele"] != null)
{
model.freetele = row["freetele"].ToString();
}
if (row["beiancode"] != null)
{
model.beiancode = row["beiancode"].ToString();
}
if (row["sitetrack"] != null)
{
model.sitetrack = row["sitetrack"].ToString();
}
if (row["mail"] != null)
{
model.mail = row["mail"].ToString();
}
if (row["mailpwd"] != null)
{
model.mailpwd = row["mailpwd"].ToString();
}
if (row["mailsmtp"] != null)
{
model.mailsmtp = row["mailsmtp"].ToString();
}
if (row["mailport"] != null && row["mailport"].ToString() != "")
{
model.mailport = int.Parse(row["mailport"].ToString());
}
if (row["nopic"] != null)
{
model.nopic = row["nopic"].ToString();
}
if (row["picmaxlength"] != null && row["picmaxlength"].ToString() != "")
{
model.picmaxlength = int.Parse(row["picmaxlength"].ToString());
}
if (row["contact"] != null)
{
model.contact = row["contact"].ToString();
}
if (row["logday"] != null && row["logday"].ToString() != "")
{
model.logday = int.Parse(row["logday"].ToString());
}
if (row["ext1"] != null)
{
model.ext1 = row["ext1"].ToString();
}
if (row["ext2"] != null)
{
model.ext2 = row["ext2"].ToString();
}
if (row["ext3"] != null)
{
model.ext3 = row["ext3"].ToString();
}
if (row["ext4"] != null)
{
model.ext4 = row["ext4"].ToString();
}
if (row["ext5"] != null)
{
model.ext5 = row["ext5"].ToString();
}
if (row["ext6"] != null)
{
model.ext6 = row["ext6"].ToString();
}
if (row["ext7"] != null)
{
model.ext7 = row["ext7"].ToString();
}
if (row["ext8"] != null)
{
model.ext8 = row["ext8"].ToString();
}
if (row["ext9"] != null)
{
model.ext9 = row["ext9"].ToString();
}
if (row["ext10"] != null)
{
model.ext10 = row["ext10"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JC.Model.sites model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sites set ");
strSql.Append("url=@url,");
strSql.Append("logo=@logo,");
strSql.Append("icon=@icon,");
strSql.Append("lang=@lang,");
strSql.Append("langcode=@langcode,");
strSql.Append("title=@title,");
strSql.Append("keywords=@keywords,");
strSql.Append("description=@description,");
strSql.Append("titleen=@titleen,");
strSql.Append("keywordsen=@keywordsen,");
strSql.Append("descriptionen=@descriptionen,");
strSql.Append("freetele=@freetele,");
strSql.Append("company=@company,");
strSql.Append("beiancode=@beiancode,");
strSql.Append("sitetrack=@sitetrack,");
strSql.Append("mail=@mail,");
strSql.Append("mailpwd=@mailpwd,");
strSql.Append("mailsmtp=@mailsmtp,");
strSql.Append("mailport=@mailport,");
strSql.Append("nopic=@nopic,");
strSql.Append("picmaxlength=@picmaxlength,");
strSql.Append("contact=@contact,");
strSql.Append("logday=@logday,");
strSql.Append("ext1=@ext1,");
strSql.Append("ext2=@ext2,");
strSql.Append("ext3=@ext3,");
strSql.Append("ext4=@ext4,");
strSql.Append("ext5=@ext5,");
strSql.Append("ext6=@ext6,");
strSql.Append("ext7=@ext7,");
strSql.Append("ext8=@ext8,");
strSql.Append("ext9=@ext9,");
strSql.Append("ext10=@ext10");
strSql.Append(" where id=@id");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@url", DbType.String),
new SQLiteParameter("@logo", DbType.String),
new SQLiteParameter("@icon", DbType.String),
new SQLiteParameter("@lang", DbType.String),
new SQLiteParameter("@langcode", DbType.String),
new SQLiteParameter("@title", DbType.String),
new SQLiteParameter("@keywords", DbType.String),
new SQLiteParameter("@description", DbType.String),
new SQLiteParameter("@titleen", DbType.String),
new SQLiteParameter("@keywordsen", DbType.String),
new SQLiteParameter("@descriptionen", DbType.String),
new SQLiteParameter("@company", DbType.String),
new SQLiteParameter("@freetele", DbType.String),
new SQLiteParameter("@beiancode", DbType.String),
new SQLiteParameter("@sitetrack", DbType.String),
new SQLiteParameter("@mail", DbType.String),
new SQLiteParameter("@mailpwd", DbType.String),
new SQLiteParameter("@mailsmtp", DbType.String),
new SQLiteParameter("@mailport", DbType.Int32, 8),
new SQLiteParameter("@nopic", DbType.String),
new SQLiteParameter("@picmaxlength", DbType.Int32, 8),
new SQLiteParameter("@contact", DbType.String),
new SQLiteParameter("@logday", DbType.Int32, 8),
new SQLiteParameter("@ext1", DbType.String),
new SQLiteParameter("@ext2", DbType.String),
new SQLiteParameter("@ext3", DbType.String),
new SQLiteParameter("@ext4", DbType.String),
new SQLiteParameter("@ext5", DbType.String),
new SQLiteParameter("@ext6", DbType.String),
new SQLiteParameter("@ext7", DbType.String),
new SQLiteParameter("@ext8", DbType.String),
new SQLiteParameter("@ext9", DbType.String),
new SQLiteParameter("@ext10", DbType.String),
new SQLiteParameter("@id", DbType.Int32, 8)
};
parameters[0].Value = model.url;
parameters[1].Value = model.logo;
parameters[2].Value = model.icon;
parameters[3].Value = model.lang;
parameters[4].Value = model.langcode;
parameters[5].Value = model.title;
parameters[6].Value = model.keywords;
parameters[7].Value = model.description;
parameters[8].Value = model.titleen;
parameters[9].Value = model.keywordsen;
parameters[10].Value = model.descriptionen;
parameters[11].Value = model.company;
parameters[12].Value = model.freetele;
parameters[13].Value = model.beiancode;
parameters[14].Value = model.sitetrack;
parameters[15].Value = model.mail;
parameters[16].Value = model.mailpwd;
parameters[17].Value = model.mailsmtp;
parameters[18].Value = model.mailport;
parameters[19].Value = model.nopic;
parameters[20].Value = model.picmaxlength;
parameters[21].Value = model.contact;
parameters[22].Value = model.logday;
parameters[23].Value = model.ext1;
parameters[24].Value = model.ext2;
parameters[25].Value = model.ext3;
parameters[26].Value = model.ext4;
parameters[27].Value = model.ext5;
parameters[28].Value = model.ext6;
parameters[29].Value = model.ext7;
parameters[30].Value = model.ext8;
parameters[31].Value = model.ext9;
parameters[32].Value = model.ext10;
parameters[33].Value = model.id;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
