public string GetTeamStaticList(GetTeamStaticListM entity) { string retstr = "ok"; IPM_EM_TEAMBO ibo = ObjectContainer.BuildUp <IPM_EM_TEAMBO>(); IList <PM_EM_TEAM> list = new List <PM_EM_TEAM>(); if (entity != null) { try { PM_EM_TEAM_QueryParam ent = new PM_EM_TEAM_QueryParam(); ent.LineID = entity.Static; ent.TeamLeaderCardID = entity.User; list = ibo.GetEntities(ent); if (list == null || list.Count == 0) { retstr = "没有查看的权限!"; } } catch (Exception e) { throw e; } } else { return(null); } return(retstr); }
public string uploadPosition(string user) { string path = System.Web.HttpContext.Current.Server.MapPath("."); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } HttpRequest request = System.Web.HttpContext.Current.Request; //int i = request.Cookies.Count; HttpFileCollection FileCollect = request.Files; if (FileCollect.Count > 0) //如果集合的数量大于0 { foreach (string str in FileCollect) { HttpPostedFile FileSave = FileCollect[str]; //用key获取单个文件对象HttpPostedFile // string fileName = DateTime.Now.ToString("yyyyMMddhhmmss"); string savePath = path + "/" + FileSave.FileName; //通过此对象获取文件名 FileSave.SaveAs(savePath); //上传 //InputExcel(savePath);//导入数据库 IPM_EM_POSITIONBO PM_EM_EMPLOYEEBO = ObjectContainer.BuildUp <IPM_EM_POSITIONBO>(); string resul = PM_EM_EMPLOYEEBO.InputPosition(savePath, user); //导入数据库 return(resul); } } else { return("文件不存在!"); } return("true"); }
public CV_PM_WECHAT_DEPARTMENTBO() { cV_PM_WECHAT_DEPARTMENTDAO = ObjectContainer.BuildUp <ICV_PM_WECHAT_DEPARTMENTDAO>(); cv_PM_WECHAT_USER_DEPARTMENTBO = ObjectContainer.BuildUp <ICV_PM_WECHAT_USER_DEPARTMENTBO>(); pm_ALT_NOTIBO = ObjectContainer.BuildUp <IPM_ALT_NOTIBO>(); alt_BSC_BO = ObjectContainer.BuildUp <IALT_BSC_BO>(); }
public void Updateline(PM_BPM_LINE definitions) { definitions.CreatedOn = DateTime.Now; try { if (string.IsNullOrEmpty(definitions.PlantID)) { definitions.PlantID = "H006"; } definitions.UpdatedOn = DateTime.Now; if (string.IsNullOrEmpty(definitions.UpdatedBy)) { definitions.UpdatedBy = definitions.CreatedBy; } if (string.IsNullOrEmpty(definitions.WorkshopGuid.ToString())) { IPM_BPM_WORKSHOPBO WorkShopBO = ObjectContainer.BuildUp <IPM_BPM_WORKSHOPBO>(); PM_BPM_WORKSHOP_QueryParam pm = new PM_BPM_WORKSHOP_QueryParam(); pm.WorkshopID = definitions.DepartID; IList <PM_BPM_WORKSHOP> nn = WorkShopBO.GetEntities(pm); if (nn.Count > 0) { definitions.WorkshopGuid = nn[0].WorkshopGuid; } } //definitions.WorkshopGuid = definitions.CreatedBy; linebo.Update(definitions); } catch (Exception e) { throw e; } }
public MsgService(string name) //: base(name) { try { //_PM_ALT_EVENT_LOGBO = ObjectContainer.BuildUp<IPM_ALT_EVENT_LOGBO>(); //_cv_PM_ALT_EVENT_LOGBO = ObjectContainer.BuildUp<ICV_PM_ALT_EVENT_LOGBO>(); //_cv_PM_ALT_EVENT_TYPE_GRPBO = ObjectContainer.BuildUp<ICV_PM_ALT_EVENT_TYPE_GRPBO>(); //_pm_ALT_MESSAGEBO = ObjectContainer.BuildUp<IPM_ALT_MESSAGEBO>(); //_cv_PM_WECHAT_NOTIBO = ObjectContainer.BuildUp<Siemens.Simatic.Wechat.BusinessLogic.ICV_PM_WECHAT_NOTIBO>(); //_pm_WECHAT_NOTIBO = ObjectContainer.BuildUp<IPM_WECHAT_NOTIBO>(); //SM_CONFIG_KEYBO = ObjectContainer.BuildUp<ISM_CONFIG_KEYBO>(); alt_BSC_BO = ObjectContainer.BuildUp <IALT_BSC_BO>(); } catch (Exception e) { log.Error(e.Message, e); } //string strsql = "select sKey,sValue FROM SM_CONFIG_KEY WHERE sKey IN('SenderUser','SenderPwd','SenderAccount','SmtpServer','SmtpPort') "; //DataTable dt = alt_BSC_BO.GetDataTableBySql(strsql); //if (dt == null || dt.Rows.Count <= 0) //{ // return; //} //else //{ // foreach (DataRow dr in dt.Rows) // { // if (dr[0] == "SenderUser") // { // this.SenderUser = dr[1].ToString(); // } // else if (dr[0] == "SenderPwd") // { // this.SenderPassword = dr[1].ToString(); // } // else if (dr[0] == "SenderAccount") // { // this.SenderName = dr[1].ToString(); // } // else if (dr[0] == "SmtpServer") // { // this.SmtpServer = dr[1].ToString(); // } // else if (dr[0] == "SmtpPort") // { // this.SmtpPort = dr[1].ToString(); // } // } //} //this.SenderUser = SM_CONFIG_KEYBO.GetConfigKey("SenderUser").sValue; //this.SenderPassword = SM_CONFIG_KEYBO.GetConfigKey("SenderPwd").sValue; //this.SenderName = SM_CONFIG_KEYBO.GetConfigKey("SenderAccount").sValue; //this.SmtpServer = SM_CONFIG_KEYBO.GetConfigKey("SmtpServer").sValue; //this.SmtpPort = SM_CONFIG_KEYBO.GetConfigKey("SmtpPort").sValue; }
public string BindingTermSection(IList <CV_PM_BPM_TERMINAL_SECTION> param) { //检查该工段是否已经绑定该工位 try { string alreadyBindTerm = ""; foreach (var item in param) { PM_BPM_TERMINAL_SECTION_QueryParam chkModel = new PM_BPM_TERMINAL_SECTION_QueryParam(); chkModel.TerminalGuid = item.TerminalGuid; IList <PM_BPM_TERMINAL_SECTION> bindList = term_sectionBO.GetEntities(chkModel); string sql = "SELECT SectionName FROM PM_BPM_SECTION WHERE SectionGuid='{0}'"; sql = string.Format(sql, item.SectionGuid.ToString()); ICO_BSC_BO _CO_BSC_BO = ObjectContainer.BuildUp <ICO_BSC_BO>(); DataTable dt = _CO_BSC_BO.GetDataTableBySql(sql); if (dt == null || dt.Rows.Count == 0) { alreadyBindTerm += "工位:" + item.TerminalID + ",已绑定"; } else { if (bindList.Count != 0) { //如果该工位已经进行了绑定,则记录 alreadyBindTerm += "工位:" + item.TerminalID + ",已绑定至:" + dt.Rows[0][0].ToString() + "工段"; } else { //如果没有绑定,则添加 PM_BPM_TERMINAL_SECTION insrtModel = new PM_BPM_TERMINAL_SECTION(); insrtModel.TermSectionGuid = Guid.NewGuid(); insrtModel.TerminalGuid = item.TerminalGuid; insrtModel.SectionGuid = item.SectionGuid; insrtModel.CreatedOn = SSGlobalConfig.Now; insrtModel.UpdatedOn = insrtModel.CreatedOn; term_sectionBO.Insert(insrtModel); } } } if (!string.IsNullOrEmpty(alreadyBindTerm)) { //除去末位的逗号 alreadyBindTerm.Substring(0, alreadyBindTerm.Length - 2); return("[" + alreadyBindTerm + "],如需要修改,请先解绑!"); } else { return("绑定成功!"); } } catch (Exception ex) { return("系统异常:" + ex.Message); } }
public HttpResponseMessage Addline(PM_BPM_LINE definitions) { definitions.CreatedOn = DateTime.Now; CV_BPM_LINE_QueryParam lineQueray = new CV_BPM_LINE_QueryParam(); lineQueray.LineID = definitions.LineID; IList <CV_BPM_LINE> list = lineBO.GetEntities(lineQueray); if (list.Count != 0) { return(Request.CreateResponse(HttpStatusCode.OK, "该产线已经存在")); } else { definitions.CreatedOn = DateTime.Now; definitions.LineGuid = Guid.NewGuid(); if (string.IsNullOrEmpty(definitions.PlantID)) { definitions.PlantID = "H006"; } definitions.UpdatedOn = DateTime.Now; if (string.IsNullOrEmpty(definitions.UpdatedBy)) { definitions.UpdatedBy = definitions.CreatedBy; } if (string.IsNullOrEmpty(definitions.WorkshopGuid.ToString())) { IPM_BPM_WORKSHOPBO WorkShopBO = ObjectContainer.BuildUp <IPM_BPM_WORKSHOPBO>(); PM_BPM_WORKSHOP_QueryParam pm = new PM_BPM_WORKSHOP_QueryParam(); pm.WorkshopID = definitions.DepartID; IList <PM_BPM_WORKSHOP> nn = WorkShopBO.GetEntities(pm); if (nn.Count > 0) { definitions.WorkshopGuid = nn[0].WorkshopGuid; } } PM_BPM_LINE mmExt = linebo.Insert(definitions); if (mmExt != null) { return(Request.CreateResponse(HttpStatusCode.OK, "新增成功")); } else { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "新增失败")); } } }
public NotifyService() { InitializeComponent(); alt_BSC_BO = ObjectContainer.BuildUp <IALT_BSC_BO>(); //Alert_Interval = Convert.ToInt32(ConfigurationSettings.AppSettings["Alert_Interval"]); //this.tmrAlert.Interval = Alert_Interval; Notify_Interval = Convert.ToInt32(ConfigurationSettings.AppSettings["Notify_Interval"]); this.tmrNotify.Interval = Notify_Interval; //alt_BSC_BO.ExecuteNotifyAll(); //return; this.tmrNotify.Start(); Thread.Sleep(1000); }
public IList <PM_BPM_SECTION> GetLineSction(string lineid) { IPM_BPM_SECTIONBO sectionBO = ObjectContainer.BuildUp <IPM_BPM_SECTIONBO>(); IList <PM_BPM_SECTION> retlist = new List <PM_BPM_SECTION>(); try { PM_BPM_SECTION_QueryParam par = new PM_BPM_SECTION_QueryParam(); par.LineID = lineid; retlist = sectionBO.GetEntities(par); return(retlist); } catch (Exception ex) { return(retlist); } }
public IList <PM_BPM_LINE> GetAllLine() { IList <PM_BPM_LINE> list = new List <PM_BPM_LINE>(); //list = LineBO.GetAll(); string sql = @"SELECT [LineID], [LineName], [LineType], [LineDesc] FROM dbo.PM_BPM_LINE WHERE RowDeleted = '0' OR RowDeleted is null "; ICO_BSC_BO _CO_BSC_BO = ObjectContainer.BuildUp <ICO_BSC_BO>(); DataTable dt = _CO_BSC_BO.GetDataTableBySql(sql); for (int i = 0; i < dt.Rows.Count; i++) { PM_BPM_LINE line = new PM_BPM_LINE(); line.LineID = dt.Rows[i]["LineID"].ToString(); line.LineName = dt.Rows[i]["LineName"].ToString(); line.LineType = dt.Rows[i]["LineType"].ToString(); line.LineDesc = dt.Rows[i]["LineDesc"].ToString(); list.Add(line); } //log.Debug(JsonConvert.SerializeObject(list)); return(list); }
/// <summary> /// 频率设置 /// </summary> /// <param name="name"></param> public MainService(string name) { Name = name; _PM_ALT_BASEBO = ObjectContainer.BuildUp <IPM_ALT_BASEBO>(); _ICV_PM_EMAIL_NOTIBO = ObjectContainer.BuildUp <ICV_PM_EMAIL_NOTIBO>(); _ICV_PM_WECHAT_NOTIBO = ObjectContainer.BuildUp <ICV_PM_WECHAT_NOTIBO>(); // //1.load alert _alert = _PM_ALT_BASEBO.GetEntity(name); if (_alert == null) { _loopPeriod = new TimeSpan(0, 0, 300); } else { if (_alert.AlertInterval.HasValue) { _loopPeriod = new TimeSpan(0, 0, _alert.AlertInterval.Value); } else if (!string.IsNullOrEmpty(_alert.AlertTimePoints)) { _fixedTimers = new List <DateTime>(); foreach (string fixedTimer in _alert.AlertTimePoints.Split(',')) { if (string.IsNullOrEmpty(fixedTimer.Trim())) { continue; } // _fixedTimers.Add(Convert.ToDateTime(string.Format("2000-01-01 {0}:00", fixedTimer.Trim()))); } // _loopPeriod = new TimeSpan(0, 0, 60); } else //没有设置频率,默认5分钟 { _loopPeriod = new TimeSpan(0, 0, 300); } } }
public NotifyService(string name, MesLog mesLog) : base(name, mesLog) { try { // _PM_ALT_MESSAGEBO = ObjectContainer.BuildUp <IPM_ALT_MESSAGEBO>(); _CV_PM_WECHAT_NOTIBO = ObjectContainer.BuildUp <Siemens.Simatic.Wechat.BusinessLogic.ICV_PM_WECHAT_NOTIBO>(); _PM_WECHAT_NOTIBO = ObjectContainer.BuildUp <IPM_WECHAT_NOTIBO>(); } catch (Exception e) { // need EmailService instance to send email only. } this.SenderUser = ConfigurationManager.AppSettings["SenderUser"]; this.SenderPassword = ConfigurationManager.AppSettings["SenderPwd"]; this.SenderName = ConfigurationManager.AppSettings["SenderAccount"]; this.SmtpServer = ConfigurationManager.AppSettings["SmtpServer"]; this.SmtpPort = ConfigurationManager.AppSettings["SmtpPort"]; }
public object GetFeedingLocationByTerminalID(string terminalID) { IList <MM_FEEDING_LOCATION> list = new List <MM_FEEDING_LOCATION>(); ICO_BSC_BO co_BSC_BO = ObjectContainer.BuildUp <ICO_BSC_BO>(); string sql; if (terminalID.Length > 7) { terminalID = terminalID.Substring(0, 7); sql = @"SELECT * FROM dbo.MM_FEEDING_LOCATION WHERE FeedingLocation like '{0}_%'"; sql = string.Format(sql, terminalID); } else { sql = @"SELECT * FROM dbo.MM_FEEDING_LOCATION "; sql = string.Format(sql); } DataTable dtMaterial = co_BSC_BO.GetDataTableBySql(sql); if (dtMaterial == null) { sql = @"SELECT * FROM dbo.MM_FEEDING_LOCATION "; sql = string.Format(sql); dtMaterial = co_BSC_BO.GetDataTableBySql(sql); } foreach (DataRow dr in dtMaterial.Rows) { MM_FEEDING_LOCATION model = new MM_FEEDING_LOCATION(); model.ID = Convert.ToInt32(dr["ID"]); model.FeedingLocation = dr["FeedingLocation"].ToString(); model.Note = dr["Note"].ToString(); model.FeedingLocationDesc = dr["FeedingLocationDesc"].ToString(); list.Add(model); } return(list); }
public PM_ALT_ELEMENTBO() { _PM_ALT_ELEMENTDAO = ObjectContainer.BuildUp <IPM_ALT_ELEMENTDAO>(); }
public PM_ALT_SCALEBO() { _PM_ALT_SCALEDAO = ObjectContainer.BuildUp <IPM_ALT_SCALEDAO>(); }
public CV_PM_ALT_CRITERIONBO() { _CV_PM_ALT_CRITERIONDAO = ObjectContainer.BuildUp <ICV_PM_ALT_CRITERIONDAO>(); }
public ALT_BSC_BO() { _ALT_BSC_DAO = ObjectContainer.BuildUp <IALT_BSC_DAO>(); }
public Plat_util_CodeDetailBO() { plat_util_CodeDetailDAO = ObjectContainer.BuildUp <IPlat_util_CodeDetailDAO>(); }
public PM_ALT_EVENT_LOGBO() { _PM_ALT_EVENT_LOGDAO = ObjectContainer.BuildUp <IPM_ALT_EVENT_LOGDAO>(); _CV_PM_ALT_EVENT_TYPEBO = ObjectContainer.BuildUp <ICV_PM_ALT_EVENT_TYPEBO>(); }
public PM_ALT_EVENT_TYPEBO() { _PM_ALT_EVENT_TYPEDAO = ObjectContainer.BuildUp <IPM_ALT_EVENT_TYPEDAO>(); _PM_ALT_EVENT_TYPE_GRPBO = ObjectContainer.BuildUp <IPM_ALT_EVENT_TYPE_GRPBO>(); }
public PM_ALT_NOTIBO() { pM_ALT_NOTIDAO = ObjectContainer.BuildUp <IPM_ALT_NOTIDAO>(); }
public ReturnValue SetWMS() { IAPI_WMS_BO apiwms = ObjectContainer.BuildUp <IAPI_WMS_BO>(); return(apiwms.LineFeedingLoc()); }
// public CV_PM_ALT_EVENT_LOGBO() { _CV_PM_ALT_EVENT_LOGDAO = ObjectContainer.BuildUp <ICV_PM_ALT_EVENT_LOGDAO>(); }
public CV_PM_WECHAT_USERBO() { cV_PM_WECHAT_USERDAO = ObjectContainer.BuildUp <ICV_PM_WECHAT_USERDAO>(); }
public PM_ALT_CONFIG_KEYBO() { pM_ALT_CONFIG_KEYDAO = ObjectContainer.BuildUp <IPM_ALT_CONFIG_KEYDAO>(); }
/// 单条报工 /// </summary> /// <param name="entity"></param> /// <returns></returns> public string GetEXCPtimeByOrderId(string orderid, string excpTimeGuid) //传入的参数是OrderId { string retmes = ""; try { IAPI_SAP_BO sapBO = ObjectContainer.BuildUp <IAPI_SAP_BO>(); ICO_BSC_BO co_BSC_BO = ObjectContainer.BuildUp <ICO_BSC_BO>(); //------------------------------------ string sqlSL = @" SELECT SapOrderID,PersonSdt,Day,StepID FROM CV_POM_ORDERTIME where excpTimeGuid='" + excpTimeGuid + "'"; DataTable datatable = co_BSC_BO.GetDataTableBySql(sqlSL); if (datatable == null || datatable.Rows.Count == 0) { return("未查询到需要报工记录!"); } ModelHandler <Expt> MH = new ModelHandler <Expt>(); List <Expt> listStopOrder = new List <Expt>(); listStopOrder = MH.FillModel(datatable); for (int j = 0; j < listStopOrder.Count; j++) { POMOrder_CompletedByTime li = new POMOrder_CompletedByTime(); POM_ORDER_EXCP_TIME POM_TIME = new POM_ORDER_EXCP_TIME(); IPOM_ORDER_EXCP_TIMEBO POM_TIMEBO = ObjectContainer.BuildUp <IPOM_ORDER_EXCP_TIMEBO>(); string retmessage = ""; //获取当前工单的多个BOPID进行多次报工 // string FrID = @" SELECT BOPID FROM dbo.POM_ORDER_EXT t // LEFT JOIN dbo.PLM_BOP_LINE_STD b on b.OrderID=t.PomOrderID // WHERE SapOrderID='" + listStopOrder[j].SapOrderID + @"' // GROUP BY BOPID "; // DataTable FrIDdt = co_BSC_BO.GetDataTableBySql(FrID); // foreach (DataRow item in FrIDdt.Rows) // { List <POMOrder_CompletedByTime> list = new List <POMOrder_CompletedByTime>(); li.SapOrderID = listStopOrder[j].SapOrderID; li.PK = Guid.NewGuid().ToString(); li.PersonSdt = Convert.ToDecimal(listStopOrder[j].PersonSdt); li.Unit = "s"; li.MachineSdt = 0; li.OtherSdt = 0; li.DepretSdt = 0; li.Day = listStopOrder[j].Day.ToString("yyyy-MM-dd HH:mm:ss");; li.SapStepID = listStopOrder[j].StepID.ToUpper(); list.Add(li); //掉SAP接口 ReturnValue rv = sapBO.OrderCompleteByTime(list[j]); if (rv.Success) { POM_TIME.Status = 1; #region MyRegion //POM_TIME.ExcpTimeGuid = Guid.NewGuid(); //POM_TIME.Day = date; //POM_TIME.SapOrderID = listStopOrder[j].SapOrderID; //POM_TIME.PersonSdt = Convert.ToDecimal(listStopOrder[j].PersonSdt); //POM_TIME.Message = rv.Message; //POM_TIME.CreatedOn = DateTime.Now; //POM_TIME.Status = 1; //POM_TIMEBO.Insert(POM_TIME); ////StopLineBO.UpdateSome(); //for (int i = 0; i < stoplineGuid.Count; i++) //{ // POM_STOPLINE.ExcpStopLineGuid = Guid.NewGuid(); // POM_STOPLINE.ExcpTimeGuid = POM_TIME.ExcpTimeGuid; // POM_STOPLINE.StopLineGuid = stoplineGuid[i].StopLineGuid; // POM_STOPLINEBO.Insert(POM_STOPLINE); // //stopline表的是否报工为true。 // pM_EM_TS_STOPLINE.StopLineGuid = stoplineGuid[i].StopLineGuid; // pM_EM_TS_STOPLINE.IsReleased = true; // StopLineBO.UpdateSome(pM_EM_TS_STOPLINE); //} #endregion } else { retmes += rv.Message; POM_TIME.Status = -1; #region MyRegion //POM_TIME.ExcpTimeGuid = Guid.NewGuid(); //POM_TIME.Day = date; //POM_TIME.SapOrderID = listStopOrder[j].SapOrderID; //POM_TIME.PersonSdt = Convert.ToDecimal(listStopOrder[j].PersonSdt); //POM_TIME.Message = rv.Message; //POM_TIME.CreatedOn = DateTime.Now; //POM_TIME.Status = -1; //POM_TIMEBO.Insert(POM_TIME); //for (int i = 0; i < stoplineGuid.Count; i++) //{ // POM_STOPLINE.ExcpStopLineGuid = Guid.NewGuid(); // POM_STOPLINE.ExcpTimeGuid = POM_TIME.ExcpTimeGuid; // POM_STOPLINE.StopLineGuid = stoplineGuid[i].StopLineGuid; // POM_STOPLINEBO.Insert(POM_STOPLINE); // //stopline表的是否报工为true。 // pM_EM_TS_STOPLINE.StopLineGuid = stoplineGuid[i].StopLineGuid; // pM_EM_TS_STOPLINE.IsReleased = true; // StopLineBO.UpdateSome(pM_EM_TS_STOPLINE); //} #endregion } // } if (retmes == "") { retmes = "true"; } POM_TIME.ExcpTimeGuid = new Guid(excpTimeGuid); POM_TIME.SapOrderID = listStopOrder[j].SapOrderID; POM_TIME.PersonSdt = Convert.ToDecimal(listStopOrder[j].PersonSdt); POM_TIME.Message = retmes; POM_TIMEBO.UpdateSome(POM_TIME); } return(retmes); } catch (Exception ex) { log.Error(ex.Message); return("报工异常:" + ex.Message); } }
public CV_PM_WECHAT_AGENTBO() { cV_PM_WECHAT_AGENTDAO = ObjectContainer.BuildUp <ICV_PM_WECHAT_AGENTDAO>(); }
public PM_ALT_CRITERION_CONDBO() { _PM_ALT_CRITERION_CONDDAO = ObjectContainer.BuildUp <IPM_ALT_CRITERION_CONDDAO>(); }
public CV_PM_WECHAT_NOTIBO() { cV_PM_WECHAT_NOTIDAO = ObjectContainer.BuildUp <ICV_PM_WECHAT_NOTIDAO>(); }
public PM_ALT_NOTI_GROUP_DETAILBO() { _PM_ALT_NOTI_GROUP_DETAILDAO = ObjectContainer.BuildUp <IPM_ALT_NOTI_GROUP_DETAILDAO>(); }