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