/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(GL.Model.AdminModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GL_Admin set ");
strSql.Append("UserName=@UserName,");
strSql.Append("PassWord=@PassWord,");
strSql.Append("Sex=@Sex,");
strSql.Append("Email=@Email,");
strSql.Append("TelPhone=@TelPhone,");
//strSql.Append("AddDate=@AddDate,");
//strSql.Append("LastLoginIP=@LastLoginIP,");
//strSql.Append("LastLoginTime=@LastLoginTime,");
strSql.Append("Locked=@Locked,");
strSql.Append("ModelPower=@ModelPower");
//strSql.Append("LoginTime=@LoginTime");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@PassWord", SqlDbType.NVarChar, 50),
new SqlParameter("@Sex", SqlDbType.Int, 4),
new SqlParameter("@Email", SqlDbType.NVarChar, 50),
new SqlParameter("@TelPhone", SqlDbType.NVarChar, 50),
//new SqlParameter("@AddDate", SqlDbType.DateTime),
//new SqlParameter("@LastLoginIP", SqlDbType.NVarChar,50),
//new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
new SqlParameter("@Locked", SqlDbType.Int, 4),
new SqlParameter("@ModelPower", SqlDbType.NVarChar, 350),
//new SqlParameter("@LoginTime", SqlDbType.Int,4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.PassWord;
parameters[2].Value = model.Sex;
parameters[3].Value = model.Email;
parameters[4].Value = model.TelPhone;
//parameters[5].Value = model.AddDate;
//parameters[6].Value = model.LastLoginIP;
//parameters[7].Value = model.LastLoginTime;
parameters[5].Value = model.Locked;
parameters[6].Value = model.ModelPower;
// parameters[7].Value = model.LoginTime;
parameters[7].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(GL.Model.AdminModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GL_Admin(");
strSql.Append("UserName,PassWord,Sex,Email,TelPhone,AddDate,LastLoginIP,LastLoginTime,Locked,ModelPower,LoginTime)");
strSql.Append(" values (");
strSql.Append("@UserName,@PassWord,@Sex,@Email,@TelPhone,@AddDate,@LastLoginIP,@LastLoginTime,@Locked,@ModelPower,@LoginTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@PassWord", SqlDbType.NVarChar, 50),
new SqlParameter("@Sex", SqlDbType.Int, 4),
new SqlParameter("@Email", SqlDbType.NVarChar, 50),
new SqlParameter("@TelPhone", SqlDbType.NVarChar, 50),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@LastLoginIP", SqlDbType.NVarChar, 50),
new SqlParameter("@LastLoginTime", SqlDbType.DateTime),
new SqlParameter("@Locked", SqlDbType.Int, 4),
new SqlParameter("@ModelPower", SqlDbType.NVarChar, 350),
new SqlParameter("@LoginTime", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.PassWord;
parameters[2].Value = model.Sex;
parameters[3].Value = model.Email;
parameters[4].Value = model.TelPhone;
parameters[5].Value = model.AddDate;
parameters[6].Value = model.LastLoginIP;
parameters[7].Value = model.LastLoginTime;
parameters[8].Value = model.Locked;
parameters[9].Value = model.ModelPower;
parameters[10].Value = model.LoginTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 根据用户名取得实体ID，ModelPower，LoginTime，登录时用到
/// </summary>
/// <param name="UserName"></param>
/// <returns></returns>
public GL.Model.AdminModel Getid(string UserName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,UserName,ModelPower,LoginTime from GL_Admin ");
strSql.Append(" where UserName=@UserName");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 50)
};
parameters[0].Value = UserName;
GL.Model.AdminModel model = new GL.Model.AdminModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["ModelPower"] != null && ds.Tables[0].Rows[0]["ModelPower"].ToString() != "")
{
model.ModelPower = ds.Tables[0].Rows[0]["ModelPower"].ToString();
}
if (ds.Tables[0].Rows[0]["LoginTime"] != null && ds.Tables[0].Rows[0]["LoginTime"].ToString() != "")
{
model.LoginTime = int.Parse(ds.Tables[0].Rows[0]["LoginTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(GL.Model.AdminModel model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(GL.Model.AdminModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public GL.Model.AdminModel GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,UserName,PassWord,Sex,Email,TelPhone,AddDate,LastLoginIP,LastLoginTime,Locked,ModelPower,LoginTime from GL_Admin ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
GL.Model.AdminModel model = new GL.Model.AdminModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "")
{
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
}
if (ds.Tables[0].Rows[0]["PassWord"] != null && ds.Tables[0].Rows[0]["PassWord"].ToString() != "")
{
model.PassWord = ds.Tables[0].Rows[0]["PassWord"].ToString();
}
if (ds.Tables[0].Rows[0]["Sex"] != null && ds.Tables[0].Rows[0]["Sex"].ToString() != "")
{
model.Sex = int.Parse(ds.Tables[0].Rows[0]["Sex"].ToString());
}
if (ds.Tables[0].Rows[0]["Email"] != null && ds.Tables[0].Rows[0]["Email"].ToString() != "")
{
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
}
if (ds.Tables[0].Rows[0]["TelPhone"] != null && ds.Tables[0].Rows[0]["TelPhone"].ToString() != "")
{
model.TelPhone = ds.Tables[0].Rows[0]["TelPhone"].ToString();
}
if (ds.Tables[0].Rows[0]["AddDate"] != null && ds.Tables[0].Rows[0]["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString());
}
if (ds.Tables[0].Rows[0]["LastLoginIP"] != null && ds.Tables[0].Rows[0]["LastLoginIP"].ToString() != "")
{
model.LastLoginIP = ds.Tables[0].Rows[0]["LastLoginIP"].ToString();
}
if (ds.Tables[0].Rows[0]["LastLoginTime"] != null && ds.Tables[0].Rows[0]["LastLoginTime"].ToString() != "")
{
model.LastLoginTime = DateTime.Parse(ds.Tables[0].Rows[0]["LastLoginTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Locked"] != null && ds.Tables[0].Rows[0]["Locked"].ToString() != "")
{
model.Locked = int.Parse(ds.Tables[0].Rows[0]["Locked"].ToString());
}
if (ds.Tables[0].Rows[0]["ModelPower"] != null && ds.Tables[0].Rows[0]["ModelPower"].ToString() != "")
{
model.ModelPower = ds.Tables[0].Rows[0]["ModelPower"].ToString();
}
if (ds.Tables[0].Rows[0]["LoginTime"] != null && ds.Tables[0].Rows[0]["LoginTime"].ToString() != "")
{
model.LoginTime = int.Parse(ds.Tables[0].Rows[0]["LoginTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
