/// <summary>
        /// 提交查询条件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSumbitFindCondition_Click(object sender, EventArgs e)
        {
            if (panelParameter.Controls.Count == 0)
            {
                MessageDialog.ShowPromptMessage("您还没有建立查询条件无法进行此操作!");
                return;
            }

            m_sentenceSQL = null;

            try
            {
                for (int i = 0; i < panelParameter.Controls.Count; i++)
                {
                    UserControlFindCondition newControl = panelParameter.Controls[i] as UserControlFindCondition;

                    if (i != panelParameter.Controls.Count - 1)
                    {
                        m_sentenceSQL = m_sentenceSQL + newControl.BuildSQLSentence("", false);
                    }
                    else
                    {
                        m_sentenceSQL = m_sentenceSQL + newControl.BuildSQLSentence("", true);
                    }
                }

                this.DialogResult = DialogResult.OK;
                this.Close();
            }
            catch (Exception exce)
            {
                Console.WriteLine(exce.Message);
                return;
            }
        }
示例#2
0
        /// <summary>
        /// 提交并查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnFind_Click(object sender, EventArgs e)
        {
            string m_sentenceSQL = null;

            try
            {
                for (int i = 0; i < panelParameter.Controls.Count; i++)
                {
                    UserControlFindCondition newControl = panelParameter.Controls[i] as UserControlFindCondition;

                    if (i != panelParameter.Controls.Count - 1)
                    {
                        m_sentenceSQL = m_sentenceSQL + newControl.BuildSQLSentence("报表", false);
                    }
                    else
                    {
                        m_sentenceSQL = m_sentenceSQL + newControl.BuildSQLSentence("报表", true);
                    }
                }
            }
            catch (Exception exce)
            {
                Console.WriteLine(exce.Message);
                return;
            }

            if (m_sentenceSQL != null)
            {
                string error = null;
                dataGridView1.DataSource =
                    DataSetHelper.SiftDataTable(m_quertResultTable, m_sentenceSQL, out error);
            }
            else
            {
                dataGridView1.DataSource = m_quertResultTable;
            }

            userControlDataLocalizer1.Init(dataGridView1, this.Name,
                                           UniversalFunction.SelectHideFields(this.Name, dataGridView1.Name, BasicInfo.LoginID));

            dataGridView1.Refresh();
        }
        /// <summary>
        /// 提交并查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnFind_Click(object sender, EventArgs e)
        {
            if (panelParameter.Controls.Count == 0)
            {
                MessageDialog.ShowPromptMessage("您还没有建立查询条件无法进行此操作!");
                return;
            }

            m_sentenceSQL = null;
            string pareTemp = "";

            try
            {
                for (int i = 0; i < panelParameter.Controls.Count; i++)
                {
                    UserControlFindCondition newControl = panelParameter.Controls[i] as UserControlFindCondition;

                    if (i != panelParameter.Controls.Count - 1)
                    {
                        m_sentenceSQL = m_sentenceSQL + newControl.BuildSQLSentence("", false);
                    }
                    else
                    {
                        m_sentenceSQL = m_sentenceSQL + newControl.BuildSQLSentence("", true);

                        if (newControl.FieldName == "单据号")
                        {
                            pareTemp = newControl.DataValue;
                        }
                    }
                }
            }
            catch (Exception exce)
            {
                Console.WriteLine(exce.Message);
                return;
            }

            IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>();
            string         businessID    = "";

            switch (m_findBusiness)
            {
            case "报检入库单":
                businessID = "报检入库单查询";
                break;

            case "普通入库单":
                businessID = "普通入库单查询";
                break;

            case "采购退货单":
                businessID = "采购退货单查询";
                break;

            case "领料单":
                businessID = "领料单查询";
                break;

            case "领料退库单":
                businessID = "领料退库单查询";
                break;

            case "销售退库单":
                businessID = "销售退库单查询";
                break;

            case "销售出库单":
                businessID = "销售出库单查询";
                break;

            case "产品入库单":
                businessID = "产品入库单查询";
                break;

            case "报废单":
                businessID = "报废单查询";
                break;

            case "报废单综合查询":
                businessID = m_findBusiness;
                break;

            case "合同信息管理":
                businessID = "合同信息综合查询";
                break;

            case "订单信息管理":
                businessID = "订单信息综合查询";
                break;

            case "自制件入库单":
                businessID = "自制件入库单查询";
                break;

            case "采购退货单综合查询":
                businessID = m_findBusiness;
                break;

            case "领料单综合查询":
                businessID = m_findBusiness;
                break;

            case "样品确认申请单":
                businessID = "样品确认申请单综合查询";
                break;

            case "不合格品隔离处置单":
                businessID = "不合格品隔离处置单查询";
                break;

            case "挑选返工返修单":
                businessID = "挑选返工返修单查询";
                break;

            case "供应质量信息反馈单":
                businessID = "供应商质量信息反馈单查询";
                break;

            case "委外报检入库单":
                businessID = "委外报检入库单查询";
                break;

            case "产品型号变更单":
                businessID = "产品型号变更单查询";
                break;

            default:
                businessID = m_findBusiness;
                break;
            }

            string sql = m_sentenceSQL.ToLower();

            if (sql.LastIndexOf(" union ") != -1)
            {
                MessageDialog.ShowPromptMessage("存在非法字符,无法进行此操作!");
                return;
            }

            if (businessID == "培训综合统计查询" &&
                (m_sentenceSQL.Contains("培训开始时间") || m_sentenceSQL.Contains("培训终止时间")))
            {
                m_sentenceSQL = m_sentenceSQL + " or 培训开始时间 is null";
            }

            IQueryResult qr = authorization.Query(businessID, null, m_sentenceSQL);

            if (m_findBusiness == "零星采购申请财务综合查询")
            {
                string[] pare = { pareTemp };
                qr = authorization.QueryMultParam(businessID, m_sentenceSQL, pare);
            }

            if (m_findBusiness == "出差综合查询")
            {
                string[] pare = { BasicInfo.DeptCode };
                qr = authorization.QueryMultParam(businessID, m_sentenceSQL, pare);
            }

            if (m_findBusiness == "出差人员查看")
            {
                string[] pare = { BasicInfo.LoginID };
                qr = authorization.QueryMultParam(businessID, m_sentenceSQL, pare);
            }

            if (m_findBusiness == "订单入库单综合查询")
            {
                qr = authorization.QueryMultParam(businessID, m_sentenceSQL, m_proParameter);
            }

            if (!qr.Succeeded)
            {
                m_quertResultTable = null;
                MessageDialog.ShowErrorMessage(qr.Error);
            }
            else
            {
                m_quertResultTable = qr.DataCollection.Tables[0];
                lblAmount.Text     = m_quertResultTable.Rows.Count.ToString();
            }

            dataGridView1.DataSource = m_quertResultTable;

            for (int i = 0; i < dataGridView1.Columns.Count; i++)
            {
                if (dataGridView1.Columns[i].Name.Contains("标志") || dataGridView1.Columns[i].Name.Contains("领料类型") ||
                    dataGridView1.Columns[i].Name.Contains("人编码") || //dataGridView1.Columns[i].Name.Contains("签名")  ||
                    dataGridView1.Columns[i].Name.Contains("权限控制") || dataGridView1.Columns[i].Name.Contains("序号"))
                {
                    dataGridView1.Columns[i].Visible = false;
                }
            }

            #region 隐藏不允许查看的列

            if (qr.HideFields != null && qr.HideFields.Length > 0)
            {
                for (int i = 0; i < dataGridView1.Columns.Count; i++)
                {
                    if (qr.HideFields.Contains(dataGridView1.Columns[i].Name))
                    {
                        dataGridView1.Columns[i].Visible = false;
                    }
                }
            }

            #endregion

            if (!BasicInfo.ListRoles.Contains(CE_RoleEnum.采购账务管理员.ToString()) &&
                !BasicInfo.ListRoles.Contains(CE_RoleEnum.会计.ToString()))
            {
                for (int i = 0; i < dataGridView1.Columns.Count; i++)
                {
                    if (dataGridView1.Columns[i].Name.Contains("单价") || dataGridView1.Columns[i].Name.Contains("金额"))
                    {
                        dataGridView1.Columns[i].Visible = false;
                    }
                }
            }

            dataGridView1.Refresh();
        }
        /// <summary>
        /// 测试过滤条件
        /// </summary>
        /// <returns>成功返回true</returns>
        private bool TestFilterCondition()
        {
            int leftParentheses  = 0;
            int rightParentheses = 0;

            m_sentenceSQL = "";

            try
            {
                for (int i = 0; i < panelParameter.Controls.Count; i++)
                {
                    UserControlFindCondition control = panelParameter.Controls[i] as UserControlFindCondition;

                    leftParentheses  += control.LeftParentheses.Length == 0 ? 0 : 1;
                    rightParentheses += control.RightParentheses.Length == 0 ? 0 : 1;

                    if (i != panelParameter.Controls.Count - 1)
                    {
                        m_sentenceSQL = m_sentenceSQL + control.BuildSQLSentence("", false);
                    }
                    else
                    {
                        m_sentenceSQL = m_sentenceSQL + control.BuildSQLSentence("", true);
                    }
                }

                if (leftParentheses != rightParentheses)
                {
                    MessageDialog.ShowPromptMessage("左右括号数量不匹配");
                    return(false);
                }
            }
            catch (Exception exce)
            {
                Console.WriteLine(exce.Message);
                return(false);
            }

            IAuthorization authorization = PlatformFactory.GetObject <IAuthorization>();
            string         businessID    = "";

            switch (m_findBusiness)
            {
            case "报检入库单":
                businessID = "报检入库单查询";
                break;

            case "普通入库单":
                businessID = "普通入库单查询";
                break;

            case "采购退货单":
                businessID = "采购退货单查询";
                break;

            case "领料单":
                businessID = "领料单查询";
                break;

            case "领料退库单":
                businessID = "领料退库单查询";
                break;

            case "销售退库单":
                businessID = "销售退库单查询";
                break;

            case "销售出库单":
                businessID = "销售出库单查询";
                break;

            case "产品入库单":
                businessID = "产品入库单查询";
                break;

            case "还货单":
                businessID = "还货单查询";
                break;

            case "借货单":
                businessID = "借货单查询";
                break;

            case "报废单":
                businessID = "报废单查询";
                break;

            case "合同信息管理":
                businessID = "合同信息综合查询";
                break;

            case "订单信息管理":
                businessID = "订单信息综合查询";
                break;

            case "自制件入库单":
                businessID = "自制件入库单查询";
                break;

            case "产品型号变更单":
                businessID = "产品型号变更单查询";
                break;
            }

            m_queryResult = authorization.Query(businessID, null, m_sentenceSQL);

            if (!m_queryResult.Succeeded)
            {
                MessageDialog.ShowErrorMessage(m_queryResult.Error);
                return(false);
            }
            else
            {
                return(true);
            }
        }