/// <summary>
/// 通过DataRow获取一个实例
/// </summary>
protected Model.Administrators GetModelByDataRow(DataRow row)
{
Model.Administrators model = new Model.Administrators();
model.AdminId = int.Parse(row["adminid"].ToString());
model.Name = row["name"].ToString();
model.PassWord = row["password"].ToString();
if (row["state"].ToString() != "")
{
model.State = int.Parse(row["state"].ToString());
}
if (row["managebegintime"].ToString() != "")
{
model.ManageBeginTime = DateTime.Parse(row["managebegintime"].ToString());
}
if (row["manageendtime"].ToString() != "")
{
model.ManageEndTime = DateTime.Parse(row["manageendtime"].ToString());
}
if (row["power"].ToString() != "")
{
model.Power = int.Parse(row["power"].ToString());
}
if (row["allowmodifypassword"].ToString() != "")
{
model.AllowModifyPassWord = int.Parse(row["allowmodifypassword"].ToString());
}
model.Role = row["role"].ToString();
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public SOSOshop.Model.Administrators ReaderBind(IDataReader dataReader)
{
SOSOshop.Model.Administrators model = new Model.Administrators();
object ojb;
ojb = dataReader["adminid"];
if (ojb != null && ojb != DBNull.Value)
{
model.AdminId = (int)ojb;
}
model.Name = dataReader["name"].ToString();
model.PassWord = dataReader["password"].ToString();
ojb = dataReader["state"];
if (ojb != null && ojb != DBNull.Value)
{
model.AllowModifyPassWord = int.Parse(ojb.ToString());
}
ojb = dataReader["managebegintime"];
if (ojb != null && ojb != DBNull.Value)
{
model.ManageBeginTime = (DateTime)ojb;
}
ojb = dataReader["manageendtime"];
if (ojb != null && ojb != DBNull.Value)
{
model.ManageEndTime = (DateTime)ojb;
}
ojb = dataReader["power"];
if (ojb != null && ojb != DBNull.Value)
{
model.Power = int.Parse(ojb.ToString());
}
ojb = dataReader["allowmodifypassword"];
if (ojb != null && ojb != DBNull.Value)
{
model.AllowModifyPassWord = int.Parse(ojb.ToString());
}
model.Role = dataReader["role"].ToString();
model.OfficePhone = dataReader["OfficePhone"].ToString();
model.HomePhone = dataReader["HomePhone"].ToString();
model.MobilePhone = dataReader["MobilePhone"].ToString();
model.LoginAuthenticationOfficePhone = dataReader["LoginAuthenticationOfficePhone"].ToString();
model.QQ = dataReader["QQ"].ToString();
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Administrators model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update yxs_administrators set ");
strSql.Append("name=@name,");
if (model.PassWord.Length > 0)
{
strSql.Append("password=@password,");
}
strSql.Append("state=@state,");
strSql.Append("managebegintime=@managebegintime,");
strSql.Append("manageendtime=@manageendtime,");
strSql.Append("power=@power,");
strSql.Append("role=@role,");
strSql.Append("OfficePhone=@OfficePhone,");
strSql.Append("HomePhone=@HomePhone,");
strSql.Append("MobilePhone=@MobilePhone,");
strSql.Append("LoginAuthenticationOfficePhone=@LoginAuthenticationOfficePhone,");
strSql.Append("QQ=@QQ,");
strSql.Append("allowmodifypassword=@allowmodifypassword ");
strSql.Append(" where adminid=@adminid ");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "adminid", DbType.Int32, model.AdminId);
db.AddInParameter(dbCommand, "name", DbType.AnsiString, model.Name);
db.AddInParameter(dbCommand, "password", DbType.AnsiString, ChangeHope.Common.DEncryptHelper.Encrypt(model.PassWord, 1));
db.AddInParameter(dbCommand, "state", DbType.Int32, model.State);
db.AddInParameter(dbCommand, "managebegintime", DbType.DateTime, model.ManageBeginTime);
db.AddInParameter(dbCommand, "manageendtime", DbType.DateTime, model.ManageEndTime);
db.AddInParameter(dbCommand, "power", DbType.Int32, model.Power);
db.AddInParameter(dbCommand, "allowmodifypassword", DbType.Int32, model.AllowModifyPassWord);
db.AddInParameter(dbCommand, "role", DbType.AnsiString, model.Role);
db.AddInParameter(dbCommand, "OfficePhone", DbType.AnsiString, model.OfficePhone);
db.AddInParameter(dbCommand, "HomePhone", DbType.AnsiString, model.HomePhone);
db.AddInParameter(dbCommand, "MobilePhone", DbType.AnsiString, model.MobilePhone);
db.AddInParameter(dbCommand, "LoginAuthenticationOfficePhone", DbType.AnsiString, model.LoginAuthenticationOfficePhone);
db.AddInParameter(dbCommand, "QQ", DbType.AnsiString, model.QQ);
return(0 < db.ExecuteNonQuery(dbCommand));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Administrators model)
{
if (!Exists(model.Name))
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into yxs_administrators(");
strSql.Append("name,password,state,managebegintime,manageendtime,power,allowmodifypassword,role,OfficePhone,HomePhone,MobilePhone,LoginAuthenticationOfficePhone,QQ)");
strSql.Append(" values (");
strSql.Append("@name,@password,@state,@managebegintime,@manageendtime,@power,@allowmodifypassword,@role,@OfficePhone,@HomePhone,@MobilePhone,@LoginAuthenticationOfficePhone,@QQ)");
strSql.Append(";select @@IDENTITY");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "name", DbType.AnsiString, model.Name);
db.AddInParameter(dbCommand, "password", DbType.AnsiString, ChangeHope.Common.DEncryptHelper.Encrypt(model.PassWord, 1));
db.AddInParameter(dbCommand, "state", DbType.Int32, model.State);
db.AddInParameter(dbCommand, "managebegintime", DbType.DateTime, model.ManageBeginTime);
db.AddInParameter(dbCommand, "manageendtime", DbType.DateTime, model.ManageEndTime);
db.AddInParameter(dbCommand, "power", DbType.Int32, model.Power);
db.AddInParameter(dbCommand, "allowmodifypassword", DbType.Int32, model.AllowModifyPassWord);
db.AddInParameter(dbCommand, "role", DbType.AnsiString, model.Role);
db.AddInParameter(dbCommand, "OfficePhone", DbType.AnsiString, model.OfficePhone);
db.AddInParameter(dbCommand, "HomePhone", DbType.AnsiString, model.HomePhone);
db.AddInParameter(dbCommand, "MobilePhone", DbType.AnsiString, model.MobilePhone);
db.AddInParameter(dbCommand, "LoginAuthenticationOfficePhone", DbType.AnsiString, model.LoginAuthenticationOfficePhone);
db.AddInParameter(dbCommand, "QQ", DbType.AnsiString, model.QQ);
object obj = db.ExecuteScalar(dbCommand);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
else
{
return(0);
}
}
