/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Blogs.Model.BlogUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BlogUser set ");
strSql.Append("loginname=@loginname,");
strSql.Append("oginpwd=@oginpwd,");
strSql.Append("cnname=@cnname,");
strSql.Append("email=@email,");
strSql.Append("islock=@islock,");
strSql.Append("isdel=@isdel,");
strSql.Append("addtime=@addtime,");
strSql.Append("lastlogintime=@lastlogintime,");
strSql.Append("lastloginip=@lastloginip");
strSql.Append(" where id=@id");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@loginname", DbType.String),
new SQLiteParameter("@oginpwd", DbType.String),
new SQLiteParameter("@cnname", DbType.String),
new SQLiteParameter("@email", DbType.String),
new SQLiteParameter("@islock", DbType.bit, 1),
new SQLiteParameter("@isdel", DbType.bit, 1),
new SQLiteParameter("@addtime", DbType.DateTime),
new SQLiteParameter("@lastlogintime", DbType.DateTime),
new SQLiteParameter("@lastloginip", DbType.String),
new SQLiteParameter("@id", DbType.Int32, 8)
};
parameters[0].Value = model.loginname;
parameters[1].Value = model.oginpwd;
parameters[2].Value = model.cnname;
parameters[3].Value = model.email;
parameters[4].Value = model.islock;
parameters[5].Value = model.isdel;
parameters[6].Value = model.addtime;
parameters[7].Value = model.lastlogintime;
parameters[8].Value = model.lastloginip;
parameters[9].Value = model.id;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Blogs.Model.BlogUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BlogUser(");
strSql.Append("loginname,oginpwd,cnname,email,islock,isdel,addtime,lastlogintime,lastloginip)");
strSql.Append(" values (");
strSql.Append("@loginname,@oginpwd,@cnname,@email,@islock,@isdel,@addtime,@lastlogintime,@lastloginip)");
strSql.Append(";select LAST_INSERT_ROWID()");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@loginname", DbType.String),
new SQLiteParameter("@oginpwd", DbType.String),
new SQLiteParameter("@cnname", DbType.String),
new SQLiteParameter("@email", DbType.String),
new SQLiteParameter("@islock", DbType.bit, 1),
new SQLiteParameter("@isdel", DbType.bit, 1),
new SQLiteParameter("@addtime", DbType.DateTime),
new SQLiteParameter("@lastlogintime", DbType.DateTime),
new SQLiteParameter("@lastloginip", DbType.String)
};
parameters[0].Value = model.loginname;
parameters[1].Value = model.oginpwd;
parameters[2].Value = model.cnname;
parameters[3].Value = model.email;
parameters[4].Value = model.islock;
parameters[5].Value = model.isdel;
parameters[6].Value = model.addtime;
parameters[7].Value = model.lastlogintime;
parameters[8].Value = model.lastloginip;
object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Blogs.Model.BlogUser GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,loginname,oginpwd,cnname,email,islock,isdel,addtime,lastlogintime,lastloginip from BlogUser ");
strSql.Append(" where id=@id");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@id", DbType.Int32, 4)
};
parameters[0].Value = id;
Blogs.Model.BlogUser model = new Blogs.Model.BlogUser();
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 Blogs.Model.BlogUser DataRowToModel(DataRow row)
{
Blogs.Model.BlogUser model = new Blogs.Model.BlogUser();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["loginname"] != null)
{
model.loginname = row["loginname"].ToString();
}
if (row["oginpwd"] != null)
{
model.oginpwd = row["oginpwd"].ToString();
}
if (row["cnname"] != null)
{
model.cnname = row["cnname"].ToString();
}
if (row["email"] != null)
{
model.email = row["email"].ToString();
}
if (row["islock"] != null && row["islock"].ToString() != "")
{
if ((row["islock"].ToString() == "1") || (row["islock"].ToString().ToLower() == "true"))
{
model.islock = true;
}
else
{
model.islock = false;
}
}
if (row["isdel"] != null && row["isdel"].ToString() != "")
{
if ((row["isdel"].ToString() == "1") || (row["isdel"].ToString().ToLower() == "true"))
{
model.isdel = true;
}
else
{
model.isdel = false;
}
}
if (row["addtime"] != null && row["addtime"].ToString() != "")
{
model.addtime = DateTime.Parse(row["addtime"].ToString());
}
if (row["lastlogintime"] != null && row["lastlogintime"].ToString() != "")
{
model.lastlogintime = DateTime.Parse(row["lastlogintime"].ToString());
}
if (row["lastloginip"] != null)
{
model.lastloginip = row["lastloginip"].ToString();
}
}
return(model);
}
