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