Exemplo n.º 1
0
        private void btnMoreCondition_Click(object sender, EventArgs e)
        {
            string           condition = txtPNumber.Text.Trim() + "," + dtStDay.EditValue.ToString() + "," + dtEndDay.EditValue.ToString() + ",";
            frmMoreCondition frmMore   = new frmMoreCondition(condition);

            if (frmMore.ShowDialog() == DialogResult.OK)
            {
                if (cbk == null)
                {
                    cbk = new GridCheckMarksSelection(gridView1);
                }
                this.gridControl1.DataSource = frmMore.dtCondition.Tables[0];
            }
        }
Exemplo n.º 2
0
        //查询
        private void btnOk_Click(object sender, EventArgs e)
        {
            if (cboUnitFee.Text.Trim() == string.Empty)
            {
                MessageBox.Show("为了避免误操作,请选择工费计算方式!");
                return;
            }
            cbk = null;
            string COL_SQL      = string.Empty;
            string COL_SQL_Null = string.Empty;
            string COL_SQL_Max  = string.Empty;

            string[] strAry = this.chkComCust.Text.Split(',');
            for (int i = 0; i < strAry.Length; i++)
            {
                COL_SQL      = COL_SQL + "[" + strAry[i].ToString().Trim() + "],";
                COL_SQL_Null = COL_SQL_Null + "[" + strAry[i].ToString().Trim() + "]= ISNULL(" + "[" + strAry[i].ToString().Trim() + "],0),";
                COL_SQL_Max  = COL_SQL_Max + "[" + strAry[i].ToString().Trim() + "]= Max(" + strAry[i].ToString().Trim() + "),";
            }
            string[] strKey = "EUser_Id,EDept_Id,Fy_Id,COL_SQL_NULL,COL_SQL,COL_SQL_Max,PNumber,UnitType,Flag".Split(",".ToCharArray());
            string[] strVal = new string[] {
                CApplication.App.CurrentSession.UserId.ToString(),
                     CApplication.App.CurrentSession.DeptId.ToString(),
                     CApplication.App.CurrentSession.FyId.ToString(),
                     COL_SQL_Null.TrimEnd(','),
                COL_SQL.TrimEnd(','),
                COL_SQL_Max.TrimEnd(','),
                txtPNumber.Text.Trim(),
                cboUnitFee.Text.Trim(),
                "3"
            };
            DataSet ds = this.DataRequest_By_DataSet(strSpName, strKey, strVal);

            this.gridVMain.Columns.Clear();
            this.gridCMain.DataSource = ds.Tables[0];
            if (cbk == null)
            {
                cbk = new GridCheckMarksSelection(gridVMain);
            }
            this.gridVMain.Columns[0].Visible = false;
            if (cboUnitFee.Text.Trim() == "按件计")
            {
                this.gridVMain.Columns[3].Visible = false;
            }
            else
            {
                this.gridVMain.Columns[4].Visible = false;
            }
        }
Exemplo n.º 3
0
        private void InitContr()
        {
            if (dsLoad != null)
            {
                return;
            }

            dsFormAdt = this.GetFrmLoadDsAdt(strBusClassName);
            dsFormAdt.AcceptChanges();
            dsLoad = this.GetFrmLoadDsNew(strBusClassName);
            dsLoad.AcceptChanges();
            dtShow  = dsLoad.Tables[0];
            dtConst = dsLoad.Tables[1];

            drMain    = dsLoad.Tables[2].Rows[0];
            strSpName = drMain["SpName"].ToString();

            dtBtns   = dsLoad.Tables[3];
            dtTabs   = dsLoad.Tables[4];
            dtGroupC = dsLoad.Tables[5];
            dtSte    = dsLoad.Tables[6];
            dtContr  = dsLoad.Tables[7];
            dtBtnsM  = dsLoad.Tables[8];
            dtSp     = dsLoad.Tables[9];

            blInitBound = true;
            Rectangle rect = SystemInformation.VirtualScreen;

            lisBarItems = StaticFunctions.ShowBarButtonItem(dtBtns, bar2, "bar2", strAllowList, imageList1);
            foreach (BarButtonItem item in lisBarItems)
            {
                item.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.btn_ItemClick);
            }
            gcItems = StaticFunctions.ShowTabItem(dtTabs, dtBtns, xtabItemInfo, "xtabItemInfo", strAllowList, lisrepImg, GvNeedGCEdit, lisBtnAlls, lisBtns, imageList1, true, lisGcQuerys);

            foreach (string strGv in gcItems.Keys)
            {
                StaticFunctions.ShowGridControl(gcItems[strGv], dtShow, dtConst);

                DataRow[] drTabs = dtTabs.Select("IsAddChildGv=1 AND GridViewName='" + strGv + "'");
                if (drTabs.Length == 1)
                {
                    GridView gvChild = StaticFunctions.ShowGridVChildGv(strGv + "Com", gcItems[strGv].GridControl, dtShow, dtConst);
                    StaticFunctions.SetGridViewStyleFormatCondition(gvChild, dtBtnsM);
                }
                StaticFunctions.SetGridViewStyleFormatCondition(gcItems[strGv], dtBtnsM);
                drTabs = dtTabs.Select("ShowGridChkSel=1 AND GridViewName='" + strGv + "'");
                if (drTabs.Length == 1)
                {
                    GridCheckMarksSelection gc = new GridCheckMarksSelection(gcItems[strGv]);
                    gc.StrGridKeyField = drTabs[0]["EditInfoKeyId"].ToString();
                    gcGridCheckSels.Add(strGv, gc);
                }
            }
            foreach (RepositoryItemImageEdit rep in lisrepImg)
            {
                rep.Popup += new System.EventHandler(this.repImg_Popup);
            }
            #region gcQuery
            int igcHeight;
            foreach (Control ctrlQuery in lisGcQuerys.Values)
            {
                List <Control> lisGcContrsQuery = StaticFunctions.ShowGroupControl(ctrlQuery, rect.Width - 50, dtShow, dtConst, true, 30, false, null, true, out igcHeight);
                foreach (Control ctrl in lisGcContrsQuery)
                {
                    ctrl.Enter += new System.EventHandler(this.TxtQ_Enter);
                    switch (ctrl.GetType().ToString())
                    {
                    case "DevExpress.XtraEditors.TextEdit":
                        break;

                    case "DevExpress.XtraEditors.CheckEdit":
                        break;

                    case "DevExpress.XtraEditors.LookUpEdit":
                        LookUpEdit dpl = ctrl as LookUpEdit;
                        dpl.Properties.QueryPopUp += new System.ComponentModel.CancelEventHandler(this.lookUpEdit_Properties_QueryPopUp);
                        dpl.Properties.Closed     += new DevExpress.XtraEditors.Controls.ClosedEventHandler(this.lookUpEdit_Properties_Closed);
                        break;

                    case "DevExpress.XtraEditors.CheckedComboBoxEdit":
                        CheckedComboBoxEdit chkdpl = ctrl as CheckedComboBoxEdit;
                        chkdpl.Properties.Closed += new DevExpress.XtraEditors.Controls.ClosedEventHandler(this.lookUpEdit_Properties_Closed);
                        break;

                    case "DevExpress.XtraEditors.DateEdit":
                        break;

                    case "ProduceManager.UcTxtPopup":
                        ProduceManager.UcTxtPopup ucp = ctrl as ProduceManager.UcTxtPopup;
                        ucp.onClosePopUp += new UcTxtPopup.ClosePopUp(ucp_onClosePopUp);
                        break;

                    default:
                        break;
                    }
                }
            }
            #endregion
            StaticFunctions.SetBtnStyle(barManager1, lisBtnAlls, drMain);

            this.txtOrdFilter.Location = new System.Drawing.Point(int.Parse(drMain["ControlFilterLocalPointX"].ToString()), int.Parse(drMain["ControlFilterLocalPointY"].ToString()));

            foreach (XtraTabPage tap in xtabItemInfo.TabPages)
            {
                if (dtTabs.Select("LoadQuery=1 AND TabName='" + tap.Name + "'").Length > 0)
                {
                    Query(tap.Name);
                }
            }
            blInitBound = false;
        }