public List <UserInfo> getAllUserInfo() { List <UserInfo> userInfos = new List <UserInfo>(); try { string sql = "select user_name,department,position,tel from user"; MySqlDataReader mySqlDataReader = MySqlHelper.ExecuteReader(MySqlHelper.conn, CommandType.Text, sql, null); while (mySqlDataReader.Read()) { UserInfo userInfo = new UserInfo { userName = (string)mySqlDataReader["user_name"], department = (string)mySqlDataReader["department"], position = (string)mySqlDataReader["position"], tel = (string)mySqlDataReader["tel"] }; userInfos.Add(userInfo); } mySqlDataReader.Close(); } catch (Exception exception) { LogHelper.WriteLog(typeof(FormAddUser), exception.ToString()); } return(userInfos); }
public List <SparePart> getAllSparePart() { List <SparePart> spareParts = new List <SparePart>(); try { string sql = "select spare_part_name,spare_part_version,spare_part_specification from spare_parts"; MySqlDataReader mySqlDataReader = MySqlHelper.ExecuteReader(MySqlHelper.conn, CommandType.Text, sql, null); while (mySqlDataReader.Read()) { SparePart sparePart = new SparePart { sparePartName = (string)mySqlDataReader["spare_part_name"], sparePartVersion = (string)mySqlDataReader["spare_part_version"], sparePartSpecification = (string)mySqlDataReader["spare_part_specification"] }; spareParts.Add(sparePart); } mySqlDataReader.Close(); } catch (Exception ex) { LogHelper.WriteLog(typeof(FormAddSparePart), ex.ToString()); } return(spareParts); }
public UserInfo getUserInfo(string userId) { UserInfo userInfo = new UserInfo(); try { if (userId != string.Empty) { MySqlParameter paraUserId = new MySqlParameter("paraUserId", userId); string sql = "select user_name,department,position,tel from user where id = @paraUserId"; MySqlDataReader mySqlDataReader = MySqlHelper.ExecuteReader(MySqlHelper.conn, CommandType.Text, sql, paraUserId); if (mySqlDataReader.Read()) { userInfo.userName = (string)mySqlDataReader["user_name"]; userInfo.department = (string)mySqlDataReader["department"]; userInfo.position = (string)mySqlDataReader["position"]; userInfo.tel = (string)mySqlDataReader["tel"]; } mySqlDataReader.Close(); } } catch (Exception exception) { LogHelper.WriteLog(typeof(FormAddUser), exception.ToString()); } return(userInfo); }
public SparePart getSparePart(string sparePartId) { SparePart sparePart = new SparePart(); try { if (sparePartId != String.Empty) { MySqlParameter paraId = new MySqlParameter("@paraId", sparePartId); string sql = "select spare_part_name,spare_part_version,spare_part_specification from spare_parts where id = @paraId"; MySqlDataReader mySqlDataReader = MySqlHelper.ExecuteReader(MySqlHelper.conn, CommandType.Text, sql, paraId); if (mySqlDataReader.Read()) { sparePart.sparePartName = (string)mySqlDataReader["spare_part_name"]; sparePart.sparePartVersion = (string)mySqlDataReader["spare_part_version"]; sparePart.sparePartSpecification = (string)mySqlDataReader["spare_part_specification"]; } mySqlDataReader.Close(); } } catch (Exception ex) { LogHelper.WriteLog(typeof(FormAddSparePart), ex.ToString()); } return(sparePart); }
public ServiceInfo getServiceInfoByOrderNumber(string orderNumber) { ServiceInfo serviceInfo = null; MySqlParameter paraOrderNumber = new MySqlParameter("@paraOrderNumber", orderNumber); string sql = "select info_name,receiver_name,brief,basic_info,work_order_number,unit_name,address,responsible_customer_name,responsible_customer_tel,responsible_customer_fax,responsible_user_name,start_date,end_date,user_names,user_count,service_style,equips_count,falut_info,return_money,`explain`,satisfied_quality,satisfied_service,satisfied_deliver,satisfied_price,suggest_appearance,suggest_attitude,suggest_price from services where work_order_number = @paraOrderNumber"; MySqlDataReader mySqlDataReader = MySqlHelper.ExecuteReader(MySqlHelper.conn, CommandType.Text, sql, paraOrderNumber); while (mySqlDataReader.Read()) { ServiceInfo newServiceInfo = new ServiceInfo() { infoName = mySqlDataReader.GetString("info_name"), receiverName = mySqlDataReader.GetString("receiver_name"), brief = mySqlDataReader.GetString("brief"), basicInfo = mySqlDataReader.GetString("basic_info"), workOderNumber = mySqlDataReader.GetString("work_order_number"), unitName = mySqlDataReader.GetString("unit_name"), address = mySqlDataReader.GetString("address"), responsibleCustomerName = mySqlDataReader.GetString("responsible_customer_name"), responsibleCustomerTel = mySqlDataReader.GetString("responsible_customer_tel"), responsibleCustomerFax = mySqlDataReader.GetString("responsible_customer_fax"), responsibleUserName = mySqlDataReader.GetString("responsible_user_name"), // responsibleUserTel = mySqlDataReader.GetString("responsible_user_tel"), startDate = mySqlDataReader.GetDateTime("start_date"), endDate = mySqlDataReader.GetDateTime("end_date"), userNames = mySqlDataReader.GetString("user_names"), userCount = mySqlDataReader.GetString("user_count"), serviceStyle = mySqlDataReader.GetString("service_style"), equipsCount = mySqlDataReader.GetString("equips_count"), faultInfo = "", returnMoney = mySqlDataReader.GetString("return_money"), explain = mySqlDataReader.GetString("explain"), satisfiedQuality = mySqlDataReader.GetString("satisfied_quality"), satisfiedService = mySqlDataReader.GetString("satisfied_service"), satisfiedDeliver = mySqlDataReader.GetString("satisfied_deliver"), satisfiedPrice = mySqlDataReader.GetString("satisfied_price"), suggestAppearance = mySqlDataReader.GetString("suggest_appearance"), suggestAttitude = mySqlDataReader.GetString("suggest_attitude"), suggestPrice = mySqlDataReader.GetString("suggest_price") }; serviceInfo = newServiceInfo; } return(serviceInfo); }
public List <Equip> getAllEquip() { var equips = new List <Equip>(); var sql = "select name,number,version,specification from equips"; var mySqlDataReader = MySqlHelper.ExecuteReader(MySqlHelper.conn, CommandType.Text, sql, null); while (mySqlDataReader.Read()) { var equip = new Equip(); equip.name = (string)mySqlDataReader["name"]; equip.number = (string)mySqlDataReader["number"]; equip.version = (string)mySqlDataReader["version"]; equip.specification = (string)mySqlDataReader["specification"]; equips.Add(equip); } mySqlDataReader.Close(); return(equips); }
public CustomerInfo getCustomerInfoByUnitName(string unitName) { CustomerInfo customerInfo = new CustomerInfo(); MySqlParameter paraUnitName = new MySqlParameter("@unitName", unitName); string sql = "select unit_name,address,responsible_user_name,tel,fax,email from customer where unit_name = @unitName"; MySqlDataReader mySqlDataReader = MySqlHelper.ExecuteReader(MySqlHelper.conn, CommandType.Text, sql, paraUnitName); if (mySqlDataReader.Read()) { customerInfo.unitName = (string)mySqlDataReader["unit_name"]; customerInfo.address = (string)mySqlDataReader["address"]; customerInfo.responsibleUserName = (string)mySqlDataReader["responsible_user_name"]; customerInfo.tel = (string)mySqlDataReader["tel"]; customerInfo.fax = (string)mySqlDataReader["fax"]; customerInfo.email = (string)mySqlDataReader["email"]; } mySqlDataReader.Close(); return(customerInfo); }
public Equip getEquip(string equipId) { var equip = new Equip(); if (equipId != string.Empty) { var paraId = new MySqlParameter("@paraId", equipId); var sql = "select name,number,version,specification from equips where id = @paraId"; var mySqlDataReader = MySqlHelper.ExecuteReader(MySqlHelper.conn, CommandType.Text, sql, paraId); if (mySqlDataReader.Read()) { equip.name = (string)mySqlDataReader["name"]; equip.number = (string)mySqlDataReader["number"]; equip.version = (string)mySqlDataReader["version"]; equip.specification = (string)mySqlDataReader["specification"]; } mySqlDataReader.Close(); } return(equip); }
public int getMaxId() { int maxId = 0; try { string sql = "select max(id) from services"; MySqlDataReader mySqlDataReader = MySqlHelper.ExecuteReader(MySqlHelper.conn, CommandType.Text, sql, null); if (mySqlDataReader.Read()) { maxId = (int)mySqlDataReader["max(id)"]; } mySqlDataReader.Close(); } catch (Exception e) { LogHelper.WriteLog(typeof(ServiceInfo), e.ToString()); throw; } return(maxId); }
public List <CustomerInfo> getAllCustomerInfo() { List <CustomerInfo> customerInfos = new List <CustomerInfo>(); { string sql = "select unit_name,address,responsible_user_name,tel,fax,email from customer"; MySqlDataReader mySqlDataReader = MySqlHelper.ExecuteReader(MySqlHelper.conn, CommandType.Text, sql, null); while (mySqlDataReader.Read()) { CustomerInfo customerInfo = new CustomerInfo { unitName = (string)mySqlDataReader["unit_name"], address = (string)mySqlDataReader["address"], responsibleUserName = (string)mySqlDataReader["responsible_user_name"], tel = (string)mySqlDataReader["tel"], fax = (string)mySqlDataReader["fax"], email = (string)mySqlDataReader["email"] }; customerInfos.Add(customerInfo); } mySqlDataReader.Close(); } return(customerInfos); }