/* * 返回所有的店员 * */ public static List <ManagerInfoData> GetManagerInfoDatas() { String connectStr = ConnectorInfo.connectStr; MySqlConnection conn = new MySqlConnection(connectStr); conn.Open(); List <ManagerInfoData> managerInfoDatas = new List <ManagerInfoData>(); String sql = "select MName,MType from managerinfo"; MySqlCommand mySqlCommand = new MySqlCommand(sql, conn); MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); while (mySqlDataReader.Read()) { ManagerInfoData managerInfoData = new ManagerInfoData( mySqlDataReader.GetString("MName"), mySqlDataReader.GetInt32("MType") ); managerInfoDatas.Add(managerInfoData); } return(managerInfoDatas); }
public InfomationTable(ManagerInfoData manager) { InitializeComponent(); Left_TB.Text = manager.MName; Right_TB.Text = manager.MType == 1 ? "经理" : "店员"; }