public HttpResponseMessage AddUser(EQM_EQUIP_TYPE Type) { //IList<EQM_EQUIP_TYPE> list = new List<EQM_EQUIP_TYPE>(); //list = typeBO.GetAll(); ////log.Debug(JsonConvert.SerializeObject(list)); //for (int i = 0; i < list.Count; i++) //{ // if (Type.ExamType == list[i].ExamType)//如果类型相同则对比 // { // if (Type.LowerBound < list[i].UpperBound && Type.LowerBound >= list[i].LowerBound) // //return Request.CreateResponse(HttpStatusCode.InternalServerError, "下限值输入有误!"); // return Request.CreateResponse(HttpStatusCode.OK, "下限值输入有误!"); // if (Type.UpperBound <= list[i].UpperBound && Type.UpperBound > list[i].LowerBound) // //return Request.CreateResponse(HttpStatusCode.InternalServerError, "上限值输入有误!"); // return Request.CreateResponse(HttpStatusCode.OK, "上限值输入有误!"); // } //} EQM_EQUIP_TYPE newType = this.typeBO.Insert(Type); if (newType != null) { return(Request.CreateResponse(HttpStatusCode.OK, "新增成功")); } else { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "新增失败")); } }
public DataTable getcount(EQM_EQUIP_TYPE tp) { DataTable list = null; string Sql = @" select count(*) from EQM_EQUIP_TYPE "; list = BSCBO.GetDataTableBySql(Sql); return(list); //return Request.CreateResponse(HttpStatusCode.OK, Sql); }
public DataTable getType(EQM_EQUIP_TYPE tp) { //get后,post传输数据量大,网址后面不会接数据 DataTable list = null; string Sql = @" select distinct EquipType from EQM_EQUIP_TYPE where 1=1 "; list = BSCBO.GetDataTableBySql(Sql); return(list); }
public HttpResponseMessage UpdateUser(EQM_EQUIP_TYPE user) { try { typeBO.UpdateSome(user); return(Request.CreateResponse(HttpStatusCode.OK, "更新成功")); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "更新出错:" + ex.Message)); } }
public int SynEquipMainData() { //bool middleNew = false; int result = -3; Dictionary <string, List <string> > dictionary = new Dictionary <string, List <string> >(); DateTime now = DateTime.Now; //Guid TypeGuid = Guid.Empty, ClassGuid = Guid.Empty, SpecGuid = Guid.Empty; IList <EQM_EQUIP_TYPE> typedata = null; IList <EQM_EQUIP_CLASS> classdata = null; //获得中间表中获得数据 IList <EQM_SAP_MES_MAIN_DATA> tmpList = eQM_MAIN_DATA.getTempDeviceInstances(); //判断存在未同步的数据 if (tmpList != null && tmpList.Count > 0) { //try //{ using (TransactionScope ts = new TransactionScope()) { //遍历 foreach (EQM_SAP_MES_MAIN_DATA tempIqc in tmpList) { //先判断对应设备编号是否存在 IList <DM_DEVICE_INSTANCE> equpmaindata = dEVICE_INSTANCE_DATA.getexist(tempIqc.EQUNR); #region 台账信息表 //设备编号,设备名称,位置 ,类别 ,等级,固定资产编号,设备规格型号,型号,规格,设备厂商,出厂日期,使用部门,使用人,使用期限,安装日期,投产日期,设备状态 DM_DEVICE_INSTANCE dev = new DM_DEVICE_INSTANCE() { DeviceID = tempIqc.EQUNR, //设备编号 DeviceName = tempIqc.EQKTU, // DeviceType = tempIqc.Attribute02, // 大类 DeviceClass = tempIqc.CLASS, // EQTYP = tempIqc.EQTYP, //设备种类 新增 FixedAssetID = tempIqc.ANLNR, // Model = tempIqc.TYPBZ, // DeviceFirm = tempIqc.ZZGYS, // LiveTime = tempIqc.NDJAR, // DeviceStatus = tempIqc.STAT, // WERK = tempIqc.WERK, // WorkShop = tempIqc.STORT, // DeviceDepartment = tempIqc.ZSYBM, // DeviceUser = tempIqc.ZZSYR, // ABCKZ = tempIqc.ABCKZ, // Standard = tempIqc.ATWRT, // DeviceSpecID = tempIqc.TYPBZ + " " + tempIqc.ATWRT, buildTime = tempIqc.BAUJJ }; if (!string.IsNullOrEmpty(tempIqc.ANSDT)) { dev.ProductionDate = Convert.ToDateTime(tempIqc.ANSDT); } if (!string.IsNullOrEmpty(tempIqc.INBDT)) { dev.StartDate = Convert.ToDateTime(tempIqc.INBDT); } if (equpmaindata.Count == 0) { dEVICE_INSTANCE_DATA.Insert(dev); } else { dEVICE_INSTANCE_DATA.UpdateSome(dev); } #endregion #region 大中小类表 //判定表里是否已经存在改大类 IList <EQM_EQUIP_TYPE> typelist = typeBO.getexist(tempIqc.Attribute02); if (typelist.Count == 0) { //TypeGuid = Guid.NewGuid(); EQM_EQUIP_TYPE type = new EQM_EQUIP_TYPE() { EquipType = tempIqc.Attribute02, }; typeBO.Insert(type); } else //已经存在该设备大类,则根据该条数据的kid进行更新设备大类 { //TypeGuid = Guid.NewGuid(); EQM_EQUIP_TYPE type = new EQM_EQUIP_TYPE() { EquipTypeID = typelist[0].EquipTypeID, EquipType = tempIqc.Attribute02, }; typeBO.UpdateSome(type); } //插入/更新数据后,查询出大类ID typedata = typeBO.getexist(tempIqc.Attribute02); //判断中类表里是否已经存在此中类 IList <EQM_EQUIP_CLASS> classlist = classBO.getexist(tempIqc.EQKTU); if (classlist.Count == 0) { //ClassGuid = Guid.NewGuid(); EQM_EQUIP_CLASS mclass = new EQM_EQUIP_CLASS() { typeKID = typedata[0].EquipTypeID, EquipClass = tempIqc.EQKTU }; classBO.Insert(mclass); } else //已经存在该设备大类,则根据该条数据的kid进行更新设备大类 { EQM_EQUIP_CLASS mclass = new EQM_EQUIP_CLASS() { typeKID = typedata[0].EquipTypeID, EquipClassID = classlist[0].EquipClassID, EquipClass = tempIqc.EQKTU }; classBO.UpdateSome(mclass); } classdata = classBO.getexist(tempIqc.EQKTU); //判断小类表里是否已经存在此小类 IList <EQM_EQUIP_SPEC> speclist = specBO.getexist(tempIqc.ATWRT, tempIqc.TYPBZ); if (speclist.Count == 0) { //ClassGuid = Guid.NewGuid(); EQM_EQUIP_SPEC spec = new EQM_EQUIP_SPEC() { classKID = classdata[0].EquipClassID, //中类ID EquipSpec = tempIqc.TYPBZ + " " + tempIqc.ATWRT //小类 等于规格+型号 }; specBO.Insert(spec); } else { EQM_EQUIP_SPEC spec = new EQM_EQUIP_SPEC() { classKID = classdata[0].EquipClassID, //中类ID EquipSpecID = speclist[0].EquipSpecID, EquipSpec = tempIqc.TYPBZ + " " + tempIqc.ATWRT //小类 等于规格+型号 }; specBO.UpdateSome(spec); } tempIqc.STATE = "1"; //更新中间表 state字段为1 eQM_MAIN_DATA.Update(tempIqc); //log.Info("finish"); #endregion } ts.Complete(); result = 0; //同步成功 } //} //catch (Exception ex) //{ // result = -1; //同步失败 //} } else { result = -2; //没有要同步的数据 } //ILog log = LogManager.GetLogger(typeof(EQM_EQUIP_TYPEController)); return(result); }