| | |
| | | end-placeholder="ç»ææ¥æ" |
| | | > |
| | | </el-date-picker> |
| | | <el-input v-model="searchParam.ext1" placeholder="车å·" class="search"></el-input> |
| | | <el-button type="success" plain @click="find(1)" >æ¥è¯¢</el-button> |
| | | <el-button type="info" plain @click="reset" >éç½®</el-button> |
| | | </el-row> |
| | |
| | | type="index" |
| | | width="50"> |
| | | </el-table-column> |
| | | <el-table-column label="车å·" prop="ext1" width="80"></el-table-column> |
| | | <el-table-column label="è¿è¡æ¶é´(åé)" prop="deviceRunTime" width="220"></el-table-column> |
| | | <el-table-column label="æ¥è¦æ¶é´(åé)" prop="deviceAlarmTime" width="220"></el-table-column> |
| | | <el-table-column label="çå¾
æ¶é´(åé)" prop="deviceWaitTime" width="220"></el-table-column> |
| | |
| | | // import("@/vendor/Export2Excel") |
| | | this.downloadLoading = true |
| | | import('@/vendor/Export2Excel').then(excel => { |
| | | const tHeader = ['è¿è¡æ¶é´(åé)', 'æ¥è¦æ¶é´(åé)', 'çå¾
æ¶é´(åé)','æ¶é´'] |
| | | const filterVal = ['deviceRunTime', 'deviceAlarmTime', 'deviceWaitTime', 'createTime'] |
| | | const tHeader = ['车å·','è¿è¡æ¶é´(åé)', 'æ¥è¦æ¶é´(åé)', 'çå¾
æ¶é´(åé)','æ¶é´'] |
| | | const filterVal = ['ext1','deviceRunTime', 'deviceAlarmTime', 'deviceWaitTime', 'createTime'] |
| | | const data = this.formatJson(filterVal, this.TakeStocklistAll) |
| | | excel.export_json_to_excel({ |
| | | header: tHeader, |
| | |
| | | reset() { |
| | | this.searchParam.materialName = null |
| | | this.searchParam.materialCode = null |
| | | this.searchParam.SalesOrder = null |
| | | this.searchParam.ext1 = null |
| | | this.selectTypeValue = '' |
| | | this.datatime = '' |
| | | this.initTimeData();//éç½®æ¶é´ |
| | |
| | | /// </summary> |
| | | private void InitializeComponent() |
| | | { |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle9 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle10 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle81 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle82 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle83 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle84 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle85 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle86 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle87 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle88 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle89 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle90 = new System.Windows.Forms.DataGridViewCellStyle(); |
| | | this.tP_TransAsrs = new System.Windows.Forms.TabPage(); |
| | | this.label112 = new System.Windows.Forms.Label(); |
| | | this.label89 = new System.Windows.Forms.Label(); |
| | |
| | | this.label6 = new System.Windows.Forms.Label(); |
| | | this.tabPage_PartTask = new System.Windows.Forms.TabPage(); |
| | | this.btnAllFinish = new System.Windows.Forms.Button(); |
| | | this.btnDelete = new System.Windows.Forms.Button(); |
| | | this.btnFinish = new System.Windows.Forms.Button(); |
| | | this.btnReset = new System.Windows.Forms.Button(); |
| | | this.tbserch = new System.Windows.Forms.TextBox(); |
| | |
| | | this.label31 = new System.Windows.Forms.Label(); |
| | | this.tb_wmsTaskNo2 = new System.Windows.Forms.TextBox(); |
| | | this.button1 = new System.Windows.Forms.Button(); |
| | | this.label39 = new System.Windows.Forms.Label(); |
| | | this.tP_TransAsrs.SuspendLayout(); |
| | | this.panel14.SuspendLayout(); |
| | | this.panel15.SuspendLayout(); |
| | |
| | | // |
| | | // tabPage_PartTask |
| | | // |
| | | this.tabPage_PartTask.Controls.Add(this.label39); |
| | | this.tabPage_PartTask.Controls.Add(this.btnAllFinish); |
| | | this.tabPage_PartTask.Controls.Add(this.btnDelete); |
| | | this.tabPage_PartTask.Controls.Add(this.btnFinish); |
| | | this.tabPage_PartTask.Controls.Add(this.btnReset); |
| | | this.tabPage_PartTask.Controls.Add(this.tbserch); |
| | |
| | | this.tabPage_PartTask.Name = "tabPage_PartTask"; |
| | | this.tabPage_PartTask.Size = new System.Drawing.Size(754, 414); |
| | | this.tabPage_PartTask.TabIndex = 6; |
| | | this.tabPage_PartTask.Text = "å任塿¥ç"; |
| | | this.tabPage_PartTask.Text = "æªç»æåä»»å¡ç»´æ¤"; |
| | | this.tabPage_PartTask.UseVisualStyleBackColor = true; |
| | | // |
| | | // btnAllFinish |
| | | // |
| | | this.btnAllFinish.BackColor = System.Drawing.Color.Tomato; |
| | | this.btnAllFinish.BackColor = System.Drawing.Color.SteelBlue; |
| | | this.btnAllFinish.Location = new System.Drawing.Point(594, 13); |
| | | this.btnAllFinish.Name = "btnAllFinish"; |
| | | this.btnAllFinish.Size = new System.Drawing.Size(123, 23); |
| | | this.btnAllFinish.TabIndex = 4; |
| | | this.btnAllFinish.Text = "æ´ä¸ªä»»å¡å¼ºå¶å®æ"; |
| | | this.btnAllFinish.Text = "[æ´ç»ä»»å¡]强å¶å®æ"; |
| | | this.btnAllFinish.UseVisualStyleBackColor = false; |
| | | this.btnAllFinish.Click += new System.EventHandler(this.btnAllFinish_Click); |
| | | // |
| | | // btnDelete |
| | | // |
| | | this.btnDelete.BackColor = System.Drawing.Color.Silver; |
| | | this.btnDelete.Location = new System.Drawing.Point(274, 11); |
| | | this.btnDelete.Name = "btnDelete"; |
| | | this.btnDelete.Size = new System.Drawing.Size(75, 23); |
| | | this.btnDelete.TabIndex = 3; |
| | | this.btnDelete.Text = "å é¤ä»»å¡"; |
| | | this.btnDelete.UseVisualStyleBackColor = false; |
| | | this.btnDelete.Visible = false; |
| | | this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click); |
| | | // |
| | | // btnFinish |
| | | // |
| | | this.btnFinish.BackColor = System.Drawing.Color.LightSalmon; |
| | | this.btnFinish.Location = new System.Drawing.Point(355, 11); |
| | | this.btnFinish.BackColor = System.Drawing.Color.PaleVioletRed; |
| | | this.btnFinish.Location = new System.Drawing.Point(436, 11); |
| | | this.btnFinish.Name = "btnFinish"; |
| | | this.btnFinish.Size = new System.Drawing.Size(152, 23); |
| | | this.btnFinish.TabIndex = 3; |
| | | this.btnFinish.Text = "强å¶å个设å¤ä»»å¡å®æ"; |
| | | this.btnFinish.Text = "强å¶[å个设å¤]ä»»å¡å®æ"; |
| | | this.btnFinish.UseVisualStyleBackColor = false; |
| | | this.btnFinish.Click += new System.EventHandler(this.btnFinish_Click); |
| | | // |
| | | // btnReset |
| | | // |
| | | this.btnReset.BackColor = System.Drawing.Color.Green; |
| | | this.btnReset.Location = new System.Drawing.Point(513, 12); |
| | | this.btnReset.BackColor = System.Drawing.Color.MediumSlateBlue; |
| | | this.btnReset.Location = new System.Drawing.Point(340, 11); |
| | | this.btnReset.Name = "btnReset"; |
| | | this.btnReset.Size = new System.Drawing.Size(75, 23); |
| | | this.btnReset.TabIndex = 3; |
| | | this.btnReset.Text = "ä»»å¡éå"; |
| | | this.btnReset.Text = "éåä»»å¡"; |
| | | this.btnReset.UseVisualStyleBackColor = false; |
| | | this.btnReset.Click += new System.EventHandler(this.btnReset_Click); |
| | | // |
| | | // tbserch |
| | | // |
| | | this.tbserch.Location = new System.Drawing.Point(89, 13); |
| | | this.tbserch.Location = new System.Drawing.Point(152, 15); |
| | | this.tbserch.Name = "tbserch"; |
| | | this.tbserch.Size = new System.Drawing.Size(164, 21); |
| | | this.tbserch.TabIndex = 2; |
| | |
| | | // Column4 |
| | | // |
| | | this.Column4.DataPropertyName = "createtime"; |
| | | dataGridViewCellStyle1.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.Column4.DefaultCellStyle = dataGridViewCellStyle1; |
| | | dataGridViewCellStyle81.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.Column4.DefaultCellStyle = dataGridViewCellStyle81; |
| | | this.Column4.HeaderText = "å建æ¶é´"; |
| | | this.Column4.Name = "Column4"; |
| | | this.Column4.Width = 130; |
| | |
| | | // Column5 |
| | | // |
| | | this.Column5.DataPropertyName = "updatetime"; |
| | | dataGridViewCellStyle2.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.Column5.DefaultCellStyle = dataGridViewCellStyle2; |
| | | dataGridViewCellStyle82.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.Column5.DefaultCellStyle = dataGridViewCellStyle82; |
| | | this.Column5.HeaderText = "æ´æ°æ¶é´"; |
| | | this.Column5.Name = "Column5"; |
| | | this.Column5.Width = 130; |
| | |
| | | // Column2 |
| | | // |
| | | this.Column2.DataPropertyName = "issueTime"; |
| | | dataGridViewCellStyle3.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.Column2.DefaultCellStyle = dataGridViewCellStyle3; |
| | | dataGridViewCellStyle83.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.Column2.DefaultCellStyle = dataGridViewCellStyle83; |
| | | this.Column2.HeaderText = "ä¸åæ¶é´"; |
| | | this.Column2.Name = "Column2"; |
| | | this.Column2.Width = 130; |
| | |
| | | // Column3 |
| | | // |
| | | this.Column3.DataPropertyName = "finishTime"; |
| | | dataGridViewCellStyle4.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.Column3.DefaultCellStyle = dataGridViewCellStyle4; |
| | | dataGridViewCellStyle84.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.Column3.DefaultCellStyle = dataGridViewCellStyle84; |
| | | this.Column3.HeaderText = "宿æ¶é´"; |
| | | this.Column3.Name = "Column3"; |
| | | this.Column3.Width = 130; |
| | |
| | | // dataGridViewTextBoxColumn18 |
| | | // |
| | | this.dataGridViewTextBoxColumn18.DataPropertyName = "createtime"; |
| | | dataGridViewCellStyle5.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.dataGridViewTextBoxColumn18.DefaultCellStyle = dataGridViewCellStyle5; |
| | | dataGridViewCellStyle85.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.dataGridViewTextBoxColumn18.DefaultCellStyle = dataGridViewCellStyle85; |
| | | this.dataGridViewTextBoxColumn18.HeaderText = "å建æ¶é´"; |
| | | this.dataGridViewTextBoxColumn18.Name = "dataGridViewTextBoxColumn18"; |
| | | this.dataGridViewTextBoxColumn18.Width = 130; |
| | |
| | | // Column6 |
| | | // |
| | | this.Column6.DataPropertyName = "updatetime"; |
| | | dataGridViewCellStyle6.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.Column6.DefaultCellStyle = dataGridViewCellStyle6; |
| | | dataGridViewCellStyle86.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.Column6.DefaultCellStyle = dataGridViewCellStyle86; |
| | | this.Column6.HeaderText = "æ´æ°æ¶é´"; |
| | | this.Column6.Name = "Column6"; |
| | | this.Column6.Width = 130; |
| | |
| | | // dataGridViewTextBoxColumn19 |
| | | // |
| | | this.dataGridViewTextBoxColumn19.DataPropertyName = "issueTime"; |
| | | dataGridViewCellStyle7.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.dataGridViewTextBoxColumn19.DefaultCellStyle = dataGridViewCellStyle7; |
| | | dataGridViewCellStyle87.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.dataGridViewTextBoxColumn19.DefaultCellStyle = dataGridViewCellStyle87; |
| | | this.dataGridViewTextBoxColumn19.HeaderText = "ä¸åæ¶é´"; |
| | | this.dataGridViewTextBoxColumn19.Name = "dataGridViewTextBoxColumn19"; |
| | | this.dataGridViewTextBoxColumn19.Width = 130; |
| | |
| | | // dataGridViewTextBoxColumn20 |
| | | // |
| | | this.dataGridViewTextBoxColumn20.DataPropertyName = "finishTime"; |
| | | dataGridViewCellStyle8.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.dataGridViewTextBoxColumn20.DefaultCellStyle = dataGridViewCellStyle8; |
| | | dataGridViewCellStyle88.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.dataGridViewTextBoxColumn20.DefaultCellStyle = dataGridViewCellStyle88; |
| | | this.dataGridViewTextBoxColumn20.HeaderText = "宿æ¶é´"; |
| | | this.dataGridViewTextBoxColumn20.Name = "dataGridViewTextBoxColumn20"; |
| | | this.dataGridViewTextBoxColumn20.Width = 130; |
| | |
| | | // dataGridViewTextBoxColumn39 |
| | | // |
| | | this.dataGridViewTextBoxColumn39.DataPropertyName = "sendtime"; |
| | | dataGridViewCellStyle9.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.dataGridViewTextBoxColumn39.DefaultCellStyle = dataGridViewCellStyle9; |
| | | dataGridViewCellStyle89.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.dataGridViewTextBoxColumn39.DefaultCellStyle = dataGridViewCellStyle89; |
| | | this.dataGridViewTextBoxColumn39.HeaderText = "ä¸åæ¶é´"; |
| | | this.dataGridViewTextBoxColumn39.Name = "dataGridViewTextBoxColumn39"; |
| | | this.dataGridViewTextBoxColumn39.Width = 130; |
| | |
| | | // dataGridViewTextBoxColumn40 |
| | | // |
| | | this.dataGridViewTextBoxColumn40.DataPropertyName = "finishTime"; |
| | | dataGridViewCellStyle10.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.dataGridViewTextBoxColumn40.DefaultCellStyle = dataGridViewCellStyle10; |
| | | dataGridViewCellStyle90.Format = "yyyy-MM-dd HH:mm:ss"; |
| | | this.dataGridViewTextBoxColumn40.DefaultCellStyle = dataGridViewCellStyle90; |
| | | this.dataGridViewTextBoxColumn40.HeaderText = "宿æ¶é´"; |
| | | this.dataGridViewTextBoxColumn40.Name = "dataGridViewTextBoxColumn40"; |
| | | this.dataGridViewTextBoxColumn40.Width = 130; |
| | |
| | | this.button1.Text = "æ¥æ¾"; |
| | | this.button1.UseVisualStyleBackColor = true; |
| | | this.button1.Click += new System.EventHandler(this.button1_Click); |
| | | // |
| | | // label39 |
| | | // |
| | | this.label39.AutoSize = true; |
| | | this.label39.Location = new System.Drawing.Point(94, 19); |
| | | this.label39.Name = "label39"; |
| | | this.label39.Size = new System.Drawing.Size(53, 12); |
| | | this.label39.TabIndex = 5; |
| | | this.label39.Text = "(ä»»å¡å·)"; |
| | | // |
| | | // WCSFrom |
| | | // |
| | |
| | | private System.Windows.Forms.TextBox tbserch; |
| | | private System.Windows.Forms.Button btnFind; |
| | | private System.Windows.Forms.DataGridView dgvPartTask; |
| | | private System.Windows.Forms.Button btnDelete; |
| | | private System.Windows.Forms.Button btnFinish; |
| | | private System.Windows.Forms.Button btnReset; |
| | | private System.Windows.Forms.Label labRGV2Heaert; |
| | |
| | | private System.Windows.Forms.DataGridViewTextBoxColumn Column6; |
| | | private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn19; |
| | | private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn20; |
| | | private System.Windows.Forms.Label label39; |
| | | |
| | | } |
| | | } |
| | |
| | | <metadata name="Column1.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="id.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="Column4.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="Column5.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="Column2.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="Column3.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="filereason.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="maintaskid.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="taskno.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="taskcode.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="containername.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="sourceplace.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="toplace.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="eqname.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="ishandledText.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="isreleasedText.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="isfinished.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="iscurrentText.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="nexthandel.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="heighttype.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="containertype.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="Column1.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn1.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | |
| | | <metadata name="dataGridViewTextBoxColumn20.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn1.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn2.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn3.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn4.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn5.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn6.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn7.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn8.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn9.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn10.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn11.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn12.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn13.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn14.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn15.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn16.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn17.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn18.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="Column6.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn19.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn20.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn21.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn23.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn24.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn25.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn34.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn26.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn27.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn28.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn33.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn32.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn35.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn36.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn37.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn39.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn40.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | | <metadata name="dataGridViewTextBoxColumn21.UserAddedColumn" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>True</value> |
| | | </metadata> |
| | |
| | | |
| | | |
| | | |
| | | -- YrtWMS_Siemens2.dbo.deviceGeneralInfoForDetail definition |
| | | |
| | | -- Drop table |
| | | |
| | | -- DROP TABLE YrtWMS_Siemens2.deviceGeneralInfoForDetail; |
| | | |
| | | CREATE TABLE YrtWMS_Siemens2.dbo.deviceGeneralInfoForDetail ( |
| | | id int IDENTITY(1,1) NOT NULL, |
| | | taskEnterCount int NULL, |
| | | taskOutCount int NULL, |
| | | stockProportion int NULL, |
| | | outDate int NULL, |
| | | deviceRunTime decimal(18,0) NULL, |
| | | deviceWaitTime decimal(18,0) NULL, |
| | | deviceAlarmTime decimal(18,0) NULL, |
| | | createTime datetime NULL, |
| | | ext1 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, |
| | | ext2 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, |
| | | ext3 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, |
| | | ext4 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, |
| | | CONSTRAINT PK_deviceGeneralInfoForDetail PRIMARY KEY (id) |
| | | ); |
| | | |
| | | |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using logtxtWrite; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Diagnostics; |
| | | using System.Linq; |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | using wcftest.orm; |
| | | |
| | | namespace wcftest.BussinessExtension |
| | | { |
| | | public class DeviceGeneralInfoHelper |
| | | { |
| | | |
| | | /// <summary> |
| | | /// å¤ç |
| | | /// </summary> |
| | | /// <param name="srmNo"></param> |
| | | /// <param name="enterTaskCount"></param> |
| | | /// <param name="outTaskCount"></param> |
| | | /// <param name="stockUsingCount"></param> |
| | | /// <param name="outTimeStockCount"></param> |
| | | /// <param name="mod"></param> |
| | | /// <param name="lastHour"></param> |
| | | /// <param name="todayTime"></param> |
| | | /// <param name="deviceSwForDetail"></param> |
| | | /// <param name="deviceRunTime"></param> |
| | | /// <param name="deviceAlarmTime"></param> |
| | | /// <param name="deviceWaitTime"></param> |
| | | public static void HandlerDeviceGeneralInfoForDetail( |
| | | int srmNo, |
| | | List<Task_Queue> enterTaskCount, |
| | | List<Task_Queue> outTaskCount, |
| | | List<Base_Position> stockUsingCount, |
| | | List<Base_ProductPosition> outTimeStockCount, |
| | | dbModel mod, int lastHour, DateTime todayTime, |
| | | Stopwatch deviceSwForDetail, |
| | | TimeSpan deviceRunTime, |
| | | TimeSpan deviceAlarmTime, |
| | | TimeSpan deviceWaitTime |
| | | ) |
| | | { |
| | | try |
| | | { |
| | | //éæ°ç»ç»æ°æ® |
| | | enterTaskCount = enterTaskCount.Where(x => x.DoCount == srmNo).ToList(); |
| | | outTaskCount = outTaskCount.Where(x => x.DoCount == srmNo).ToList(); |
| | | |
| | | |
| | | //æ¯éä¸å°æ¶ä¿å䏿¬¡è®¾å¤ç¶ææ¶é´ |
| | | var str_srmNo = srmNo.ToString(); |
| | | deviceGeneralInfoForDetail todayDeviceInfo = null; |
| | | todayDeviceInfo = mod.deviceGeneralInfoForDetail.FirstOrDefault(x => x.createTime > todayTime && x.ext1 == str_srmNo); |
| | | if (todayDeviceInfo == null) |
| | | { |
| | | todayDeviceInfo = new deviceGeneralInfoForDetail(); |
| | | todayDeviceInfo.ext1 = str_srmNo;//èµå¼ æºå· |
| | | todayDeviceInfo.ext2 = GetCurrentPeriod(); |
| | | todayDeviceInfo.createTime = DateTime.Now; |
| | | mod.deviceGeneralInfoForDetail.Add(todayDeviceInfo); |
| | | //计æ¶å¤ä½ |
| | | deviceSwForDetail.Reset(); |
| | | deviceAlarmTime = deviceSwForDetail.Elapsed; |
| | | deviceRunTime = deviceSwForDetail.Elapsed; |
| | | deviceWaitTime = deviceSwForDetail.Elapsed; |
| | | |
| | | } |
| | | else |
| | | { |
| | | |
| | | todayDeviceInfo.deviceRunTime = deviceRunTime.TotalMinutes > 0 ? Convert.ToDecimal(deviceRunTime.TotalMinutes) : 0M; |
| | | todayDeviceInfo.deviceAlarmTime = deviceAlarmTime.TotalMinutes > 0 ? Convert.ToDecimal(deviceAlarmTime.TotalMinutes) : 0M; |
| | | //éæ°è®¡ç®è®¾å¤çå¾
æ¶é´ ãEditby shaocx,2024-12-30ã |
| | | CommonCalcWaitTime(ref todayDeviceInfo); |
| | | |
| | | todayDeviceInfo.taskEnterCount = enterTaskCount.Count;//å
¥åºä»»å¡æ° |
| | | todayDeviceInfo.taskOutCount = outTaskCount.Count;//åºåºä»»å¡æ° |
| | | //æ´æ¹æ°é ãEditby shaocx,2024-11-22ã |
| | | decimal cout = stockUsingCount.Count / 1152M * 100; |
| | | todayDeviceInfo.stockProportion = Convert.ToInt32(cout);//已使ç¨çåºä½ |
| | | todayDeviceInfo.outDate = outTimeStockCount.Count;//è¿ææ¶é´å°äºä¸ä¸ªæçåºåæ°æ® |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | |
| | | } |
| | | } |
| | | |
| | | public static void deviceInfoInitForDetails(int srmNo, DateTime todayTime, int lastHour, TimeSpan deviceAlarmTime, TimeSpan deviceRunTime, TimeSpan deviceWaitTime) |
| | | { |
| | | var str_srmNo = srmNo.ToString(); |
| | | using (dbModel mod = new dbModel()) |
| | | { |
| | | deviceGeneralInfoForDetail todayDeviceInfo = mod.deviceGeneralInfoForDetail.FirstOrDefault(x => x.createTime > todayTime && x.ext1 == str_srmNo); |
| | | if (todayDeviceInfo != null) |
| | | { |
| | | TimeSpan alarmTime = new TimeSpan(Convert.ToInt32(Math.Floor((decimal)todayDeviceInfo.deviceAlarmTime / 60M)), Convert.ToInt32((decimal)todayDeviceInfo.deviceAlarmTime % 60), 0); |
| | | deviceAlarmTime = alarmTime; |
| | | TimeSpan runTime = new TimeSpan(Convert.ToInt32(Math.Floor((decimal)todayDeviceInfo.deviceRunTime / 60M)), Convert.ToInt32((decimal)todayDeviceInfo.deviceRunTime % 60), 0); |
| | | deviceRunTime = runTime; |
| | | TimeSpan waitTime = new TimeSpan(Convert.ToInt32(Math.Floor((decimal)todayDeviceInfo.deviceWaitTime / 60M)), Convert.ToInt32((decimal)todayDeviceInfo.deviceWaitTime % 60), 0); |
| | | deviceWaitTime = waitTime; |
| | | |
| | | } |
| | | else |
| | | { |
| | | deviceGeneralInfoForDetail creatTodayDeviceInfo = new deviceGeneralInfoForDetail(); |
| | | creatTodayDeviceInfo.ext1 = str_srmNo;//æºå·èµå¼ |
| | | creatTodayDeviceInfo.ext2 = GetCurrentPeriod(); |
| | | //è®¾å¤æ¥è¦æ¶é´ |
| | | creatTodayDeviceInfo.deviceAlarmTime = Convert.ToDecimal(deviceAlarmTime.Hours * 60M) + deviceAlarmTime.Minutes;//åä½åé |
| | | //设å¤è¿è¡æ¶é´ |
| | | creatTodayDeviceInfo.deviceRunTime = Convert.ToDecimal(deviceRunTime.Hours * 60M) + deviceRunTime.Minutes;//åä½åé |
| | | //设å¤çå¾
æ¶é´ |
| | | //creatTodayDeviceInfo.deviceWaitTime = Convert.ToDecimal(deviceWaitTime.Hours * 60M) + deviceWaitTime.Minutes;//åä½åé |
| | | //éæ°è®¡ç®è®¾å¤çå¾
æ¶é´ ãEditby shaocx,2024-12-30ã |
| | | DeviceGeneralInfoHelper.CommonCalcWaitTime(ref creatTodayDeviceInfo); |
| | | |
| | | creatTodayDeviceInfo.createTime = DateTime.Now; |
| | | mod.deviceGeneralInfoForDetail.Add(creatTodayDeviceInfo); |
| | | mod.SaveChanges(); |
| | | //计æ¶å¤ä½ |
| | | |
| | | } |
| | | |
| | | } |
| | | } |
| | | |
| | | |
| | | public static void CommonCalcWaitTime(ref deviceGeneralInfo todayDeviceInfo) |
| | | { |
| | | //éæ°è®¡ç®è®¾å¤çå¾
æ¶é´ ãEditby shaocx,2024-12-30ã |
| | | todayDeviceInfo.deviceWaitTime = 1440 - (todayDeviceInfo.deviceRunTime + todayDeviceInfo.deviceAlarmTime); |
| | | } |
| | | public static void CommonCalcWaitTime(ref deviceGeneralInfoForDetail todayDeviceInfo) |
| | | { |
| | | //éæ°è®¡ç®è®¾å¤çå¾
æ¶é´ ãEditby shaocx,2024-12-30ã |
| | | todayDeviceInfo.deviceWaitTime = 1440 - (todayDeviceInfo.deviceRunTime + todayDeviceInfo.deviceAlarmTime); |
| | | } |
| | | |
| | | |
| | | |
| | | public static string GetCurrentPeriod() |
| | | { |
| | | DateTime today = DateTime.Today; |
| | | DateTime startDate = new DateTime(today.Year, today.Month, today.Day, 0, 0, 0); |
| | | DateTime endDate = new DateTime(today.Year, today.Month, today.Day, 23, 59, 59); |
| | | |
| | | return string.Format("{0:yyyy-MM-dd HH:mm:ss} è³ {1:yyyy-MM-dd HH:mm:ss}", |
| | | startDate, endDate); |
| | | } |
| | | } |
| | | } |
| | |
| | | /// 设å¤è¿è¡æ¶é´ |
| | | /// </summary> |
| | | public static TimeSpan deviceRunTime; |
| | | public static TimeSpan deviceRunTime_Srm1; |
| | | public static TimeSpan deviceRunTime_Srm2; |
| | | /// <summary>设å¤çå¾
æ¶é´ |
| | | /// 设å¤çå¾
æ¶é´ |
| | | /// </summary> |
| | | public static TimeSpan deviceWaitTime; |
| | | public static TimeSpan deviceWaitTime_Srm1; |
| | | public static TimeSpan deviceWaitTime_Srm2; |
| | | /// <summary>è®¾å¤æ¥è¦æ¶é´ |
| | | /// è®¾å¤æ¥è¦æ¶é´ |
| | | /// </summary> |
| | | public static TimeSpan deviceAlarmTime; |
| | | public static TimeSpan deviceAlarmTime_Srm1; |
| | | public static TimeSpan deviceAlarmTime_Srm2; |
| | | /// <summary>设å¤ä½¿ç¨ç |
| | | /// 设å¤ä½¿ç¨ç |
| | | /// </summary> |
| | |
| | | /// 设å¤è¿è¡è®¡æ¶å¨ |
| | | /// </summary> |
| | | Stopwatch deviceSw = new Stopwatch(); |
| | | Stopwatch deviceSw_Srm1 = new Stopwatch(); |
| | | Stopwatch deviceSw_Srm2 = new Stopwatch(); |
| | | /// <summary>ä¸ä¸æ¬¡è®¾å¤è¿è¡ç¶æ |
| | | /// ä¸ä¸æ¬¡è®¾å¤è¿è¡ç¶æ |
| | | /// </summary> |
| | | public string lastStatus = "çå¾
"; |
| | | public string lastStatus_Srm1 = "çå¾
"; |
| | | public string lastStatus_Srm2 = "çå¾
"; |
| | | /// <summary>ä¸ä¸æ¬¡å°æ¶æ°--æ¯éä¸å°æ¶ä¿å䏿¬¡è®¾å¤ç¶ææ¶é´ |
| | | /// ä¸ä¸æ¬¡å°æ¶æ°--æ¯éä¸å°æ¶ä¿å䏿¬¡è®¾å¤ç¶ææ¶é´ |
| | | /// </summary> |
| | |
| | | |
| | | string[] containers = new string[19]; |
| | | deviceSw.Start();// 设å¤è¿è¡è®¡ç®å¨å¼å§è®°æ¶ |
| | | deviceSw_Srm1.Start();// 设å¤è¿è¡è®¡ç®å¨å¼å§è®°æ¶ |
| | | deviceSw_Srm2.Start();// 设å¤è¿è¡è®¡ç®å¨å¼å§è®°æ¶ |
| | | #region è·å设å¤ä¿¡æ¯ |
| | | |
| | | if (allowGetDeviceInfo == true) |
| | |
| | | totalInfo.list11[1] = outTaskCount.Count; |
| | | } |
| | | |
| | | |
| | | |
| | | totalInfo.list11[2] = 1152; |
| | | totalInfo.list11[3] = 1152 - stockUsingCount.Count(); |
| | | |
| | |
| | | } |
| | | else |
| | | { |
| | | |
| | | |
| | | todayDeviceInfo.deviceRunTime = deviceRunTime.TotalMinutes > 0 ? Convert.ToDecimal(deviceRunTime.TotalMinutes) : 0M; |
| | | todayDeviceInfo.deviceAlarmTime = deviceAlarmTime.TotalMinutes > 0 ? Convert.ToDecimal(deviceAlarmTime.TotalMinutes) : 0M; |
| | | //éæ°è®¡ç®è®¾å¤çå¾
æ¶é´ ãEditby shaocx,2024-12-30ã |
| | | CommonCalcWaitTime(ref todayDeviceInfo); |
| | | DeviceGeneralInfoHelper.CommonCalcWaitTime(ref todayDeviceInfo); |
| | | |
| | | todayDeviceInfo.taskEnterCount = enterTaskCount.Count;//å
¥åºä»»å¡æ° |
| | | todayDeviceInfo.taskOutCount = outTaskCount.Count;//åºåºä»»å¡æ° |
| | |
| | | todayDeviceInfo.stockProportion = Convert.ToInt32(cout);//已使ç¨çåºä½ |
| | | todayDeviceInfo.outDate = outTimeStockCount.Count;//è¿ææ¶é´å°äºä¸ä¸ªæçåºåæ°æ® |
| | | } |
| | | |
| | | DeviceGeneralInfoHelper.HandlerDeviceGeneralInfoForDetail(1, enterTaskCount, outTaskCount, stockUsingCount, outTimeStockCount, |
| | | mod, lastHour, todayTime, |
| | | deviceSw_Srm1, deviceRunTime_Srm1, deviceAlarmTime_Srm1, deviceWaitTime_Srm1 |
| | | ); |
| | | DeviceGeneralInfoHelper.HandlerDeviceGeneralInfoForDetail(2, enterTaskCount, outTaskCount, stockUsingCount, outTimeStockCount, |
| | | mod, lastHour, todayTime, |
| | | deviceSw_Srm2, deviceRunTime_Srm2, deviceAlarmTime_Srm2, deviceWaitTime_Srm2 |
| | | ); |
| | | |
| | | int chang = mod.SaveChanges(); |
| | | } |
| | |
| | | if (lastStatus != "è¿è¡") |
| | | { |
| | | setDeviceStatusTime(lastStatus, "è¿è¡"); |
| | | } |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region ç»è®¡è®¾å¤è¿è¡æçï¼è¯¦ç»ï¼ ãEditby shaocx,2025-09-19ã |
| | | //1å·å åæº |
| | | if (deviceListInfo.srm1.isAlarm == true) |
| | | { |
| | | if (lastStatus_Srm1 != "æ¥è¦") |
| | | { |
| | | setDeviceStatusTimeForDetail(1, lastStatus_Srm1, "æ¥è¦"); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | if (deviceListInfo.srm1.status == "空é²") |
| | | { |
| | | if (lastStatus_Srm1 != "çå¾
") |
| | | { |
| | | setDeviceStatusTimeForDetail(1, lastStatus_Srm1, "çå¾
"); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | if (lastStatus_Srm1 != "è¿è¡") |
| | | { |
| | | setDeviceStatusTimeForDetail(1, lastStatus_Srm1, "è¿è¡"); |
| | | } |
| | | } |
| | | } |
| | | //2å·å åæº |
| | | if (deviceListInfo.srm2.isAlarm == true) |
| | | { |
| | | if (lastStatus_Srm2 != "æ¥è¦") |
| | | { |
| | | setDeviceStatusTimeForDetail(2, lastStatus_Srm2, "æ¥è¦"); |
| | | } |
| | | |
| | | } |
| | | else |
| | | { |
| | | if (deviceListInfo.srm2.status == "空é²") |
| | | { |
| | | if (lastStatus_Srm2 != "çå¾
") |
| | | { |
| | | setDeviceStatusTimeForDetail(2, lastStatus_Srm2, "çå¾
"); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | if (lastStatus_Srm2 != "è¿è¡") |
| | | { |
| | | setDeviceStatusTimeForDetail(2, lastStatus_Srm2, "è¿è¡"); |
| | | } |
| | | } |
| | | } |
| | |
| | | { |
| | | |
| | | } |
| | | } |
| | | /// <summary>设å¤ç¶æååçæ¶å ä¿åç¶ææ¶é´ï¼æç»ï¼ |
| | | /// 设å¤ç¶æååçæ¶å ä¿åç¶ææ¶é´ |
| | | /// </summary> |
| | | /// <param name="status"></param> |
| | | private void setDeviceStatusTimeForDetail(int srmNo, string lastStatuss, string nowStatus) |
| | | { |
| | | try |
| | | { |
| | | switch (lastStatuss) |
| | | { |
| | | case "çå¾
": |
| | | if (srmNo == 1) |
| | | { |
| | | deviceWaitTime_Srm1 += deviceSw_Srm1.Elapsed; |
| | | } |
| | | else |
| | | { |
| | | deviceWaitTime_Srm2 += deviceSw_Srm2.Elapsed; |
| | | } |
| | | break; |
| | | case "è¿è¡": |
| | | if (srmNo == 1) |
| | | { |
| | | deviceRunTime_Srm1 += deviceSw_Srm1.Elapsed; |
| | | } |
| | | else |
| | | { |
| | | deviceRunTime_Srm2 += deviceSw_Srm2.Elapsed; |
| | | } |
| | | break; |
| | | case "æ¥è¦": |
| | | if (srmNo == 1) |
| | | { |
| | | deviceAlarmTime_Srm1 += deviceSw_Srm1.Elapsed; |
| | | } |
| | | else |
| | | { |
| | | deviceAlarmTime_Srm2 += deviceSw_Srm2.Elapsed; |
| | | } |
| | | break; |
| | | } |
| | | |
| | | if (srmNo == 1) |
| | | { |
| | | deviceSw_Srm1.Restart(); |
| | | |
| | | lastStatus_Srm1 = nowStatus; |
| | | } |
| | | else |
| | | { |
| | | deviceSw_Srm2.Restart(); |
| | | |
| | | lastStatus_Srm2 = nowStatus; |
| | | } |
| | | } |
| | | catch (Exception) |
| | | { |
| | | |
| | | } |
| | | } |
| | | /// <summary>大å±ä¿¡æ¯åå§å |
| | | /// 大å±ä¿¡æ¯åå§å |
| | |
| | | //设å¤çå¾
æ¶é´ |
| | | //creatTodayDeviceInfo.deviceWaitTime = Convert.ToDecimal(deviceWaitTime.Hours * 60M) + deviceWaitTime.Minutes;//åä½åé |
| | | //éæ°è®¡ç®è®¾å¤çå¾
æ¶é´ ãEditby shaocx,2024-12-30ã |
| | | CommonCalcWaitTime(ref todayDeviceInfo); |
| | | DeviceGeneralInfoHelper.CommonCalcWaitTime(ref creatTodayDeviceInfo); |
| | | |
| | | creatTodayDeviceInfo.createTime = DateTime.Now; |
| | | mod.deviceGeneralInfo.Add(creatTodayDeviceInfo); |
| | |
| | | } |
| | | |
| | | } |
| | | |
| | | DeviceGeneralInfoHelper.deviceInfoInitForDetails(1, todayTime, lastHour, deviceAlarmTime_Srm1, deviceRunTime_Srm1, deviceWaitTime_Srm1); |
| | | DeviceGeneralInfoHelper.deviceInfoInitForDetails(2, todayTime, lastHour, deviceAlarmTime_Srm2, deviceRunTime_Srm2, deviceWaitTime_Srm2); |
| | | |
| | | deviceInfos = new Thread(deviceInfo); |
| | | deviceInfos.Start(); |
| | | } |
| | |
| | | return resultDate; |
| | | } |
| | | |
| | | private void CommonCalcWaitTime(ref deviceGeneralInfo todayDeviceInfo) |
| | | { |
| | | //éæ°è®¡ç®è®¾å¤çå¾
æ¶é´ ãEditby shaocx,2024-12-30ã |
| | | todayDeviceInfo.deviceWaitTime = 1440 - (todayDeviceInfo.deviceRunTime + todayDeviceInfo.deviceAlarmTime); |
| | | } |
| | | private void CommonCalcWaitTime(ref deviceGeneralInfoForDetail todayDeviceInfo) |
| | | { |
| | | //éæ°è®¡ç®è®¾å¤çå¾
æ¶é´ ãEditby shaocx,2024-12-30ã |
| | | todayDeviceInfo.deviceWaitTime = 1440 - (todayDeviceInfo.deviceRunTime + todayDeviceInfo.deviceAlarmTime); |
| | | } |
| | | |
| | | |
| | | #endregion |
| | | |
| | |
| | | /// </summary> |
| | | public DateTime[] datatime { get; set; } |
| | | |
| | | |
| | | |
| | | /// <summary>æç´¢åæ° |
| | | /// |
| | | /// </summary> |
| | | public searchparamForDeviceGeneralInfoInput search { get; set; } |
| | | |
| | | } |
| | | |
| | | public class searchparamForDeviceGeneralInfoInput |
| | | { |
| | | |
| | | /// <summary> |
| | | /// è½¦å· |
| | | /// </summary> |
| | | public string ext1 { get; set; } |
| | | } |
| | | } |
| | |
| | | [StringLength(50)] |
| | | public string ext1 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¶é´èå´å符串 |
| | | /// </summary> |
| | | [StringLength(50)] |
| | | public string ext2 { get; set; } |
| | | |
| | |
| | | //éæ°è®¡ç®çå¾
æ¶é´ |
| | | item.deviceWaitTime = 1440 - ((item.deviceRunTime ?? 0M) + (item.deviceAlarmTime ?? 0M)); |
| | | } |
| | | if (!string.IsNullOrEmpty(page.search.ext1)) |
| | | { |
| | | fiveDayDeviceInfo = fiveDayDeviceInfo.Where(x => x.ext1 == page.search.ext1).ToList(); |
| | | } |
| | | } |
| | | |
| | | List<deviceGeneralInfoForDetail> fenyeRerult = new List<deviceGeneralInfoForDetail>(); |
| | |
| | | <Compile Include="BussinessExtension\SAP\SAPHelper.cs" /> |
| | | <Compile Include="BussinessExtension\SystemHelper.cs" /> |
| | | <Compile Include="BussinessExtension\VirtualModeHelper.cs" /> |
| | | <Compile Include="BussinessExtension\DeviceGeneralInfoHelper.cs" /> |
| | | <Compile Include="BussinessExtension\WcsWcfApiHelper.cs" /> |
| | | <Compile Include="deviceorm\ChaiDieTransport.cs" /> |
| | | <Compile Include="deviceorm\DevAlert.cs" /> |