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