/*
* 返回所有的店员
* */
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 ? "经理" : "店员";
}
