public DataSet getFaultInfos(DateTime starDateTime, DateTime endDateTime, string unitName, string responsibleUserName, string serviceStyle)
{
ArrayList paraList = new ArrayList();
MySqlParameter paraStartTime = new MySqlParameter("@paraStartTime", starDateTime);
MySqlParameter paraEndTime = new MySqlParameter("@paraEndTime", endDateTime);
MySqlParameter paraUnitName = new MySqlParameter("@paraUnitName", unitName);
MySqlParameter paraResponsibleUserName = new MySqlParameter("@paraResponsibleUserName", responsibleUserName);
MySqlParameter paraServiceStyle = new MySqlParameter("@paraServiceStyle", serviceStyle);
paraList.Add(paraStartTime);
paraList.Add(paraEndTime);
string sql = "SELECT a.`equip_name`,a.`equip_version`,a.`falut_info`,a.`maintenance_mode`,a.`spare_part_name`,a.`spare_part_version`,a.`spare_part_specification`,a.`spare_part_count`,a.`service_id`,b.`start_date`,b.`end_date` FROM `falut_infos` a,`services` b WHERE b.`start_date` > @paraStartTime and b.`end_date` < @paraEndTime and a.service_id = b.id";
if (unitName != "全部" && unitName != "请选择单位")
{
sql += "and b.unit_name = @paraUnitName ";
paraList.Add(paraUnitName);
}
if (responsibleUserName != "全部" && responsibleUserName != "请选择带队人")
{
sql += "and b.responsible_user_name = @paraResponsibleUserName ";
paraList.Add(paraResponsibleUserName);
}
if (serviceStyle != "全部" && serviceStyle != "请选择服务类型")
{
sql += "and b.service_style = @paraServiceStyle";
paraList.Add(paraServiceStyle);
}
return(MySqlHelper.GetDataSet(MySqlHelper.conn, CommandType.Text, sql, (MySqlParameter[])paraList.ToArray(typeof(MySqlParameter))));
}
public void addOrUpdateCustomer(string customerId, string unitName, string address, string responsibleUserName, string tel, string fax, string email)
{
try
{
MySqlParameter paraUnitName = new MySqlParameter("@paraUnitName", unitName);
MySqlParameter paraAddress = new MySqlParameter("@paraAddress", address);
MySqlParameter paraResponsibleUserName = new MySqlParameter("@paraResponsibleUserName", responsibleUserName);
MySqlParameter paraTel = new MySqlParameter("@paraTel", tel);
MySqlParameter paraFax = new MySqlParameter("@paraFax", fax);
MySqlParameter paraEmail = new MySqlParameter("@paraEmail", email);
if (customerId != string.Empty)
{
MySqlParameter paraId = new MySqlParameter("@paraId", customerId);
string sql = "update customer set unit_name = @paraUnitName,address = @paraAddress,responsible_user_name = @paraResponsibleUserName,tel = @paraTel,fax = @paraFax, email = @paraEmail where id = @paraId";
MySqlHelper.ExecuteNonQuery(common.MySqlHelper.conn, CommandType.Text, sql, paraUnitName, paraAddress, paraResponsibleUserName, paraTel, paraFax, paraEmail, paraId);
}
else
{
string sql = "insert into customer(unit_name,address,responsible_user_name,tel,fax,email) values(@paraUnitName,@paraAddress,@paraResponsibleUserName,@paraTel,@paraFax,@paraEmail)";
MySqlHelper.ExecuteNonQuery(MySqlHelper.conn, CommandType.Text, sql, paraUnitName, paraAddress, paraResponsibleUserName, paraTel, paraFax, paraEmail);
}
}
catch (Exception exception)
{
LogHelper.WriteLog(typeof(FormAddCustomer), exception.ToString());
}
}
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 void addFaultInfo(List <FalutInfo> falutInfos)
{
int serviceId = serviceInfoDao.getMaxId();
try
{
foreach (FalutInfo falutInfo in falutInfos)
{
MySqlParameter paraEquipName = new MySqlParameter("@paraEquipName", falutInfo.equipName);
MySqlParameter paraEquipVersion = new MySqlParameter("@paraEquipVersion", falutInfo.equipVersion);
MySqlParameter paraFalutInfo = new MySqlParameter("@paraFalutInfo", falutInfo.falutInfo);
MySqlParameter paraMaintenanceMode = new MySqlParameter("@paraMaintenanceMode", falutInfo.maintenance);
MySqlParameter paraSparePartName = new MySqlParameter("@paraSparePartName", falutInfo.sparePartName);
MySqlParameter paraSparePartVersion = new MySqlParameter("@paraSparePartVersion", falutInfo.sparePartVersion);
MySqlParameter paraSparePartSpecification = new MySqlParameter("@paraSparePartSpecification", falutInfo.sparePartSpecification);
MySqlParameter paraSparePartPartCount = new MySqlParameter("@paraSparePartPartCount", falutInfo.sparePartCount);
MySqlParameter ParaServiceId = new MySqlParameter("@ParaServiceId", serviceId);
string sql =
"INSERT INTO `falut_infos`(`equip_name`,`equip_version`,`falut_info`,`maintenance mode`,`spare_part_name`,`spare_part_version`,`spare_part_specification`,`spare_part_count`,`service_id`) values(@paraEquipName,@paraEquipVersion,@paraFalutInfo,@paraMaintenanceMode,@paraSparePartName,@paraSparePartVersion,@paraSparePartSpecification,@paraSparePartPartCount,@ParaServiceId)";
MySqlHelper.ExecuteNonQuery(MySqlHelper.conn, CommandType.Text, sql, paraEquipName, paraEquipVersion, paraFalutInfo, paraMaintenanceMode, paraSparePartName, paraSparePartVersion,
paraSparePartSpecification, paraSparePartPartCount, ParaServiceId);
}
}
catch (Exception e)
{
LogHelper.WriteLog(typeof(FalutInfoDao), e.ToString());
throw;
}
}
public void addOrUpdateUser(string userId, string userName, string department, string postion, string tel)
{
try
{
MySqlParameter paraUserName = new MySqlParameter("@paraUserName", userName);
MySqlParameter paraDepartment = new MySqlParameter("@paraDepartment", department);
MySqlParameter paraPostion = new MySqlParameter("@paraPosition", postion);
MySqlParameter paraTel = new MySqlParameter("@paraTel", tel);
string sql;
if (userId != string.Empty)
{
MySqlParameter paraId = new MySqlParameter("@paraId", userId);
sql = "update user set user_name = @paraUserName, department = @paraDepartment, position = @paraPosition, tel = @paratel where id = @paraId";
MySqlHelper.ExecuteNonQuery(common.MySqlHelper.conn, CommandType.Text, sql, paraUserName, paraDepartment, paraPostion, paraTel, paraId);
}
else
{
sql = "insert into user(user_name,department,position,tel) values(@paraUserName,@paraDepartment,@paraPosition,@paraTel)";
MySqlHelper.ExecuteNonQuery(MySqlHelper.conn, CommandType.Text, sql, paraUserName, paraDepartment, paraPostion, paraTel);
}
}
catch (Exception exception)
{
LogHelper.WriteLog(typeof(FormAddUser), exception.ToString());
}
}
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 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 void addOrUpdateEquip(string equipId, string name, string number, string version, string specification)
{
try
{
var paraName = new MySqlParameter("@paraName", name);
var paraNumber = new MySqlParameter("@paraNumber", number);
var paraVersion = new MySqlParameter("@paraVersion", version);
var paraSpecification = new MySqlParameter("@paraSpecification", specification);
if (equipId != string.Empty)
{
var paraId = new MySqlParameter("@paraId", equipId);
var sql = "update equips set name = @paraName, number = @paraNumber, version = @paraVersion, specification = @paraSpecification where id = @paraId";
MySqlHelper.ExecuteNonQuery(MySqlHelper.conn, CommandType.Text, sql, paraName, paraNumber, paraVersion, paraSpecification, paraId);
}
else
{
var sql = "insert into equips(name,number,version,specification) values(@paraName,@paraNumber,@paraVersion,@paraSpecification)";
MySqlHelper.ExecuteNonQuery(MySqlHelper.conn, CommandType.Text, sql, paraName, paraNumber, paraVersion, paraSpecification);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(typeof(FormAddEquip), ex.ToString());
}
}
public DataSet getServiceInfos(DateTime starDateTime, DateTime endDateTime, string unitName, string responsibleUserName, string serviceStyle)
{
ArrayList paraList = new ArrayList();
MySqlParameter paraStartTime = new MySqlParameter("@paraStartTime", starDateTime);
MySqlParameter paraEndTime = new MySqlParameter("@paraEndTime", endDateTime);
MySqlParameter paraUnitName = new MySqlParameter("@paraUnitName", unitName);
MySqlParameter paraResponsibleUserName = new MySqlParameter("@paraResponsibleUserName", responsibleUserName);
MySqlParameter paraServiceStyle = new MySqlParameter("@paraServiceStyle", serviceStyle);
paraList.Add(paraStartTime);
paraList.Add(paraEndTime);
string sql =
"SELECT `info_name`,`receiver_name`,`work_order_number`,`unit_name`,`responsible_customer_name`,`responsible_customer_tel`,`responsible_user_name`,`start_date`,`end_date`,`user_names`,`service_style`,`return_money` FROM services where start_date > @paraStartTime and end_date < @paraEndTime ";
if (unitName != "全部" && unitName != "请选择单位")
{
sql += "and unit_name = @paraUnitName ";
paraList.Add(paraUnitName);
}
if (responsibleUserName != "全部" && responsibleUserName != "请选择带队人")
{
sql += "and responsible_user_name = @paraResponsibleUserName ";
paraList.Add(paraResponsibleUserName);
}
if (serviceStyle != "全部" && serviceStyle != "请选择服务类型")
{
sql += "and service_style = @paraServiceStyle";
paraList.Add(paraServiceStyle);
}
return(MySqlHelper.GetDataSet(MySqlHelper.conn, CommandType.Text, sql, (MySqlParameter[])paraList.ToArray(typeof(MySqlParameter))));
}
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 void addServiceInfo(ServiceInfo serviceInfo)
{
try
{
MySqlParameter paraInfoName = new MySqlParameter("@paraInfoName", serviceInfo.infoName);
MySqlParameter paraReceiverName = new MySqlParameter("@paraReceiverName", serviceInfo.receiverName);
MySqlParameter paraBrief = new MySqlParameter("@paraBrief", serviceInfo.brief);
MySqlParameter paraBasicInfo = new MySqlParameter("@paraBasicInfo", serviceInfo.basicInfo);
MySqlParameter paraWorkOrderNumber = new MySqlParameter("@paraWorkOrderNumber", serviceInfo.workOderNumber);
MySqlParameter paraUnitName = new MySqlParameter("@paraUnitName", serviceInfo.unitName);
MySqlParameter paraAddress = new MySqlParameter("@paraAddress", serviceInfo.address);
MySqlParameter paraResponsibleCustomerName = new MySqlParameter("@paraResponsibleCustomerName", serviceInfo.responsibleCustomerName);
MySqlParameter paraResponsibleCustomerTel = new MySqlParameter("@paraResponsibleCustomerTel", serviceInfo.responsibleCustomerTel);
MySqlParameter paraResponsibleCustomerFax = new MySqlParameter("@paraResponsibleCustomerFax", serviceInfo.responsibleCustomerFax);
MySqlParameter paraResponsibleUserName = new MySqlParameter("@paraResponsibleUserName", serviceInfo.responsibleUserName);
MySqlParameter paraResponsibleUserTel = new MySqlParameter("@paraResponsibleUserTel", serviceInfo.responsibleUserTel);
MySqlParameter paraStartDate = new MySqlParameter("@paraStartDate", serviceInfo.startDate);
MySqlParameter paraEndDate = new MySqlParameter("@paraEndDate", serviceInfo.endDate);
MySqlParameter paraUserNames = new MySqlParameter("@paraUserNames", serviceInfo.userNames);
MySqlParameter paraUserCount = new MySqlParameter("@paraUserCount", serviceInfo.userCount);
MySqlParameter paraServiceStyle = new MySqlParameter("@paraServiceStyle", serviceInfo.serviceStyle);
MySqlParameter paraEquipsCount = new MySqlParameter("@paraEquipsCount", serviceInfo.equipsCount);
MySqlParameter paraFalutInfo = new MySqlParameter("@paraFalutInfo", serviceInfo.faultInfo);
MySqlParameter paraReturnMoney = new MySqlParameter("@paraReturnMoney", serviceInfo.returnMoney);
MySqlParameter paraExplain = new MySqlParameter("@paraExplain", serviceInfo.explain);
MySqlParameter paraSatisfiedQuality = new MySqlParameter("@paraSatisfiedQuality", serviceInfo.satisfiedQuality);
MySqlParameter paraSatisfiedService = new MySqlParameter("@paraSatisfiedService", serviceInfo.satisfiedService);
MySqlParameter paraSatisfiedDeliver = new MySqlParameter("@paraSatisfiedDeliver", serviceInfo.satisfiedDeliver);
MySqlParameter paraSatisfiedPrice = new MySqlParameter("@paraSatisfiedPrice", serviceInfo.satisfiedPrice);
MySqlParameter paraSuggestAppearance = new MySqlParameter("@paraSuggestAppearance", serviceInfo.suggestAppearance);
MySqlParameter paraSuggestAttitude = new MySqlParameter("@paraSuggestAttitude", serviceInfo.suggestAttitude);
MySqlParameter paraSuggestPrice = new MySqlParameter("@paraSuggestPrice", serviceInfo.suggestPrice);
string sql =
"insert into services(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) values(@paraInfoName,@paraReceiverName,@paraBrief,@paraBasicInfo,@paraWorkOrderNumber,@paraUnitName,@paraAddress,@paraResponsibleCustomerName,@paraResponsibleCustomerTel,@paraResponsibleCustomerFax,@paraResponsibleUserName,@paraStartDate,@paraEndDate,@paraUserNames,@paraUserCount,@paraServiceStyle,@paraEquipsCount,@paraFalutInfo,@paraReturnMoney,@paraExplain,@paraSatisfiedQuality,@paraSatisfiedService,@paraSatisfiedDeliver,@paraSatisfiedPrice,@paraSuggestAppearance,@paraSuggestAttitude,@paraSuggestPrice)";
MySqlHelper.ExecuteNonQuery(MySqlHelper.conn, CommandType.Text, sql, paraInfoName, paraReceiverName, paraBrief, paraBasicInfo, paraWorkOrderNumber, paraUnitName, paraAddress,
paraResponsibleCustomerName, paraResponsibleCustomerTel, paraResponsibleCustomerFax, paraResponsibleUserName, paraResponsibleUserTel, paraStartDate, paraEndDate, paraUserNames,
paraUserCount, paraServiceStyle, paraEquipsCount, paraFalutInfo, paraReturnMoney, paraExplain, paraSatisfiedQuality, paraSatisfiedService, paraSatisfiedDeliver, paraSatisfiedPrice,
paraSuggestAppearance, paraSuggestAttitude, paraSuggestPrice);
}
catch (Exception e)
{
LogHelper.WriteLog(typeof(ServiceInfoDao), e.ToString());
throw;
}
}
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 void addOrUpdateSparePart(string sparePartId, string SparePartName, string SparePartVersion, string SparePartSpecification)
{
try
{
MySqlParameter paraPartName = new MySqlParameter("@paraPartName", SparePartName);
MySqlParameter paraPartVersion = new MySqlParameter("@paraPartVesion", SparePartVersion);
MySqlParameter paraPartSpecification = new MySqlParameter("@paraPartSpecification", SparePartSpecification);
if (sparePartId != string.Empty)
{
MySqlParameter paraId = new MySqlParameter("@paraId", sparePartId);
string sql = "update spare_parts set spare_part_name = @paraPartName, spare_part_version = @paraPartVesion, spare_part_specification = @paraPartSpecification where id = @paraId";
MySqlHelper.ExecuteNonQuery(common.MySqlHelper.conn, CommandType.Text, sql, paraPartName, paraPartVersion, paraPartSpecification, paraId);
}
else
{
string sql = "insert into spare_parts(spare_part_name,spare_part_version,spare_part_specification) values(@paraPartName,@paraPartVesion,@paraPartSpecification)";
MySqlHelper.ExecuteNonQuery(MySqlHelper.conn, CommandType.Text, sql, paraPartName, paraPartVersion, paraPartSpecification);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(typeof(FormAddSparePart), ex.ToString());
}
}
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);
}