public int Update(UserInfo t)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetStoredProcCommand("p_UserInfo_Update");
db.AddInParameter(cmd, "@UserID", DbType.String, t.UserID);
db.AddInParameter(cmd, "@Link_Tel", DbType.String, t.Link_Tel);
db.AddInParameter(cmd, "@Mob_Tel", DbType.String, t.Mob_Tel);
db.AddInParameter(cmd, "@LoginID", DbType.String, t.LoginID);
db.AddInParameter(cmd, "@Password", DbType.String, t.Password);
db.AddInParameter(cmd, "@UserName", DbType.String, t.UserName);
db.AddInParameter(cmd, "@Spell_Index", DbType.String, t.Spell_Index);
db.AddInParameter(cmd, "@Sex", DbType.String, t.Sex);
db.AddInParameter(cmd, "@IdentityCard", DbType.String, t.IdentityCard);
db.AddInParameter(cmd, "@Birthday", DbType.String, t.Birthday);
db.AddInParameter(cmd, "@EMail", DbType.String, t.EMail);
db.AddInParameter(cmd, "@Addr", DbType.String, t.Addr);
db.AddInParameter(cmd, "@State", DbType.String, t.State);
return db.ExecuteNonQuery(cmd);
}
public int Save(UserInfo t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from [UserInfo] ");
strSql.Append(" where UserID='" + t.UserID.ToString() + "'");
DBHelper db = new DBHelper();
DbCommand cmd = db.GetSqlStringCommand(strSql.ToString());
int rows = db.ExecuteNonQuery(cmd);
if (rows > 0)
{
return 1;
}
else
{
return -1;
}
}
public int Delete(UserInfo t)
{
string sql = "delete from [UserInfo] where UserID='" + t.UserID + "'";
DBHelper db = new DBHelper();
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteNonQuery(cmd);
}
public UserInfo SelectUserByLogID(string logID)
{
UserInfo user = new UserInfo();
//user.UserRoleses=new List<UserRoles>();
String sql = "select * from [UserInfo] u left join UserRoles ur on u.UserID=ur.UID where u.LoginID='" +
logID + "'";
DBHelper db = new DBHelper();
DbCommand cmd = db.GetSqlStringCommand(sql);
DataTable dt = db.ExecuteDataTable(cmd);
int i = 0;
foreach (DataRow row in dt.Rows)
{
if (i == 0)
{
user = this.DataRowToBean(row);
user.UserRoleses = new List<UserRoles>();
user.UserRoleses.Add(this.DataRowToUserRoleBean(row));
}
else
{
user.UserRoleses.Add(this.DataRowToUserRoleBean(row));
}
i = 1;
return user;
}
return null;
}
private UserInfo DataRowToBean(DataRow row)
{
UserInfo model = new UserInfo();
model.UserID = Guid.Parse(UtilData.DBObjectToString(row["UserID"]));
model.Link_Tel = UtilData.DBObjectToString(row["Link_Tel"]);
model.Mob_Tel = UtilData.DBObjectToString(row["Mob_Tel"]);
model.LoginID = UtilData.DBObjectToString(row["LoginID"]);
model.Password = UtilData.DBObjectToString(row["Password"]);
model.UserName = UtilData.DBObjectToString(row["UserName"]);
model.Spell_Index = UtilData.DBObjectToString(row["Spell_Index"]);
model.Sex = UtilData.DBObjectToInt(row["Sex"]);
model.IdentityCard = UtilData.DBObjectToString(row["IdentityCard"]);
model.Birthday = UtilData.DBObjectToDateTime(row["Birthday"]);
model.EMail = UtilData.DBObjectToString(row["EMail"]);
model.Addr = UtilData.DBObjectToString(row["Addr"]);
model.State = UtilData.DBObjectToString(row["State"]);
return model;
}
