| | |
| | | this.toolStripSeparator9 = new System.Windows.Forms.ToolStripSeparator(); |
| | | this.bclk = new System.Windows.Forms.ToolStripButton(); |
| | | this.toolStripSeparator7 = new System.Windows.Forms.ToolStripSeparator(); |
| | | this.grdMain1 = new System.Windows.Forms.DataGridView(); |
| | | this.P1.SuspendLayout(); |
| | | this.gbUp.SuspendLayout(); |
| | | this.panel2.SuspendLayout(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit(); |
| | | this.Tool.SuspendLayout(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdMain1)).BeginInit(); |
| | | this.SuspendLayout(); |
| | | // |
| | | // P1 |
| | |
| | | // timer1 |
| | | // |
| | | this.timer1.Enabled = true; |
| | | this.timer1.Tick += new System.EventHandler(this.timer1_Tick); |
| | | // |
| | | // panel2 |
| | | // |
| | |
| | | this.toolStripSeparator7.Name = "toolStripSeparator7"; |
| | | this.toolStripSeparator7.Size = new System.Drawing.Size(6, 62); |
| | | // |
| | | // grdMain1 |
| | | // |
| | | this.grdMain1.AllowUserToAddRows = false; |
| | | this.grdMain1.AllowUserToDeleteRows = false; |
| | | this.grdMain1.BackgroundColor = System.Drawing.Color.WhiteSmoke; |
| | | this.grdMain1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; |
| | | this.grdMain1.ClipboardCopyMode = System.Windows.Forms.DataGridViewClipboardCopyMode.Disable; |
| | | this.grdMain1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; |
| | | this.grdMain1.Dock = System.Windows.Forms.DockStyle.Fill; |
| | | this.grdMain1.ImeMode = System.Windows.Forms.ImeMode.NoControl; |
| | | this.grdMain1.Location = new System.Drawing.Point(52, 291); |
| | | this.grdMain1.Margin = new System.Windows.Forms.Padding(4); |
| | | this.grdMain1.Name = "grdMain1"; |
| | | this.grdMain1.ReadOnly = true; |
| | | this.grdMain1.RowHeadersWidth = 30; |
| | | this.grdMain1.RowTemplate.Height = 23; |
| | | this.grdMain1.Size = new System.Drawing.Size(1109, 497); |
| | | this.grdMain1.TabIndex = 59; |
| | | this.grdMain1.RowHeadersWidthChanged += new System.EventHandler(this.grdMain_RowHeadersWidthChanged); |
| | | this.grdMain1.CellEndEdit += new System.Windows.Forms.DataGridViewCellEventHandler(this.grdMain_CellEndEdit); |
| | | this.grdMain1.CellLeave += new System.Windows.Forms.DataGridViewCellEventHandler(this.grdMain_CellLeave); |
| | | this.grdMain1.EditingControlShowing += new System.Windows.Forms.DataGridViewEditingControlShowingEventHandler(this.grdMain_EditingControlShowing); |
| | | this.grdMain1.Scroll += new System.Windows.Forms.ScrollEventHandler(this.grdMain_Scroll); |
| | | // |
| | | // Gy_StdWorkTimes |
| | | // |
| | | this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F); |
| | | this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; |
| | | this.ClientSize = new System.Drawing.Size(1216, 928); |
| | | this.Controls.Add(this.grdMain1); |
| | | this.Controls.Add(this.P1); |
| | | this.Controls.Add(this.panel3); |
| | | this.Controls.Add(this.panel2); |
| | |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdSum)).EndInit(); |
| | | this.Tool.ResumeLayout(false); |
| | | this.Tool.PerformLayout(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdMain1)).EndInit(); |
| | | this.ResumeLayout(false); |
| | | |
| | | } |
| | |
| | | private System.Windows.Forms.Label label12; |
| | | private System.Windows.Forms.Label label10; |
| | | private System.Windows.Forms.Label label9; |
| | | private System.Windows.Forms.DataGridView grdMain1; |
| | | } |
| | | } |
| | |
| | | private void bclk_Click(object sender, EventArgs e) |
| | | { |
| | | //ä¿åå宽 |
| | | DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name); |
| | | DBUtility.Xt_BaseBillFun.SaveGrid(grdMain1, this.Name); |
| | | } |
| | | |
| | | private void mrlk_Click(object sender, EventArgs e) |
| | | { |
| | | DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name); |
| | | DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain1, this.Name); |
| | | } |
| | | |
| | | //æ¸
空çé¢ |
| | |
| | | { |
| | | //æå°åå§å |
| | | oSumGrid.NoCol = HSnoCol; |
| | | oSumGrid.ogrdMain = grdMain; |
| | | oSumGrid.ogrdMain = grdMain1; |
| | | oSumGrid.oGridsum = grdSum; |
| | | lblCaption.Text = ModName; |
| | | this.Text = ModName; |
| | |
| | | foreach (Model.ClsGy_StdWorkTimes_Model oSub in BillNew.DetailColl) |
| | | { |
| | | // |
| | | if (i >= grdMain.RowCount - 1) |
| | | grdMain.Rows.Add(); |
| | | grdMain.Rows[i].Cells[HTagCol].Value = "*"; |
| | | grdMain.Rows[i].Cells[HMaterIDCol].Value = oSub.HMaterID.ToString(); |
| | | if (i >= grdMain1.RowCount - 1) |
| | | grdMain1.Rows.Add(); |
| | | grdMain1.Rows[i].Cells[HTagCol].Value = "*"; |
| | | grdMain1.Rows[i].Cells[HMaterIDCol].Value = oSub.HMaterID.ToString(); |
| | | if (oMater.GetInfoByID(oSub.HMaterID)) |
| | | { |
| | | grdMain.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber; |
| | | grdMain.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName; |
| | | grdMain.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel; |
| | | grdMain1.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber; |
| | | grdMain1.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName; |
| | | grdMain1.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[i].Cells[HMaterNumberCol].Value = ""; |
| | | grdMain.Rows[i].Cells[HMaterNameCol].Value = ""; |
| | | grdMain.Rows[i].Cells[HMaterModelCol].Value = ""; |
| | | grdMain1.Rows[i].Cells[HMaterNumberCol].Value = ""; |
| | | grdMain1.Rows[i].Cells[HMaterNameCol].Value = ""; |
| | | grdMain1.Rows[i].Cells[HMaterModelCol].Value = ""; |
| | | } |
| | | grdMain.Rows[i].Cells[HProcIDCol].Value = oSub.HProcID.ToString(); |
| | | grdMain1.Rows[i].Cells[HProcIDCol].Value = oSub.HProcID.ToString(); |
| | | if (oProc.GetInfoByID(oSub.HProcID)) |
| | | { |
| | | grdMain.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber; |
| | | grdMain.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName; |
| | | grdMain1.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber; |
| | | grdMain1.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[i].Cells[HProcNumberCol].Value = ""; |
| | | grdMain.Rows[i].Cells[HProcNameCol].Value = ""; |
| | | grdMain1.Rows[i].Cells[HProcNumberCol].Value = ""; |
| | | grdMain1.Rows[i].Cells[HProcNameCol].Value = ""; |
| | | } |
| | | |
| | | grdMain.Rows[i].Cells[HStdWorkTimes].Value = oSub.HStdWorkTimes.ToString(); |
| | | grdMain.Rows[i].Cells[HUpperlimit].Value = oSub.HUpperlimit.ToString(); |
| | | grdMain.Rows[i].Cells[HLowerlimit].Value = oSub.HLowerlimit.ToString(); |
| | | grdMain.Rows[i].Cells[HUSEORGID].Value = oSub.HUSEORGID.ToString(); |
| | | grdMain.Rows[i].Cells[HRemarkCol].Value = oSub.HRemark; |
| | | grdMain1.Rows[i].Cells[HStdWorkTimes].Value = oSub.HStdWorkTimes.ToString(); |
| | | grdMain1.Rows[i].Cells[HUpperlimit].Value = oSub.HUpperlimit.ToString(); |
| | | grdMain1.Rows[i].Cells[HLowerlimit].Value = oSub.HLowerlimit.ToString(); |
| | | grdMain1.Rows[i].Cells[HUSEORGID].Value = oSub.HUSEORGID.ToString(); |
| | | grdMain1.Rows[i].Cells[HRemarkCol].Value = oSub.HRemark; |
| | | i = i + 1; |
| | | } |
| | | //GRIDå
è®¸å·æ° |
| | |
| | | |
| | | //æç»è¡¨æ¯å¦ä¸ºé¶è¡ |
| | | bool b = false; |
| | | for (int i = 0; i < grdMain.RowCount; i++) |
| | | { |
| | | if (!IsNullRow(i)) |
| | | { |
| | | b = true; |
| | | break; |
| | | } |
| | | } |
| | | if (b == false) |
| | | if (!IsNullRow(0)) |
| | | { |
| | | MessageBox.Show("è¡¨ä½æç»è¡ä¸åå¨ï¼è¯·å½å
¥ï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | return true; |
| | | else |
| | | { |
| | | return true; |
| | | } |
| | | } |
| | | //ä¿ååæ® |
| | | private bool Sub_SaveBill() |
| | |
| | | // |
| | | //æç»ç±»èµå¼ |
| | | BillNew.DetailColl = new List<Model.ClsGy_StdWorkTimes_Model>(); |
| | | for (i = 0; i <= grdMain.RowCount - 1; i++) |
| | | for (i = 0; i <= grdMain1.RowCount - 1; i++) |
| | | { |
| | | if (DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value) != 0 && DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value) != 0) |
| | | if (DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HMaterIDCol].Value) != 0 && DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HProcIDCol].Value) != 0) |
| | | { |
| | | Model.ClsGy_StdWorkTimes_Model oSub = new Model.ClsGy_StdWorkTimes_Model(); |
| | | oSub.HMaterID = ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value); |
| | | oSub.HProcID = ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value); |
| | | oSub.HStdWorkTimes = ClsPub.isDoule(grdMain.Rows[i].Cells[HStdWorkTimes].Value); |
| | | oSub.HUpperlimit = ClsPub.isDoule(grdMain.Rows[i].Cells[HUpperlimit].Value); |
| | | oSub.HLowerlimit = ClsPub.isDoule(grdMain.Rows[i].Cells[HLowerlimit].Value); |
| | | oSub.HMaterID = ClsPub.isLong(grdMain1.Rows[i].Cells[HMaterIDCol].Value); |
| | | oSub.HProcID = ClsPub.isLong(grdMain1.Rows[i].Cells[HProcIDCol].Value); |
| | | oSub.HStdWorkTimes = ClsPub.isDoule(grdMain1.Rows[i].Cells[HStdWorkTimes].Value); |
| | | oSub.HUpperlimit = ClsPub.isDoule(grdMain1.Rows[i].Cells[HUpperlimit].Value); |
| | | oSub.HLowerlimit = ClsPub.isDoule(grdMain1.Rows[i].Cells[HLowerlimit].Value); |
| | | oSub.HUSEORGID = ClsPub.HOrgID; |
| | | oSub.HStopflag = true; |
| | | oSub.HStopflag = false; |
| | | oSub.HMaker = ClsPub.CurUserName; |
| | | oSub.HMakeDate = DateTime.Today.ToString(); |
| | | oSub.HRemark = ClsPub.isStrNull(grdMain.Rows[i].Cells[HRemarkCol].Value); |
| | | oSub.HRemark = ClsPub.isStrNull(grdMain1.Rows[i].Cells[HRemarkCol].Value); |
| | | BillNew.DetailColl.Add(oSub); |
| | | } |
| | | } |
| | |
| | | //åå§åGRID |
| | | private void initGrid() |
| | | { |
| | | grdMain.ColumnCount = 22; //æ»åæ° |
| | | DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name); |
| | | grdMain1.ColumnCount = 22; //æ»åæ° |
| | | DBUtility.Xt_BaseBillFun.initGridFst(grdMain1, this.Name); |
| | | // |
| | | grdMain.Columns[HMaterIDCol].HeaderText = "ç©æID"; |
| | | grdMain.Columns[HMaterNumberCol].HeaderText = "ç©æä»£ç "; |
| | | grdMain.Columns[HMaterNameCol].HeaderText = "ç©æåç§°"; |
| | | grdMain.Columns[HMaterModelCol].HeaderText = "è§æ ¼åå·"; |
| | | grdMain.Columns[HProcIDCol].HeaderText = "å·¥åºID"; |
| | | grdMain.Columns[HProcNumberCol].HeaderText = "å·¥åºä»£ç "; |
| | | grdMain.Columns[HProcNameCol].HeaderText = "å·¥åºåç§°"; |
| | | grdMain1.Columns[HMaterIDCol].HeaderText = "ç©æID"; |
| | | grdMain1.Columns[HMaterNumberCol].HeaderText = "ç©æä»£ç "; |
| | | grdMain1.Columns[HMaterNameCol].HeaderText = "ç©æåç§°"; |
| | | grdMain1.Columns[HMaterModelCol].HeaderText = "è§æ ¼åå·"; |
| | | grdMain1.Columns[HProcIDCol].HeaderText = "å·¥åºID"; |
| | | grdMain1.Columns[HProcNumberCol].HeaderText = "å·¥åºä»£ç "; |
| | | grdMain1.Columns[HProcNameCol].HeaderText = "å·¥åºåç§°"; |
| | | |
| | | grdMain.Columns[HStdWorkTimes].HeaderText = "æ åå·¥æ¶"; |
| | | grdMain.Columns[HUpperlimit].HeaderText = "ä¸éæ¯ä¾"; |
| | | grdMain.Columns[HLowerlimit].HeaderText = "ä¸éæ¯ä¾"; |
| | | grdMain.Columns[HUSEORGID].HeaderText = "ç»ç»ID"; |
| | | grdMain.Columns[HRemarkCol].HeaderText = "夿³¨"; |
| | | grdMain1.Columns[HStdWorkTimes].HeaderText = "æ åå·¥æ¶"; |
| | | grdMain1.Columns[HUpperlimit].HeaderText = "ä¸éæ¯ä¾"; |
| | | grdMain1.Columns[HLowerlimit].HeaderText = "ä¸éæ¯ä¾"; |
| | | grdMain1.Columns[HUSEORGID].HeaderText = "ç»ç»ID"; |
| | | grdMain1.Columns[HRemarkCol].HeaderText = "夿³¨"; |
| | | // |
| | | //éèå |
| | | grdMain.Columns[HTagCol].Visible = false; |
| | | grdMain.Columns[HProcIDCol].Visible = false; |
| | | grdMain.Columns[HMaterIDCol].Visible = false; |
| | | grdMain.Columns[HUSEORGID].Visible = false; |
| | | grdMain1.Columns[HTagCol].Visible = false; |
| | | grdMain1.Columns[HProcIDCol].Visible = false; |
| | | grdMain1.Columns[HMaterIDCol].Visible = false; |
| | | grdMain1.Columns[HUSEORGID].Visible = false; |
| | | //å¯ç¼è¾å |
| | | string sAllowCol = HMaterNumberCol.ToString() + |
| | | "," + HProcNumberCol.ToString() + |
| | |
| | | //æ¯å¦æ¯ç©ºè¡ |
| | | private bool IsNullRow(int Row) |
| | | { |
| | | if (ClsPub.isInt(grdMain.Rows[Row].Cells[HMaterIDCol].Value) == 0) |
| | | if (ClsPub.isInt(grdMain1.Rows[Row].Cells[HMaterIDCol].Value) == 0) |
| | | { |
| | | return true; |
| | | } |
| | |
| | | { |
| | | case HMaterNumberCol: |
| | | //BLL.ClsBaseSelect_K3.SetGridByMater_K3(grdMain, sRow, HMaterIDCol, HMaterNumberCol, HMaterNameCol, HMaterModelCol, 0, 0, 0); |
| | | BLL.ClsBaseSelect_InterFace.SetGridByMater(grdMain, sRow, HMaterIDCol, HMaterNumberCol, HMaterNameCol, HMaterModelCol, 0, 0, 0); |
| | | BLL.ClsBaseSelect_InterFace.SetGridByMater(grdMain1, sRow, HMaterIDCol, HMaterNumberCol, HMaterNameCol, HMaterModelCol, 0, 0, 0); |
| | | if (rbHSelectCus.Checked) |
| | | { |
| | | grdMain.Rows[sRow].Cells[HProcIDCol].Value = txtHProcID.Tag.ToString(); |
| | | grdMain.Rows[sRow].Cells[HProcNameCol].Value = txtHProcName.Text.Trim(); |
| | | grdMain.Rows[sRow].Cells[HProcNumberCol].Value = txtHProcID.Text.Trim(); |
| | | grdMain1.Rows[sRow].Cells[HProcIDCol].Value = txtHProcID.Tag.ToString(); |
| | | grdMain1.Rows[sRow].Cells[HProcNameCol].Value = txtHProcName.Text.Trim(); |
| | | grdMain1.Rows[sRow].Cells[HProcNumberCol].Value = txtHProcID.Text.Trim(); |
| | | } |
| | | oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HMaterNumberCol].Value); |
| | | oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain1.Rows[sRow].Cells[HMaterNumberCol].Value); |
| | | break; |
| | | case HProcNumberCol: |
| | | //BLL.ClsBaseSelect.SetGridByProc(grdMain, sRow, HProcIDCol, HProcNumberCol, HProcNameCol); |
| | | BLL.ClsBaseSelect_InterFace.SetGridByProc(grdMain, sRow, HProcIDCol, HProcNumberCol, HProcNameCol); |
| | | BLL.ClsBaseSelect_InterFace.SetGridByProc(grdMain1, sRow, HProcIDCol, HProcNumberCol, HProcNameCol); |
| | | if (rbHSelectMater.Checked) |
| | | { |
| | | grdMain.Rows[sRow].Cells[HMaterIDCol].Value = txtHMaterID.Tag.ToString(); |
| | | grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = txtHMaterID.Text.Trim(); |
| | | grdMain.Rows[sRow].Cells[HMaterNameCol].Value = txtHMaterName.Text.Trim(); |
| | | grdMain.Rows[sRow].Cells[HMaterModelCol].Value = txtHMaterModel.Text.Trim(); |
| | | grdMain1.Rows[sRow].Cells[HMaterIDCol].Value = txtHMaterID.Tag.ToString(); |
| | | grdMain1.Rows[sRow].Cells[HMaterNumberCol].Value = txtHMaterID.Text.Trim(); |
| | | grdMain1.Rows[sRow].Cells[HMaterNameCol].Value = txtHMaterName.Text.Trim(); |
| | | grdMain1.Rows[sRow].Cells[HMaterModelCol].Value = txtHMaterModel.Text.Trim(); |
| | | } |
| | | oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HProcNumberCol].Value); |
| | | oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain1.Rows[sRow].Cells[HProcNumberCol].Value); |
| | | break; |
| | | default: |
| | | break; |
| | |
| | | DataGridViewTextBoxEditingControl EditingControl; |
| | | private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) |
| | | { |
| | | int i = grdMain.CurrentCell.ColumnIndex; |
| | | int i = grdMain1.CurrentCell.ColumnIndex; |
| | | if (DBUtility.Xt_BaseBillFun.AllowEdit(grdStatus, oSumGrid, i)) |
| | | { |
| | | e.Cancel = true; |
| | |
| | | |
| | | private void grdMain_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e) |
| | | { |
| | | if (grdMain.CurrentCell != null) |
| | | if (grdMain1.CurrentCell != null) |
| | | { |
| | | if (e.Control is DataGridViewTextBoxEditingControl) |
| | | { |
| | |
| | | private void EditingControl_KeyDown(object sender, KeyEventArgs e) |
| | | { |
| | | //ä¸å¡å¤ç |
| | | Sub_GridKey(e.KeyValue, grdMain.CurrentRow.Index, grdMain.CurrentCell.ColumnIndex, EditingControl); |
| | | Sub_GridKey(e.KeyValue, grdMain1.CurrentRow.Index, grdMain1.CurrentCell.ColumnIndex, EditingControl); |
| | | } |
| | | |
| | | private void grdMain_RowHeadersWidthChanged(object sender, EventArgs e) |
| | |
| | | { |
| | | this.components = new System.ComponentModel.Container(); |
| | | System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Gy_StdWorkTimesList)); |
| | | System.Windows.Forms.TreeNode treeNode2 = new System.Windows.Forms.TreeNode("项ç®"); |
| | | System.Windows.Forms.TreeNode treeNode1 = new System.Windows.Forms.TreeNode("项ç®"); |
| | | this.tabPage1 = new System.Windows.Forms.TabPage(); |
| | | this.grdMain = new System.Windows.Forms.DataGridView(); |
| | | this.fsh = new System.Windows.Forms.ToolStripButton(); |
| | |
| | | this.toolStripButton1 = new System.Windows.Forms.ToolStripButton(); |
| | | this.yl = new System.Windows.Forms.ToolStripButton(); |
| | | this.toolStripSeparator6 = new System.Windows.Forms.ToolStripSeparator(); |
| | | this.gs = new System.Windows.Forms.ToolStripButton(); |
| | | this.wl = new System.Windows.Forms.ToolStripButton(); |
| | | this.xz = new System.Windows.Forms.ToolStripButton(); |
| | | this.xg = new System.Windows.Forms.ToolStripButton(); |
| | | this.sc = new System.Windows.Forms.ToolStripButton(); |
| | |
| | | this.mrlk = new System.Windows.Forms.ToolStripButton(); |
| | | this.toolStripSeparator7 = new System.Windows.Forms.ToolStripSeparator(); |
| | | this.bclk = new System.Windows.Forms.ToolStripButton(); |
| | | this.wl = new System.Windows.Forms.ToolStripButton(); |
| | | this.gs = new System.Windows.Forms.ToolStripButton(); |
| | | this.tabPage1.SuspendLayout(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit(); |
| | | ((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).BeginInit(); |
| | |
| | | this.fsh.Text = "å审"; |
| | | this.fsh.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.fsh.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.fsh.Click += new System.EventHandler(this.fsh_Click); |
| | | // |
| | | // toolStripSeparator3 |
| | | // |
| | |
| | | this.tc.Text = "éåº"; |
| | | this.tc.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.tc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.tc.Click += new System.EventHandler(this.tc_Click); |
| | | // |
| | | // toolStripSeparator5 |
| | | // |
| | |
| | | this.tv.Location = new System.Drawing.Point(0, 24); |
| | | this.tv.Margin = new System.Windows.Forms.Padding(4); |
| | | this.tv.Name = "tv"; |
| | | treeNode2.ForeColor = System.Drawing.Color.Black; |
| | | treeNode2.Name = "tjbb"; |
| | | treeNode2.NodeFont = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | treeNode2.StateImageKey = "æä»¶å¤¹1.ico"; |
| | | treeNode2.Text = "项ç®"; |
| | | treeNode1.ForeColor = System.Drawing.Color.Black; |
| | | treeNode1.Name = "tjbb"; |
| | | treeNode1.NodeFont = new System.Drawing.Font("å®ä½", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); |
| | | treeNode1.StateImageKey = "æä»¶å¤¹1.ico"; |
| | | treeNode1.Text = "项ç®"; |
| | | this.tv.Nodes.AddRange(new System.Windows.Forms.TreeNode[] { |
| | | treeNode2}); |
| | | treeNode1}); |
| | | this.tv.SelectedImageIndex = 1; |
| | | this.tv.Size = new System.Drawing.Size(195, 595); |
| | | this.tv.TabIndex = 16; |
| | |
| | | this.sh.Text = "å®¡æ ¸"; |
| | | this.sh.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.sh.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.sh.Click += new System.EventHandler(this.sh_Click); |
| | | // |
| | | // toolStripSeparator9 |
| | | // |
| | |
| | | this.toolStripSeparator6.Name = "toolStripSeparator6"; |
| | | this.toolStripSeparator6.Size = new System.Drawing.Size(6, 62); |
| | | // |
| | | // gs |
| | | // |
| | | this.gs.AutoSize = false; |
| | | this.gs.Image = ((System.Drawing.Image)(resources.GetObject("gs.Image"))); |
| | | this.gs.ImageAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.gs.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; |
| | | this.gs.ImageTransparentColor = System.Drawing.Color.White; |
| | | this.gs.Name = "gs"; |
| | | this.gs.Size = new System.Drawing.Size(35, 47); |
| | | this.gs.Text = "å·¥åº"; |
| | | this.gs.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.gs.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.gs.ToolTipText = "å·¥æ¶"; |
| | | this.gs.Click += new System.EventHandler(this.gs_Click); |
| | | this.gs.LocationChanged += new System.EventHandler(this.gs_Click); |
| | | // |
| | | // wl |
| | | // |
| | | this.wl.AutoSize = false; |
| | | this.wl.Checked = true; |
| | | this.wl.CheckState = System.Windows.Forms.CheckState.Checked; |
| | | this.wl.ForeColor = System.Drawing.SystemColors.ControlText; |
| | | this.wl.Image = ((System.Drawing.Image)(resources.GetObject("wl.Image"))); |
| | | this.wl.ImageAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.wl.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; |
| | | this.wl.ImageTransparentColor = System.Drawing.Color.White; |
| | | this.wl.Name = "wl"; |
| | | this.wl.Size = new System.Drawing.Size(35, 47); |
| | | this.wl.Text = "ç©æ"; |
| | | this.wl.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.wl.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.wl.Click += new System.EventHandler(this.wl_Click); |
| | | // |
| | | // xz |
| | | // |
| | | this.xz.AutoSize = false; |
| | |
| | | this.xz.Text = "æ°å¢"; |
| | | this.xz.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.xz.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.xz.Click += new System.EventHandler(this.xz_Click); |
| | | // |
| | | // xg |
| | | // |
| | |
| | | this.xg.Text = "ä¿®æ¹"; |
| | | this.xg.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.xg.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.xg.Click += new System.EventHandler(this.xg_Click); |
| | | // |
| | | // sc |
| | | // |
| | |
| | | this.sc.Text = "å é¤"; |
| | | this.sc.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.sc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.sc.Click += new System.EventHandler(this.sc_Click); |
| | | // |
| | | // toolStripSeparator2 |
| | | // |
| | |
| | | this.cx.Text = "æ¥è¯¢"; |
| | | this.cx.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.cx.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.cx.Click += new System.EventHandler(this.cx_Click); |
| | | // |
| | | // xs |
| | | // |
| | |
| | | this.xs.Text = "å·æ°"; |
| | | this.xs.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.xs.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.xs.Click += new System.EventHandler(this.xs_Click); |
| | | // |
| | | // toolStripSeparator1 |
| | | // |
| | |
| | | this.bclk.Text = "ä¿åå宽"; |
| | | this.bclk.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.bclk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | // |
| | | // wl |
| | | // |
| | | this.wl.AutoSize = false; |
| | | this.wl.Checked = true; |
| | | this.wl.CheckState = System.Windows.Forms.CheckState.Checked; |
| | | this.wl.ForeColor = System.Drawing.SystemColors.ControlText; |
| | | this.wl.Image = ((System.Drawing.Image)(resources.GetObject("wl.Image"))); |
| | | this.wl.ImageAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.wl.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; |
| | | this.wl.ImageTransparentColor = System.Drawing.Color.White; |
| | | this.wl.Name = "wl"; |
| | | this.wl.Size = new System.Drawing.Size(35, 47); |
| | | this.wl.Text = "ç©æ"; |
| | | this.wl.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.wl.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | // |
| | | // gs |
| | | // |
| | | this.gs.AutoSize = false; |
| | | this.gs.Image = ((System.Drawing.Image)(resources.GetObject("gs.Image"))); |
| | | this.gs.ImageAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.gs.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; |
| | | this.gs.ImageTransparentColor = System.Drawing.Color.White; |
| | | this.gs.Name = "gs"; |
| | | this.gs.Size = new System.Drawing.Size(35, 47); |
| | | this.gs.Text = "å·¥åº"; |
| | | this.gs.TextAlign = System.Drawing.ContentAlignment.BottomCenter; |
| | | this.gs.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText; |
| | | this.gs.ToolTipText = "å·¥æ¶"; |
| | | this.gs.LocationChanged += new System.EventHandler(this.gs_Click); |
| | | // |
| | | // Gy_StdWorkTimesList |
| | | // |
| | |
| | | HParentID = sr[0].ToString(); |
| | | } |
| | | //è¿æ»¤æ¡ä»¶ |
| | | if (frmCondition.SqlStr.Trim().Length == 0) |
| | | if (HParentID == "" || HParentID == "ç©æèµæ" || HParentID == "å·¥åºèµæ") |
| | | { |
| | | if (HParentID == "" || HParentID == "ç©æèµæ" || HParentID == "å·¥åºèµæ") |
| | | { |
| | | sSql = "Select top 10000 * from " + ViewName + " order by HItemID Desc"; |
| | | } |
| | | else |
| | | { |
| | | if (wl.Checked == false) |
| | | { |
| | | sSql = "Select top 10000 * from " + ViewName + " where å·¥åºä»£ç like '%" + HParentID.ToString() + "%' order by HItemID Desc" ; |
| | | } |
| | | else |
| | | { |
| | | sSql = "Select top 10000 * from " + ViewName + " where ç©æä»£ç like '%" + HParentID.ToString() + "%' order by HItemID Desc "; |
| | | } |
| | | |
| | | } |
| | | sSql = "Select top 10000 * from " + ViewName + " order by HItemID Desc"; |
| | | } |
| | | else |
| | | { |
| | | sSql = frmCondition.SqlStr + sWhere + " order by HItemID Desc"; |
| | | if (wl.Checked == false) |
| | | { |
| | | sSql = "Select top 10000 * from " + ViewName + " where å·¥åºä»£ç like '%" + HParentID.ToString() + "%' order by HItemID Desc"; |
| | | } |
| | | else |
| | | { |
| | | sSql = "Select top 10000 * from " + ViewName + " where ç©æä»£ç like '%" + HParentID.ToString() + "%' order by HItemID Desc "; |
| | | } |
| | | |
| | | } |
| | | //æ§è¡SQL |
| | | DSet = SubCn.RunProcReturn(sSql, ViewName); |
| | |
| | | oSumGrid.BuildTotalCols(sT); |
| | | // |
| | | //å»ç» |
| | | int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text); |
| | | string s = frmCondition.cmbHComplete.Text; |
| | | DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol); |
| | | //int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text); |
| | | //string s = frmCondition.cmbHComplete.Text; |
| | | //DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol); |
| | | //ç»çº¿ |
| | | // |
| | | Total(); |
| | | //Total(); |
| | | } |
| | | |
| | | //å计 new |
| | |
| | | AAEAAAD/////AQAAAAAAAAAMAgAAAFdTeXN0ZW0uV2luZG93cy5Gb3JtcywgVmVyc2lvbj00LjAuMC4w |
| | | LCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWI3N2E1YzU2MTkzNGUwODkFAQAAACZTeXN0 |
| | | ZW0uV2luZG93cy5Gb3Jtcy5JbWFnZUxpc3RTdHJlYW1lcgEAAAAERGF0YQcCAgAAAAkDAAAADwMAAACE |
| | | CgAAAk1TRnQBSQFMAgEBAgEAASQBAQEkAQEBEAEAARABAAT/ASEBAAj/AUIBTQE2BwABNgMAASgDAAFA |
| | | CgAAAk1TRnQBSQFMAgEBAgEAATQBAQE0AQEBEAEAARABAAT/ASEBAAj/AUIBTQE2BwABNgMAASgDAAFA |
| | | AwABEAMAAQEBAAEgBgABEBIAgP+AAAj/AwAB/wMAAf8DAAH/AwAB/wMAAf8DAAH/AwAB/wMAAf8DAAH/ |
| | | AwAB/wMAAf8DAAH/AwAB/wMADf8DAAH/AwAB/wMAAf8DAAH/AwAB/wMAAf8DAAH/AwAB/wMAAf8DAAH/ |
| | | AwAB/wMAAf8DAAH/gAAE/wEAAUEBigH/AQwBkAG5Af8BDAGQAbkB/wEMAZABuQH/AQwBkAG5Af8BDAGQ |
| | | AbkB/wEMAZABuQH/AQwBkAG5Af8BDAGQAbkB/wEMAZABuQH/AQwBkAG5Af8BDAGQAbkB/wEMAZABuQH/ |
| | | AQwBkAG5Af8DAAn/AQABQQGKAf8BAAFBAYoB/wEAAUEBigH/AQABQQGKAf8BAAFBAYoB/wEAAUEBigH/ |
| | | AQABQQGKAf8BAAFBAYoB/wEAAUEBigH/AQABQQGKAf8BAAFBAYoB/wEAAUEBigH/AwAB/wMAAf+AAAT/ |
| | | AQABQQGKAf8B0QH2Av8BUwHaAfQB/wFIAdMB8QH/AT0BywHvAf8BMwHEAe0B/wEpAb4B6wH/AR8BuAHo |
| | | Af8BEwGwAecB/wEJAakB5AH/AQABowHiAf8BAAGeAeAB/wEAAZoB3wH/AQwBkAG5Af8DAAn/AQABQQGK |
| | | Af8B0QH2Av8BKAG+AesB/wEiAbkB6QH/ARoBtAHnAf8BEgGwAeYB/wELAasB5AH/AQQBpwHjAf8BAAGi |
| | | AeEB/wEAAZ8B4QH/AQwBkAG5Af8BAAFBAYoB/wMAAf8DAAH/gAAE/wEAAUEBigH/AdEB9gL/AVkB3gH1 |
| | | Af8BTgHWAfMB/wFEAdAB8QH/ATkByQHuAf8BLwHCAewB/wEkAbwB6gH/ARoBtAHnAf8BDwGtAeUB/wEF |
| | | AaYB4wH/AQABoQHhAf8BAAGdAeAB/wEMAZABuQH/AwAF/wEAAUEBigH/AdEB9gL/ATMBxQHuAf8BLQHB |
| | | AesB/wEmAbwB6wH/AR4BtwHoAf8BFwGyAecB/wEPAa4B5QH/AQgBqQHkAf8BAQGlAeIB/wEAAaEB4QH/ |
| | | AQwBkAG5Af8DAAH/AQABQQGKAf8DAAH/gAAE/wEAAUEBigH/AdEB9gL/AYEB4QH3Af8BVQHaAfQB/wFK |
| | | AdQB8gH/AT8BzAHvAf8BNQHGAe4B/wErAcAB6wH/ASABuQHpAf8BFgGyAeYB/wELAasB5QH/AQEBpQHi |
| | | Af8BAAGfAeEB/wEMAZABuQH/AwAF/wEAAUEBigH/AdEB9gL/ATgByAHuAf8BMQHEAewB/wEqAb8B6wH/ |
| | | ASMBuwHqAf8BHAG2AegB/wEUAbAB5wH/AQ0BrAHlAf8BBgGnAeMB/wEAAaMB4gH/AQABQQGKAf8DAAH/ |
| | | AQABQQGKAf8DAAH/gAAE/wEAAUEBigH/AdEB9gL/AYYB5QH3Af8BWwHfAfUB/wFQAdgB8wH/AUYB0QHx |
| | | Af8BOwHKAe8B/wExAcQB7QH/AScBvQHqAf8BHAG2AegB/wERAa8B5QH/AQYBqAHjAf8BAAGiAeEB/wEM |
| | | AZABuQH/AwAB/wEAAUEBigH/AdEB9gL/AUQBzwHxAf8BPQHLAe8B/wE1AccB7gH/AS8BwgHsAf8BKAG9 |
| | | AeoB/wEgAbkB6QH/ARkBtAHnAf8BEgGwAeYB/wEKAaoB5QH/AQwBkAG5Af8DAAH/AQwBkAG5Af8BDAGQ |
| | | AbkB/wMAAf+AAAT/AQABQQGKAf8B0QH2Av8BjAHoAfkB/wGDAeIB9wH/AVcB3AH1Af8BTQHVAfIB/wFB |
| | | Ac4B8AH/ATcByAHuAf8BLQHBAewB/wEjAboB6gH/ARcBswHnAf8BDQGsAeUB/wEDAaYB4wH/AQwBkAG5 |
| | | Af8DAAH/AQABQQGKAf8B0QH2Av8BSQHTAfIB/wFBAc4B8AH/AToBygHuAf8BMwHFAe0B/wEtAcEB6wH/ |
| | | ASUBvAHqAf8BHgG3AegB/wEWAbIB5gH/AQ8BrgHlAf8BDAGQAbkB/wMAAf8BDAGQAbkB/wEMAZABuQH/ |
| | | AwAB/4AABP8BAAFBAYoB/wHRAfYC/wGQAesB+QH/AYgB5gH4Af8BXQHgAfYB/wFTAdkB8wH/AUgB0wHy |
| | | Af8BPQHLAe8B/wEzAcUB7QH/ASkBvgHrAf8BHwG4AekB/wETAbAB5gH/AQgBqQHkAf8BDAGQAbkB/wMA |
| | | Af8BAAFBAYoB/wEAAUEBigH/AQABQQGKAf8BAAFBAYoB/wEAAUEBigH/AQABQQGKAf8BAAFBAYoB/wEA |
| | | AUEBigH/AQABQQGKAf8BAAFBAYoB/wEAAUEBigH/AQABQQGKAf8BDAGQAbkB/wE6AckB7gH/AQwBkAG5 |
| | | Af8DAAH/gAAE/wEAAUEBigH/AdEB9gL/AZMB7QH6Af8BjQHpAfkB/wGFAeQB9wH/AVoB3gH1Af8BTgHW |
| | | AfMB/wFEAc8B8QH/ATkByQHvAf8BLwHCAewB/wElAbsB6QH/ARoBtQHnAf8BDwGtAeYB/wEMAZABuQH/ |
| | | AwAF/wEAAUEBigH/AdEB9gL/AZEB7AH6Af8BjQHpAfkB/wGKAecB+AH/AYYB5AH4Af8BgAHhAfcB/wFa |
| | | Ad0B9QH/AVQB2gHzAf8BTgHXAfMB/wFJAdMB8QH/AUMBzwHxAf8BPQHLAe8B/wEMAZABuQH/AwAB/4AA |
| | | BP8BAAFBAYoB/wHRAfYC/wHRAfYC/wHRAfYC/wHRAfYC/wHRAfYC/wHRAfYC/wHRAfYC/wHRAfYC/wHR |
| | | AfYC/wHRAfYC/wHRAfYC/wHRAfYC/wEMAZABuQH/AwAF/wEAAUEBigH/AdEB9gL/AZMB7QH6Af8BkAHr |
| | | AfkB/wGMAekB+QH/AYgB5gH4Af8BhAHjAfcB/wFdAeAB9gH/AVgB3AH1Af8B0QH2Av8B0QH2Av8B0QH2 |
| | | Av8B0QH2Av8BDAGQAbkB/wMAAf+AAAT/AQABQQGKAf8BHwGoAdMB/wEfAagB0wH/AR8BqAHTAf8BHwGo |
| | | AdMB/wEfAagB0wH/AR8BqAHTAf8BHwGoAdMB/wEAAUEBigH/AQABQQGKAf8BAAFBAYoB/wEAAUEBigH/ |
| | | AQABQQGKAf8BAAFBAYoJ/wEAAUEBigH/AdEB9gL/AZMB7QH6Af8BkgHsAfoB/wGPAesB+QH/AYsB6AH4 |
| | | Af8BhwHlAfcB/wHRAfYC/wEAAUEBigH/AQABQQGKAf8BAAFBAYoB/wEAAUEBigH/AQABQQGKAf8BAAFB |
| | | AYoF/4AACP8BAAFBAYoB/wG4AegB9QH/Ac4D/wHOA/8BnAP/AZwD/wEAAUEBigH/AwAh/wEAAUEBigH/ |
| | | AdEB9gL/AdEB9gL/AdEB9gL/AdEB9gL/AdEB9gL/AQABQQGKHf+AAAz/AQABQQGKAf8BAAFBAYoB/wEA |
| | | AUEBigH/AQABQQGKAf8BAAFBAYoB/wMAKf8BAAFBAYoB/wEAAUEBigH/AQABQQGKAf8BAAFBAYoB/wEA |
| | | AUEBiiH/gACA/4AAgP+AAAFCAU0BPgcAAT4DAAEoAwABQAMAARADAAEBAQABAQUAAYAXAAP/gQAL |
| | | AwAB/wMAAf8DAAH/gAAE/wEAAT8BigH/AQoBkAG5Af8BCgGQAbkB/wEKAZABuQH/AQoBkAG5Af8BCgGQ |
| | | AbkB/wEKAZABuQH/AQoBkAG5Af8BCgGQAbkB/wEKAZABuQH/AQoBkAG5Af8BCgGQAbkB/wEKAZABuQH/ |
| | | AQoBkAG5Af8DAAn/AQABPwGKAf8BAAE/AYoB/wEAAT8BigH/AQABPwGKAf8BAAE/AYoB/wEAAT8BigH/ |
| | | AQABPwGKAf8BAAE/AYoB/wEAAT8BigH/AQABPwGKAf8BAAE/AYoB/wEAAT8BigH/AwAB/wMAAf+AAAT/ |
| | | AQABPwGKAf8B0QH2Av8BUQHaAfQB/wFGAdMB8QH/ATsBywHvAf8BMQHEAe0B/wEnAb4B6wH/AR0BuAHo |
| | | Af8BEQGwAecB/wEHAakB5AH/AQABowHiAf8BAAGeAeAB/wEAAZoB3wH/AQoBkAG5Af8DAAn/AQABPwGK |
| | | Af8B0QH2Av8BJgG+AesB/wEgAbkB6QH/ARgBtAHnAf8BEAGwAeYB/wEJAasB5AH/AQIBpwHjAf8BAAGi |
| | | AeEB/wEAAZ8B4QH/AQoBkAG5Af8BAAE/AYoB/wMAAf8DAAH/gAAE/wEAAT8BigH/AdEB9gL/AVcB3gH1 |
| | | Af8BTAHWAfMB/wFCAdAB8QH/ATcByQHuAf8BLQHCAewB/wEiAbwB6gH/ARgBtAHnAf8BDQGtAeUB/wED |
| | | AaYB4wH/AQABoQHhAf8BAAGdAeAB/wEKAZABuQH/AwAF/wEAAT8BigH/AdEB9gL/ATEBxQHuAf8BKwHB |
| | | AesB/wEkAbwB6wH/ARwBtwHoAf8BFQGyAecB/wENAa4B5QH/AQYBqQHkAf8BAAGlAeIB/wEAAaEB4QH/ |
| | | AQoBkAG5Af8DAAH/AQABPwGKAf8DAAH/gAAE/wEAAT8BigH/AdEB9gL/AYEB4QH3Af8BUwHaAfQB/wFI |
| | | AdQB8gH/AT0BzAHvAf8BMwHGAe4B/wEpAcAB6wH/AR4BuQHpAf8BFAGyAeYB/wEJAasB5QH/AQABpQHi |
| | | Af8BAAGfAeEB/wEKAZABuQH/AwAF/wEAAT8BigH/AdEB9gL/ATYByAHuAf8BLwHEAewB/wEoAb8B6wH/ |
| | | ASEBuwHqAf8BGgG2AegB/wESAbAB5wH/AQsBrAHlAf8BBAGnAeMB/wEAAaMB4gH/AQABPwGKAf8DAAH/ |
| | | AQABPwGKAf8DAAH/gAAE/wEAAT8BigH/AdEB9gL/AYYB5QH3Af8BWQHfAfUB/wFOAdgB8wH/AUQB0QHx |
| | | Af8BOQHKAe8B/wEvAcQB7QH/ASUBvQHqAf8BGgG2AegB/wEPAa8B5QH/AQQBqAHjAf8BAAGiAeEB/wEK |
| | | AZABuQH/AwAB/wEAAT8BigH/AdEB9gL/AUIBzwHxAf8BOwHLAe8B/wEzAccB7gH/AS0BwgHsAf8BJgG9 |
| | | AeoB/wEeAbkB6QH/ARcBtAHnAf8BEAGwAeYB/wEIAaoB5QH/AQoBkAG5Af8DAAH/AQoBkAG5Af8BCgGQ |
| | | AbkB/wMAAf+AAAT/AQABPwGKAf8B0QH2Av8BjAHoAfkB/wGDAeIB9wH/AVUB3AH1Af8BSwHVAfIB/wE/ |
| | | Ac4B8AH/ATUByAHuAf8BKwHBAewB/wEhAboB6gH/ARUBswHnAf8BCwGsAeUB/wEBAaYB4wH/AQoBkAG5 |
| | | Af8DAAH/AQABPwGKAf8B0QH2Av8BRwHTAfIB/wE/Ac4B8AH/ATgBygHuAf8BMQHFAe0B/wErAcEB6wH/ |
| | | ASMBvAHqAf8BHAG3AegB/wEUAbIB5gH/AQ0BrgHlAf8BCgGQAbkB/wMAAf8BCgGQAbkB/wEKAZABuQH/ |
| | | AwAB/4AABP8BAAE/AYoB/wHRAfYC/wGQAesB+QH/AYgB5gH4Af8BWwHgAfYB/wFRAdkB8wH/AUYB0wHy |
| | | Af8BOwHLAe8B/wExAcUB7QH/AScBvgHrAf8BHQG4AekB/wERAbAB5gH/AQYBqQHkAf8BCgGQAbkB/wMA |
| | | Af8BAAE/AYoB/wEAAT8BigH/AQABPwGKAf8BAAE/AYoB/wEAAT8BigH/AQABPwGKAf8BAAE/AYoB/wEA |
| | | AT8BigH/AQABPwGKAf8BAAE/AYoB/wEAAT8BigH/AQABPwGKAf8BCgGQAbkB/wE4AckB7gH/AQoBkAG5 |
| | | Af8DAAH/gAAE/wEAAT8BigH/AdEB9gL/AZMB7QH6Af8BjQHpAfkB/wGFAeQB9wH/AVgB3gH1Af8BTAHW |
| | | AfMB/wFCAc8B8QH/ATcByQHvAf8BLQHCAewB/wEjAbsB6QH/ARgBtQHnAf8BDQGtAeYB/wEKAZABuQH/ |
| | | AwAF/wEAAT8BigH/AdEB9gL/AZEB7AH6Af8BjQHpAfkB/wGKAecB+AH/AYYB5AH4Af8BgAHhAfcB/wFY |
| | | Ad0B9QH/AVIB2gHzAf8BTAHXAfMB/wFHAdMB8QH/AUEBzwHxAf8BOwHLAe8B/wEKAZABuQH/AwAB/4AA |
| | | BP8BAAE/AYoB/wHRAfYC/wHRAfYC/wHRAfYC/wHRAfYC/wHRAfYC/wHRAfYC/wHRAfYC/wHRAfYC/wHR |
| | | AfYC/wHRAfYC/wHRAfYC/wHRAfYC/wEKAZABuQH/AwAF/wEAAT8BigH/AdEB9gL/AZMB7QH6Af8BkAHr |
| | | AfkB/wGMAekB+QH/AYgB5gH4Af8BhAHjAfcB/wFbAeAB9gH/AVYB3AH1Af8B0QH2Av8B0QH2Av8B0QH2 |
| | | Av8B0QH2Av8BCgGQAbkB/wMAAf+AAAT/AQABPwGKAf8BHQGoAdMB/wEdAagB0wH/AR0BqAHTAf8BHQGo |
| | | AdMB/wEdAagB0wH/AR0BqAHTAf8BHQGoAdMB/wEAAT8BigH/AQABPwGKAf8BAAE/AYoB/wEAAT8BigH/ |
| | | AQABPwGKAf8BAAE/AYoJ/wEAAT8BigH/AdEB9gL/AZMB7QH6Af8BkgHsAfoB/wGPAesB+QH/AYsB6AH4 |
| | | Af8BhwHlAfcB/wHRAfYC/wEAAT8BigH/AQABPwGKAf8BAAE/AYoB/wEAAT8BigH/AQABPwGKAf8BAAE/ |
| | | AYoF/4AACP8BAAE/AYoB/wG4AegB9QH/Ac4D/wHOA/8BnAP/AZwD/wEAAT8BigH/AwAh/wEAAT8BigH/ |
| | | AdEB9gL/AdEB9gL/AdEB9gL/AdEB9gL/AdEB9gL/AQABPwGKHf+AAAz/AQABPwGKAf8BAAE/AYoB/wEA |
| | | AT8BigH/AQABPwGKAf8BAAE/AYoB/wMAKf8BAAE/AYoB/wEAAT8BigH/AQABPwGKAf8BAAE/AYoB/wEA |
| | | AT8BiiH/gACA/4AAgP+AAAFCAU0BPgcAAT4DAAEoAwABQAMAARADAAEBAQABAQUAAYAXAAP/gQAL |
| | | </value> |
| | | </data> |
| | | <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> |
| | |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | //å代ç ç¨äº æ¿æ¢åé¡¹ç® |
| | | public string HOldNumber; |
| | | public Model.ClsGy_StdWorkTimes_Model omodel = new Model.ClsGy_StdWorkTimes_Model(); |
| | | public List<Model.ClsGy_StdWorkTimes_Model> DetailColl = new List<Model.ClsGy_StdWorkTimes_Model>(); |
| | | |
| | | //åå®¡æ ¸ |
| | |
| | | using Kanban; |
| | | using Demo; |
| | | using ProM.å§å¤ç®¡ç; |
| | | using BaseSet.å
¬ç¨èµæ.å
¶ä»åºç¡èµæ; |
| | | |
| | | namespace LMES |
| | | { |
| | |
| | | //MessageBox.Show("gnsy:"+gnsy + "gnmc:"+ gnmc); |
| | | switch (gnsy.ToLower()) |
| | | { |
| | | case "gy_stdworktimeslist": |
| | | //æé |
| | | Gy_StdWorkTimesList oGy_StdWorkTimesList = new Gy_StdWorkTimesList(); |
| | | oGy_StdWorkTimesList.MdiParent = oMain; |
| | | oGy_StdWorkTimesList.Show(); |
| | | oMainForm.AddTabPage(oGy_StdWorkTimesList); |
| | | break; |
| | | case "gy_dotcheck"://ç¹æ£é¡¹ç® |
| | | Gy_DotCheck oGy_DotCheck = new Gy_DotCheck(); |
| | | oGy_DotCheck.MdiParent = oMain; |
| | |
| | | oGy_DataIn_ProcessPrice.Show(); |
| | | oMainForm.AddTabPage(oGy_DataIn_ProcessPrice); |
| | | break; |
| | | case "gy_stdworktimes_routingbill": |
| | | Gy_StdWorkTimes_RoutingBill oGy_StdWorkTimes_RoutingBill = new Gy_StdWorkTimes_RoutingBill(); |
| | | oGy_StdWorkTimes_RoutingBill.MdiParent = oMain; |
| | | oGy_StdWorkTimes_RoutingBill.Show(); |
| | | oMainForm.AddTabPage(oGy_StdWorkTimes_RoutingBill); |
| | | break; |
| | | case "gy_datain_process": |
| | | Gy_DataIn_Process oGy_DataIn_Process = new Gy_DataIn_Process(); |
| | | oGy_DataIn_Process.MdiParent = oMain; |
| | |
| | | public string HRemark; |
| | | public long HUSEORGID; //ç»ç»ID |
| | | public long HProcID; //å·¥åºID |
| | | public string HProcNum; //å·¥åºID |
| | | public string HProcName; //å·¥åºID |
| | | public long HMaterID; //ç©æID |
| | | public string HMaterNum; //å·¥åºID |
| | | public string HMaterName; //å·¥åºID |
| | | public double HStdWorkTimes; //æ åå·¥æ¶ |
| | | public double HUpperlimit; //ä¸éæ¯ä¾ |
| | | public double HLowerlimit; //ä¸éæ¯ä¾ |
New file |
| | |
| | | <?xml version="1.0" encoding="utf-8"?> |
| | | <ClassDiagram /> |
| | |
| | | <Compile Include="æ°æ®å¯¼å
¥\Gy_DataIn_RoutingBill.designer.cs"> |
| | | <DependentUpon>Gy_DataIn_RoutingBill.cs</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="æ°æ®å¯¼å
¥\Gy_StdWorkTimes_RoutingBill.cs"> |
| | | <SubType>Form</SubType> |
| | | </Compile> |
| | | <Compile Include="æ°æ®å¯¼å
¥\Gy_StdWorkTimes_RoutingBill.designer.cs"> |
| | | <DependentUpon>Gy_StdWorkTimes_RoutingBill.cs</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="æ°æ®å¯¼å
¥\Gy_DataIn_RoutingBill_New.cs"> |
| | | <SubType>Form</SubType> |
| | | </Compile> |
| | | <Compile Include="æ°æ®å¯¼å
¥\Gy_DataIn_RoutingBill_New.designer.cs"> |
| | | <DependentUpon>Gy_DataIn_RoutingBill_New.cs</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="æ°æ®å¯¼å
¥\Gy_StdWorkTimes_RoutingBill.cs"> |
| | | <SubType>Form</SubType> |
| | | </Compile> |
| | | <Compile Include="æ°æ®å¯¼å
¥\Gy_StdWorkTimes_RoutingBill.Designer.cs"> |
| | | <DependentUpon>Gy_StdWorkTimes_RoutingBill.cs</DependentUpon> |
| | | </Compile> |
| | | <Compile Include="计å管ç\Gy_ICBomBill.cs"> |
| | | <SubType>Form</SubType> |
| | |
| | | <DependentUpon>Gy_DataIn_RoutingBill.cs</DependentUpon> |
| | | <SubType>Designer</SubType> |
| | | </EmbeddedResource> |
| | | <EmbeddedResource Include="æ°æ®å¯¼å
¥\Gy_StdWorkTimes_RoutingBill.resx"> |
| | | <DependentUpon>Gy_StdWorkTimes_RoutingBill.cs</DependentUpon> |
| | | <SubType>Designer</SubType> |
| | | </EmbeddedResource> |
| | | <EmbeddedResource Include="æ°æ®å¯¼å
¥\Gy_DataIn_RoutingBill_New.resx"> |
| | | <DependentUpon>Gy_DataIn_RoutingBill_New.cs</DependentUpon> |
| | | <SubType>Designer</SubType> |
| | | </EmbeddedResource> |
| | | <EmbeddedResource Include="æ°æ®å¯¼å
¥\Gy_StdWorkTimes_RoutingBill.resx"> |
| | | <DependentUpon>Gy_StdWorkTimes_RoutingBill.cs</DependentUpon> |
| | | </EmbeddedResource> |
| | | <EmbeddedResource Include="计å管ç\Gy_ICBomBill.resx"> |
| | | <DependentUpon>Gy_ICBomBill.cs</DependentUpon> |
| | |
| | | <Name>SQLHelper</Name> |
| | | </ProjectReference> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <None Include="ClassDiagram1.cd" /> |
| | | </ItemGroup> |
| | | <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" /> |
| | | <!-- To modify your build process, add your task inside one of the targets below and uncomment it. |
| | | Other similar extension points exist, see Microsoft.Common.targets. |
| | |
| | | <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> |
| | | <value>17, 17</value> |
| | | </metadata> |
| | | <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> |
| | | <value>25</value> |
| | | </metadata> |
| | | </root> |
| | |
| | |  |
| | | namespace PlanM.æ°æ®å¯¼å
¥ |
| | | namespace PlanM |
| | | { |
| | | partial class Gy_StdWorkTimes_RoutingBill |
| | | { |
| | | /// <summary> |
| | | /// Required designer variable. |
| | | /// å¿
éç设计å¨åéã |
| | | /// </summary> |
| | | private System.ComponentModel.IContainer components = null; |
| | | |
| | | /// <summary> |
| | | /// Clean up any resources being used. |
| | | /// æ¸
çæææ£å¨ä½¿ç¨çèµæºã |
| | | /// </summary> |
| | | /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param> |
| | | /// <param name="disposing">妿åºéæ¾æç®¡èµæºï¼ä¸º trueï¼å¦å为 falseã</param> |
| | | protected override void Dispose(bool disposing) |
| | | { |
| | | if (disposing && (components != null)) |
| | |
| | | base.Dispose(disposing); |
| | | } |
| | | |
| | | #region Windows Form Designer generated code |
| | | #region Windows çªä½è®¾è®¡å¨çæç代ç |
| | | |
| | | /// <summary> |
| | | /// Required method for Designer support - do not modify |
| | | /// the contents of this method with the code editor. |
| | | /// è®¾è®¡å¨æ¯ææéçæ¹æ³ - ä¸è¦ |
| | | /// 使ç¨ä»£ç ç¼è¾å¨ä¿®æ¹æ¤æ¹æ³çå
容ã |
| | | /// </summary> |
| | | private void InitializeComponent() |
| | | { |
| | | this.label1 = new System.Windows.Forms.Label(); |
| | | this.cmbHYear = new System.Windows.Forms.ComboBox(); |
| | | this.cmbHPeriod = new System.Windows.Forms.ComboBox(); |
| | | this.label2 = new System.Windows.Forms.Label(); |
| | | this.checkadd = new System.Windows.Forms.CheckBox(); |
| | | this.txtHSheetName = new System.Windows.Forms.TextBox(); |
| | | this.label3 = new System.Windows.Forms.Label(); |
| | | this.pPic.SuspendLayout(); |
| | | this.panel1.SuspendLayout(); |
| | | this.SuspendLayout(); |
| | | // |
| | | // pPic |
| | | // |
| | | this.pPic.Margin = new System.Windows.Forms.Padding(5, 5, 5, 5); |
| | | this.pPic.Size = new System.Drawing.Size(1544, 56); |
| | | // |
| | | // panel1 |
| | | // |
| | | this.panel1.Controls.Add(this.label3); |
| | | this.panel1.Controls.Add(this.txtHSheetName); |
| | | this.panel1.Controls.Add(this.checkadd); |
| | | this.panel1.Controls.Add(this.cmbHPeriod); |
| | | this.panel1.Controls.Add(this.label2); |
| | | this.panel1.Controls.Add(this.cmbHYear); |
| | | this.panel1.Controls.Add(this.label1); |
| | | this.panel1.Margin = new System.Windows.Forms.Padding(5, 5, 5, 5); |
| | | this.panel1.Size = new System.Drawing.Size(1544, 52); |
| | | this.panel1.Controls.SetChildIndex(this.cmdHPath, 0); |
| | | this.panel1.Controls.SetChildIndex(this.label4, 0); |
| | | this.panel1.Controls.SetChildIndex(this.txtHPath, 0); |
| | | this.panel1.Controls.SetChildIndex(this.label1, 0); |
| | | this.panel1.Controls.SetChildIndex(this.cmbHYear, 0); |
| | | this.panel1.Controls.SetChildIndex(this.label2, 0); |
| | | this.panel1.Controls.SetChildIndex(this.cmbHPeriod, 0); |
| | | this.panel1.Controls.SetChildIndex(this.checkadd, 0); |
| | | this.panel1.Controls.SetChildIndex(this.txtHSheetName, 0); |
| | | this.panel1.Controls.SetChildIndex(this.label3, 0); |
| | | // |
| | | // lblCaption |
| | | // |
| | | this.lblCaption.Margin = new System.Windows.Forms.Padding(5, 0, 5, 0); |
| | | this.lblCaption.Size = new System.Drawing.Size(160, 24); |
| | | this.lblCaption.Text = "æ°æ®å¯¼å
¥æ¨¡å"; |
| | | // |
| | | // cmdHPath |
| | | // |
| | | this.cmdHPath.Location = new System.Drawing.Point(1043, 9); |
| | | this.cmdHPath.Margin = new System.Windows.Forms.Padding(5, 5, 5, 5); |
| | | // |
| | | // txtHPath |
| | | // |
| | | this.txtHPath.Location = new System.Drawing.Point(615, 4); |
| | | this.txtHPath.Margin = new System.Windows.Forms.Padding(5, 5, 5, 5); |
| | | this.txtHPath.Size = new System.Drawing.Size(419, 39); |
| | | // |
| | | // label4 |
| | | // |
| | | this.label4.Location = new System.Drawing.Point(520, 15); |
| | | this.label4.Margin = new System.Windows.Forms.Padding(5, 0, 5, 0); |
| | | // |
| | | // label1 |
| | | // |
| | | this.label1.AutoSize = true; |
| | | this.label1.Location = new System.Drawing.Point(35, 11); |
| | | this.label1.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); |
| | | this.label1.Name = "label1"; |
| | | this.label1.Size = new System.Drawing.Size(67, 15); |
| | | this.label1.TabIndex = 104; |
| | | this.label1.Text = "ä¼è®¡å¹´ï¼"; |
| | | // |
| | | // cmbHYear |
| | | // |
| | | this.cmbHYear.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; |
| | | this.cmbHYear.FormattingEnabled = true; |
| | | this.cmbHYear.Location = new System.Drawing.Point(112, 10); |
| | | this.cmbHYear.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); |
| | | this.cmbHYear.Name = "cmbHYear"; |
| | | this.cmbHYear.Size = new System.Drawing.Size(124, 23); |
| | | this.cmbHYear.TabIndex = 105; |
| | | // |
| | | // cmbHPeriod |
| | | // |
| | | this.cmbHPeriod.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; |
| | | this.cmbHPeriod.FormattingEnabled = true; |
| | | this.cmbHPeriod.Items.AddRange(new object[] { |
| | | "1", |
| | | "2", |
| | | "3", |
| | | "4", |
| | | "5", |
| | | "6", |
| | | "7", |
| | | "8", |
| | | "9", |
| | | "10", |
| | | "11", |
| | | "12"}); |
| | | this.cmbHPeriod.Location = new System.Drawing.Point(359, 12); |
| | | this.cmbHPeriod.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); |
| | | this.cmbHPeriod.Name = "cmbHPeriod"; |
| | | this.cmbHPeriod.Size = new System.Drawing.Size(112, 23); |
| | | this.cmbHPeriod.TabIndex = 107; |
| | | // |
| | | // label2 |
| | | // |
| | | this.label2.AutoSize = true; |
| | | this.label2.Location = new System.Drawing.Point(264, 12); |
| | | this.label2.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); |
| | | this.label2.Name = "label2"; |
| | | this.label2.Size = new System.Drawing.Size(82, 15); |
| | | this.label2.TabIndex = 106; |
| | | this.label2.Text = "ä¼è®¡æé´ï¼"; |
| | | // |
| | | // checkadd |
| | | // |
| | | this.checkadd.AutoSize = true; |
| | | this.checkadd.Checked = true; |
| | | this.checkadd.CheckState = System.Windows.Forms.CheckState.Checked; |
| | | this.checkadd.Location = new System.Drawing.Point(1447, 12); |
| | | this.checkadd.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); |
| | | this.checkadd.Name = "checkadd"; |
| | | this.checkadd.Size = new System.Drawing.Size(59, 19); |
| | | this.checkadd.TabIndex = 108; |
| | | this.checkadd.Text = "追å "; |
| | | this.checkadd.UseVisualStyleBackColor = true; |
| | | // |
| | | // txtHSheetName |
| | | // |
| | | this.txtHSheetName.Location = new System.Drawing.Point(1265, 11); |
| | | this.txtHSheetName.Margin = new System.Windows.Forms.Padding(4, 4, 4, 4); |
| | | this.txtHSheetName.Name = "txtHSheetName"; |
| | | this.txtHSheetName.Size = new System.Drawing.Size(132, 25); |
| | | this.txtHSheetName.TabIndex = 109; |
| | | this.txtHSheetName.Text = "Sheet1"; |
| | | // |
| | | // label3 |
| | | // |
| | | this.label3.AutoSize = true; |
| | | this.label3.Location = new System.Drawing.Point(1203, 12); |
| | | this.label3.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0); |
| | | this.label3.Name = "label3"; |
| | | this.label3.Size = new System.Drawing.Size(52, 15); |
| | | this.label3.TabIndex = 110; |
| | | this.label3.Text = "å·¥ä½ç°¿"; |
| | | // |
| | | // Gy_StdWorkTimes_RoutingBill |
| | | // |
| | | this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F); |
| | | this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; |
| | | this.ClientSize = new System.Drawing.Size(1170, 712); |
| | | this.ClientSize = new System.Drawing.Size(1544, 789); |
| | | this.Margin = new System.Windows.Forms.Padding(5, 5, 5, 5); |
| | | this.Name = "Gy_StdWorkTimes_RoutingBill"; |
| | | this.Text = "æ åå·¥æ¶æ°æ®å¯¼å
¥"; |
| | | this.Text = "æ°æ®å¯¼å
¥æ¨¡å"; |
| | | this.Load += new System.EventHandler(this.Gy_StdWorkTimes_RoutingBill_Load); |
| | | this.pPic.ResumeLayout(false); |
| | | this.pPic.PerformLayout(); |
| | | this.panel1.ResumeLayout(false); |
| | | this.panel1.PerformLayout(); |
| | | this.ResumeLayout(false); |
| | | |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | private System.Windows.Forms.ComboBox cmbHPeriod; |
| | | private System.Windows.Forms.Label label2; |
| | | private System.Windows.Forms.ComboBox cmbHYear; |
| | | private System.Windows.Forms.Label label1; |
| | | private System.Windows.Forms.CheckBox checkadd; |
| | | private System.Windows.Forms.Label label3; |
| | | private System.Windows.Forms.TextBox txtHSheetName; |
| | | } |
| | | } |
| | | } |
| | |
| | | using System; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.ComponentModel; |
| | | using System.Data; |
| | | using System.Drawing; |
| | | using System.Linq; |
| | | using System.Text; |
| | | using System.Windows.Forms; |
| | | using Pub_Class; |
| | | using SQLHelper; |
| | | |
| | | namespace PlanM.æ°æ®å¯¼å
¥ |
| | | namespace PlanM |
| | | { |
| | | public partial class Gy_StdWorkTimes_RoutingBill : Form |
| | | public partial class Gy_StdWorkTimes_RoutingBill : BLL.Gy_DataInTmp |
| | | { |
| | | public Gy_StdWorkTimes_RoutingBill() |
| | | { |
| | | InitializeComponent(); |
| | | } |
| | | public int HItemID =0; |
| | | public int HMaker = 0; //å¶å人 |
| | | public int HMakeDate = 0; //å¶åæ¥æ |
| | | public int HChecker = 0; //å®¡æ ¸äºº |
| | | public int HCheckDate = 0; //å®¡æ ¸æ¥æ |
| | | public int HStopflag = 0; |
| | | public int HRemark = 0; |
| | | public int HUSEORGName = 0; //ç»ç»ID |
| | | public int HProcName = 0; // |
| | | public int HMaterName = 0; //ç©æID |
| | | public int HProcNum = 0; // |
| | | public int HMaterNum = 0; //ç©æID |
| | | public int HStdWorkTimes = 0; //æ åå·¥æ¶ |
| | | public int HUpperlimit = 0; //ä¸éæ¯ä¾ |
| | | public int HLowerlimit = 0; //ä¸éæ¯ä¾ |
| | | |
| | | //public int HMaterNumberCol = 0; //产å代ç |
| | | //public int HWorkTypeNameCol = 0; //å·¥ç§ |
| | | //public int HProcNameCol = 0; //å·¥åº |
| | | //public int HWorkCenterNameCol = 0; //å·¥ä½ä¸å¿ |
| | | //public int HProcMulNameCol = 0; //工段 |
| | | //public int HWorkCenterName_SCol = 0; //产线 |
| | | //public int HWorkQtyCol = 0; //äº§è½ |
| | | //public int HSubStdEmpQtyCol = 0; //äººæ° |
| | | //public int HWorkQty_SCol = 0; //äº§çº¿äº§è½ |
| | | //public int HSubStdEmpQty_SCol = 0; //äº§çº¿äººæ° |
| | | |
| | | //public int HMouldNoCol = 0; //模å
·ç¼å· |
| | | //public int HChangeMouldCol = 0; //æ¢æ¨¡æ¶é´ |
| | | //public int HPackStdCol = 0; //å¨è½¬ç®±æ å |
| | | //public int HPackCol = 0; //å¨è½¬ç®± |
| | | //public int HPutAreaCol = 0; //ææ¾åº |
| | | //// |
| | | //public int HMyWorkDaysCol = 0; //çäº§å¨æ |
| | | //public int HMyFixWorkDaysCol = 0; //åºå®çäº§å¤©æ° |
| | | |
| | | //public int HBeginDayQtyCol = 6; //å¼å·¥åºå¤© |
| | | //public int HBeginFixQtyCol = 7; //å¼å·¥ä½é |
| | | //public int HFixPriceCol = 8; //å®é¢ å°æ¶å·¥èµ |
| | | //public int HProcPriceCol = 9; //工价 |
| | | //public int HProcTypeCol = 0; //å·¥åºç±»å |
| | | // |
| | | public const int HBeginRow = 2; //æææ°æ®ï¼å¼å§è¡æ° |
| | | // |
| | | //DAL.ClsGy_RoutingBill; |
| | | public DAL.ClsGy_Process_View oProcHlp = new DAL.ClsGy_Process_View(); |
| | | public DAL.ClsGy_StdWorkTimes_Ctl BillNew = new DAL.ClsGy_StdWorkTimes_Ctl(); |
| | | DAL.ClsIF_Material_View oMaterHlp = new DAL.ClsIF_Material_View(); |
| | | //DAL.ClsGy_WorkType_View oWorkType = new DAL.ClsGy_WorkType_View(); |
| | | long j = -1; |
| | | int c = 0; |
| | | |
| | | public override bool OpenExcelData() |
| | | { |
| | | base.sSheetName = txtHSheetName.Text; |
| | | return base.OpenExcelData(); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// åå§åçé¢ |
| | | /// </summary> |
| | | public override void initData() |
| | | { |
| | | base.initData(); |
| | | base.sSheetName = txtHSheetName.Text ; |
| | | base.ModRightName = "Gy_StdWorkTimes_RoutingBill"; |
| | | base.ModRightNameCheck = base.ModRightName + base.ModRightNameCheck; |
| | | base.ModRightNameClose = base.ModRightName + base.ModRightNameClose; |
| | | base.ModRightNameDelete = base.ModRightName + base.ModRightNameDelete; |
| | | base.ModRightNameEdit = base.ModRightName + base.ModRightNameEdit; |
| | | base.ModRightNameMoney = base.ModRightName + base.ModRightNameMoney; |
| | | base.ModRightNameQty = base.ModRightName + base.ModRightNameQty; |
| | | base.ModCaption = "æ åå·¥æ¶å¯¼å
¥"; |
| | | this.Text = base.ModCaption; |
| | | lblCaption.Text = base.ModCaption; |
| | | // |
| | | DBUtility.Gy_BaseFun.SetComboxYear(cmbHYear); |
| | | DBUtility.Gy_BaseFun.SetComboxPeriod(cmbHPeriod); |
| | | // |
| | | } |
| | | //导å
¥ |
| | | public override void Sub_DataIn() |
| | | { |
| | | string hnumber = ""; |
| | | // |
| | | HStdWorkTimes = DBUtility.Gy_BaseFun.Fun_GetCol("æ åå·¥æ¶", grdMain); |
| | | HProcNum = DBUtility.Gy_BaseFun.Fun_GetCol("å·¥åºä»£ç ", grdMain); |
| | | HProcName = DBUtility.Gy_BaseFun.Fun_GetCol("å·¥åº", grdMain); |
| | | HMaterNum = DBUtility.Gy_BaseFun.Fun_GetCol("ç©æä»£ç ", grdMain); |
| | | HMaterName = DBUtility.Gy_BaseFun.Fun_GetCol("ç©æ", grdMain); |
| | | HUpperlimit = DBUtility.Gy_BaseFun.Fun_GetCol("ä¸çº¿æ¯ä¾", grdMain); |
| | | HLowerlimit = DBUtility.Gy_BaseFun.Fun_GetCol("ä¸çº¿æ¯ä¾", grdMain); |
| | | HUSEORGName = DBUtility.Gy_BaseFun.Fun_GetCol("ç»ç»", grdMain); |
| | | HMaker = DBUtility.Gy_BaseFun.Fun_GetCol("å¶å人", grdMain); |
| | | HMakeDate = DBUtility.Gy_BaseFun.Fun_GetCol("å¶åæ¥æ", grdMain); |
| | | |
| | | //æ²¡ææ¾å°å |
| | | if (HStdWorkTimes == -1) |
| | | { |
| | | MessageBox.Show("æ²¡ææ¾å°ãæ åå·¥æ¶ãçæ é¢", "æç¤º"); |
| | | return; |
| | | } |
| | | if (HProcName == -1) |
| | | { |
| | | MessageBox.Show("æ²¡ææ¾å°ãå·¥åºãçæ é¢", "æç¤º"); |
| | | return; |
| | | } |
| | | if (HMaterName == -1) |
| | | { |
| | | MessageBox.Show("æ²¡ææ¾å°ãç©æãçæ é¢", "æç¤º"); |
| | | return; |
| | | } |
| | | if (HUpperlimit == -1) |
| | | { |
| | | MessageBox.Show("æ²¡ææ¾å°ãä¸çº¿æ¯ä¾ãçæ é¢", "æç¤º"); |
| | | return; |
| | | } |
| | | if (HLowerlimit == -1) |
| | | { |
| | | MessageBox.Show("æ²¡ææ¾å°ãä¸çº¿æ¯ä¾ãçæ é¢", "æç¤º"); |
| | | return; |
| | | } |
| | | if (HUSEORGName == -1) |
| | | { |
| | | MessageBox.Show("æ²¡ææ¾å°ãç»ç»ãçæ é¢", "æç¤º"); |
| | | return; |
| | | } |
| | | if (HMaker == -1) |
| | | { |
| | | MessageBox.Show("æ²¡ææ¾å°ãå¶å人ãçæ é¢", "æç¤º"); |
| | | return; |
| | | } |
| | | if (HMakeDate == -1) |
| | | { |
| | | MessageBox.Show("æ²¡ææ¾å°ãå¶åæ¥æãçæ é¢", "æç¤º"); |
| | | return; |
| | | } |
| | | // |
| | | if (!Checkdata()) |
| | | { |
| | | return; |
| | | } |
| | | if (grdMain.Rows.Count > 0) |
| | | { |
| | | hnumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells[HMaterNum].Value); |
| | | BillNew.omodel.HMakeDate = (DateTime.Today.Date).ToString(); |
| | | BillNew.omodel.HUSEORGID = DBUtility.ClsPub.HOrgID; |
| | | BillNew.omodel.HStopflag = false; |
| | | BillNew.DetailColl.Clear(); |
| | | } |
| | | for (int i = 0; i <= grdMain.Rows.Count - 1; i++) |
| | | { |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HProcNum].Value) != "" && DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNum].Value) != "") |
| | | { |
| | | //åå
¥ç±» |
| | | if (WriteClass(i)) |
| | | { |
| | | //ä¿åè®°å½ |
| | | if (!BillNew.AddNew()) |
| | | { |
| | | MessageBox.Show("导å
¥å¤±è´¥!åå :" + DBUtility.ClsPub.sExeReturnInfo, "æç¤º"); |
| | | return; |
| | | } |
| | | } |
| | | } |
| | | else |
| | | { |
| | | MessageBox.Show("å·¥åºä»£ç æç©æä»£ç 为空!åå :" + DBUtility.ClsPub.sExeReturnInfo, "æç¤º"); |
| | | return; |
| | | } |
| | | } |
| | | MessageBox.Show("导å
¥å®æ¯"); |
| | | grdMain.DataSource = null; |
| | | } |
| | | |
| | | //åå
¥ç±» 仿§ä»¶ |
| | | private bool WriteClass(int row) |
| | | { |
| | | string sHNumber = ""; |
| | | string sHNamePoc = ""; |
| | | string HStopflag = ""; |
| | | string HUSEORGID = ""; |
| | | //string sHNumberWorkType = ""; |
| | | string HStdWorkTimes = ""; |
| | | string HUpperlimit=""; //ä¸éæ¯ä¾ |
| | | string HLowerlimit=""; //ä¸éæ¯ä¾ |
| | | |
| | | int HMaterNum = DBUtility.Gy_BaseFun.Fun_GetCol("产å代ç ", grdMain); |
| | | int sMaterNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("产ååç§°", grdMain); |
| | | int sModelCol = DBUtility.Gy_BaseFun.Fun_GetCol("è§æ ¼åå·", grdMain); |
| | | int HProcNum = DBUtility.Gy_BaseFun.Fun_GetCol("å·¥åºä»£ç ", grdMain); |
| | | int sProcNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("å·¥åº", grdMain); |
| | | int sSourceNumberCol = DBUtility.Gy_BaseFun.Fun_GetCol("èµæºä»£ç ", grdMain); |
| | | int sSourceNameCol = DBUtility.Gy_BaseFun.Fun_GetCol("çäº§èµæº", grdMain); |
| | | int sPriceCol = DBUtility.Gy_BaseFun.Fun_GetCol("åä»·", grdMain); |
| | | //long HItemID = 0; |
| | | // |
| | | sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HMaterNum].Value); |
| | | sHNamePoc = DBUtility.ClsPub.isStrNull(grdMain.Rows[row].Cells[HProcNum].Value); |
| | | // |
| | | // |
| | | HStopflag = DBUtility.ClsPub.isBool(grdMain.Rows[row].Cells[HStopflag].Value).ToString(); |
| | | HUSEORGID = DBUtility.ClsPub.HOrgID.ToString(); |
| | | HStdWorkTimes = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HStdWorkTimes].Value).ToString(); |
| | | HUpperlimit = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HUpperlimit].Value).ToString(); |
| | | HLowerlimit = DBUtility.ClsPub.isSingle(grdMain.Rows[row].Cells[HLowerlimit].Value).ToString(); |
| | | |
| | | //夿æ¯å¦å
许 ä¿å |
| | | if (!DBUtility.ClsPub.AllowNumber(sHNumber)) |
| | | { |
| | | MessageBox.Show("产å代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | if (!DBUtility.ClsPub.AllowNumber(sHNamePoc)) |
| | | { |
| | | MessageBox.Show("å·¥åºä»£ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | |
| | | Model.ClsGy_StdWorkTimes_Model oSub = new Model.ClsGy_StdWorkTimes_Model(); |
| | | |
| | | //å¾å°å·¥åºå
ç |
| | | if (oProcHlp.GetInfoByName(sHNamePoc)) |
| | | { |
| | | oSub.HProcID = oProcHlp.omodel.HItemID; |
| | | } |
| | | //å¾å°ç©æå
ç |
| | | if (oMaterHlp.GetInfoByName(sHNumber)) |
| | | { |
| | | oSub.HMaterID = oMaterHlp.omodel.HItemID; |
| | | } |
| | | |
| | | |
| | | //åå
¥ä¿¡æ¯ |
| | | oSub.HEntryID = j; |
| | | |
| | | oSub.HMaker = DBUtility.ClsPub.CurUserName; |
| | | oSub.HMakeDate = (DateTime.Today.Date).ToString(); |
| | | oSub.HStdWorkTimes = double.Parse(HStdWorkTimes); |
| | | oSub.HRemark = ""; |
| | | oSub.HUpperlimit = double.Parse(HUpperlimit); |
| | | oSub.HLowerlimit = double.Parse(HLowerlimit); |
| | | oSub.HStopflag = bool.Parse(HStopflag); |
| | | |
| | | |
| | | BillNew.DetailColl.Add(oSub); |
| | | return true; |
| | | } |
| | | |
| | | //æ£æ¥ç©æ |
| | | private bool Checkdata() |
| | | { |
| | | bool b = false; |
| | | string sErrMsg = ""; |
| | | string sMsg = ""; |
| | | for (int i = 0; i <= grdMain.Rows.Count - 1; i++) |
| | | { |
| | | string sHNumber = ""; |
| | | string sHNamePoc = ""; |
| | | |
| | | // |
| | | sHNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMaterNum].Value); |
| | | sHNamePoc = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HProcNum].Value); |
| | | if (sHNumber != "") |
| | | { |
| | | // |
| | | //å®¡æ ¸ä»£ç æ¯å¦åç |
| | | if (!DBUtility.ClsPub.AllowNumber(sHNumber)) |
| | | { |
| | | MessageBox.Show("ç©æä»£ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | //å¾å°ç©æå
ç |
| | | int j = i + HBeginRow; |
| | | if (!oMaterHlp.GetInfoByNumber(sHNumber)) |
| | | { |
| | | sMsg = "[" + sHNumber + "]ç©æä¸åå¨"; |
| | | if (sErrMsg.Contains(sMsg) == false) |
| | | { |
| | | sErrMsg = sErrMsg + "[" + sHNumber + "]ç©æä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | } |
| | | //å¾å°å·¥åºå
ç |
| | | if (!oProcHlp.GetInfoByName(sHNamePoc)) |
| | | { |
| | | sMsg = "[" + sHNamePoc + "]å·¥åºä¸åå¨"; |
| | | if (sErrMsg.Contains(sMsg) == false) |
| | | { |
| | | sErrMsg = sErrMsg + "[" + sHNamePoc + "]å·¥åºä¸åå¨\r\n"; |
| | | } |
| | | b = true; |
| | | } |
| | | } |
| | | } |
| | | if (b == true) |
| | | { |
| | | Pub_Control.ErrMsgBox oMsgbox = new Pub_Control.ErrMsgBox(); |
| | | oMsgbox.txtHErrMsg.Text = sErrMsg; |
| | | oMsgbox.ShowDialog(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | return true; |
| | | } |
| | | } |
| | | |
| | | private void Gy_StdWorkTimes_RoutingBill_Load(object sender, EventArgs e) |
| | | { |
| | | |
| | | } |
| | | } |
| | | } |
| | | |
| | |
| | | <?xml version="1.0" encoding="utf-8"?> |
| | | <?xml version="1.0" encoding="utf-8"?> |
| | | <root> |
| | | <!-- |
| | | Microsoft ResX Schema |
| | |
| | | <resheader name="writer"> |
| | | <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> |
| | | </resheader> |
| | | <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> |
| | | <value>17, 17</value> |
| | | </metadata> |
| | | </root> |
| | |
| | | private JsonResult objJsonResult = new JsonResult(); |
| | | public WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | public WebS.ClsKf_ICStockBill_WMS WebSoBar = new WebS.ClsKf_ICStockBill_WMS(); |
| | | public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | |
| | | /// <summary> |
| | | /// å§å¤å
¥åº/æ«æ¡ç /ç´æ¥è°webservice |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | #region å§å¤åºåº |
| | | /// <summary> |
| | | /// å§å¤åºåº/æäº¤/ç´æ¥è°ç¨webservice |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Kf_EntrustInBill/set_SaveEntrustOutBill_Json")] |
| | | [HttpPost] |
| | | public object set_SaveEntrustOutBill_Json([FromBody] JObject oMain) |
| | | { |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | try |
| | | { |
| | | List<Model.ClsKf_EntrustInBillMain> lsmain = new List<Model.ClsKf_EntrustInBillMain>(); |
| | | ListModels oListModels = new ListModels(); |
| | | lsmain = oListModels.getEntrustInBillMainByJson(msg1); |
| | | lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | lsmain[0].HBillType = "1211"; |
| | | |
| | | WebAPI.WebS.ClsKf_EntrustInBillMain websLsmain = new WebS.ClsKf_EntrustInBillMain(); |
| | | |
| | | websLsmain.HInterID = lsmain[0].HInterID; |
| | | websLsmain.HInnerBillNo = ""; |
| | | websLsmain.HDate = lsmain[0].HDate; |
| | | websLsmain.HBillNo = lsmain[0].HBillNo; |
| | | websLsmain.HBillType = lsmain[0].HBillType; |
| | | websLsmain.HBillerID = DBUtility.ClsPub.isLong(DBUtility.ClsPub.CurUserID); |
| | | websLsmain.HDeptID = lsmain[0].HDeptID; |
| | | websLsmain.HEmpID = lsmain[0].HEmpID; |
| | | websLsmain.HRemark = ""; |
| | | websLsmain.HRedBlueFlag = lsmain[0].HRedBlueFlag; |
| | | websLsmain.HMaker = lsmain[0].HMaker; |
| | | websLsmain.HSupID = lsmain[0].HSupID; |
| | | websLsmain.HSecManagerID = lsmain[0].HSecManagerID; |
| | | websLsmain.HSCWHID = lsmain[0].HSCWHID; |
| | | websLsmain.HKeeperID = lsmain[0].HKeeperID; |
| | | websLsmain.HMainSourceBillType = "1604"; |
| | | websLsmain.HMangerID = lsmain[0].HMangerID; |
| | | websLsmain.HWHID = lsmain[0].HWHID; |
| | | websLsmain.HExplanation = lsmain[0].HExplanation; |
| | | |
| | | string sSourceBillType = "1604"; |
| | | |
| | | if (webserver.set_SaveEntrustInBill_New(websLsmain, sSourceBillType, ref DBUtility.ClsPub.sErrInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "çæå§å¤åºåºåæåï¼åæ®å·ä¸ºï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¸ä¼ 失败ï¼" + DBUtility.ClsPub.sErrInfo; |
| | | objJsonResult.data = websLsmain; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¸ä¼ 失败ï¼å¼å¸¸" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å§å¤åºåº æ«ææºåï¼å°æºåä¿¡æ¯åå
¥æ¡ç 临æ¶è¡¨ |
| | | /// </summary> |
| | | /// <param name="HSourceBillNo"></param> |
| | | /// <returns></returns> |
| | | [Route("Kf_EntrustInBill/GetWW_PPBomBillMainByHSourceBillNo")] |
| | | [HttpGet] |
| | | public object GetWW_PPBomBillMainByHSourceBillNo(string HSourceBillType, string HSourceBillNo, Int64 sInterID, string sBillNo) |
| | | { |
| | | try |
| | | { |
| | | string sWhere = " Where åæ®å· like '%" + HSourceBillNo.Trim() + "%'"; |
| | | if (HSourceBillType == "1604") |
| | | { |
| | | ds = oCn.RunProcReturn("Select HBillNo,HSupID,s.HName HSupName from WW_PPBomBillMain a left join Gy_Supplier s on a.HSupID=s.HItemID Where HBillNo='" + HSourceBillNo+"'", "WW_PPBomBillMain"); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½,æºåç±»åæé误ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); |
| | | } |
| | | else |
| | | { |
| | | if (webserver.set_SavePonderationBillMain_Temp_Source_Fast(sInterID, sBillNo, "1211", HSourceBillNo, HSourceBillType, "èå", ref DBUtility.ClsPub.sErrInfo)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è¿åè®°å½æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åå
¥ä¸´æ¶è¡¨å¤±è´¥ï¼" + DBUtility.ClsPub.sErrInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿åä»»ä½è®°å½ï¼" + ex.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | } |
| | | } |