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; }