点滴积累【C#】---初始页面自动给站点名称赋值
初始页面自动给站点名称赋值
效果：
说明：点击进入添加页面时，Textbox文本框中自动给站点名称赋值
代码：
1 private string userzdmc; 2 public string Userzdmc 3 { 4 get 5 { 6 return userzdmc; 7 } 8 set 9 { 10 userzdmc = value; 11 } 12 } 13 14 /// <summary> 15 /// 用登录名创建User 16 /// </summary> 17 /// <param name="loginID"></param> 18 /// <returns></returns> 19 public static Users CreateUserByLoginID(string loginID) 20 { 21 Users user = new Users(); 22 string sql = @"select UserID,LoginID,UserName,UserPassword ,zdmc from UserManagement 23 WHERE LoginID=@LoginID"; 24 DbCommand sqlCommand = ERPDataBase.ERPDB.GetSqlStringCommand(sql); 25 ERPDataBase.ERPDB.AddInParameter(sqlCommand, "@LoginID", DbType.String, loginID); 26 DataSet ds = new DataSet(); 27 ERPDataBase.ERPDB.LoadDataSet(sqlCommand, ds, new string[] { "user" }); 28 if (ds.Tables["user"].Rows.Count > 0) 29 { 30 DataRow row = ds.Tables["user"].Rows[0]; 31 GiveUserValue(row, user); 32 } 33 return user; 34 } 35 36 protected static void GiveUserValue(DataRow row, Users user) 37 { 38 user.userID = row["UserID"] == DBNull.Value ? string.Empty : row["UserID"].ToString(); 39 user.userName = row["UserName"] == DBNull.Value ? string.Empty : row["UserName"].ToString(); 40 user.userPass = row["UserPassword"] == DBNull.Value ? string.Empty : row["UserPassword"].ToString(); 41 user.loginID = row["LoginID"] == DBNull.Value ? string.Empty : row["LoginID"].ToString(); 42 user.userzdmc = row["zdmc"] == DBNull.Value ? string.Empty : row["zdmc"].ToString(); 43 }
调用：
1 protected void Page_Load(object sender, EventArgs e) 2 { 3 Response.Expires = -1; 4 if (!IsPostBack) 5 { 6 7 if (ActionType == CommonEnum.ActionLevel.Write) 8 { 9 tbzdmc.Text = ERPUser.Userzdmc; 10 } 11 } 12 }
