Ejemplo n.º 1
0
        protected override void ExecItemSearch()
        {
            List <string>      FieldText = new List <string>();
            List <string>      FieldName = new List <string>();
            List <GRFieldType> FieldType = new List <GRFieldType>();
            string             s         = "";

            for (int i = ReportStartIndex; i <= Report.DetailGrid.Columns.Count; i++)
            {
                if (!Report.DetailGrid.Columns[i].TitleCell.FreeCell)
                {
                    s = Report.DetailGrid.Columns[i].TitleCell.Text;
                    if (Report.DetailGrid.Columns[i].TitleCell.SupCell != null)
                    {
                        s = Report.DetailGrid.Columns[i].TitleCell.SupCell.Text + s;
                    }
                    FieldText.Add(s);
                    s = Report.DetailGrid.Columns[i].ContentCell.DataField;
                    FieldName.Add(s);
                    FieldType.Add(Report.FieldByName(s).FieldType);
                }
            }
            frmPubFind frm = new frmPubFind(this.Text + "[" + CurrentTool + "]", FindSQL, FindOrderBy,
                                            FindKeyWord, FieldText, FieldName, FieldType, FindShowTime);

            if (frm.ShowDialog() == DialogResult.OK)
            {
                QuerySQL = frm.QuerySQL;
                ExecItemRefresh();
            }
        }
Ejemplo n.º 2
0
        private void ItemSearch_Click(object sender, EventArgs e)
        {
            List <string>      FieldText = new List <string>();
            List <string>      FieldName = new List <string>();
            List <GRFieldType> FieldType = new List <GRFieldType>();

            FieldName.Add("CardStatusName");
            FieldName.Add("CardTypeName");
            FieldName.Add("EmpNo");
            FieldName.Add("EmpName");
            FieldName.Add("DepartID");
            FieldName.Add("DepartName");
            for (int i = 0; i < FieldName.Count; i++)
            {
                FieldText.Add(Pub.GetResText(formCode, FieldName[i], ""));
                FieldType.Add(GRFieldType.grftString);
            }
            frmPubFind frm = new frmPubFind(this.Text + "[" + ItemSearch.Text + "]", OriginSQL,
                                            Pub.GetSQL(DBCode.DB_001003, new string[] { "302" }), formCode, FieldText, FieldName, FieldType, false);

            if (frm.ShowDialog() == DialogResult.OK)
            {
                QuerySQL = frm.QuerySQL;
                LoadData();
            }
        }
Ejemplo n.º 3
0
        protected override void ExecItemSearch()
        {
            List <string>      FieldText   = new List <string>();
            List <string>      FieldName   = new List <string>();
            List <GRFieldType> FieldType   = new List <GRFieldType>();
            string             s           = "";
            string             FindKeyWord = formCode;

            if (tabControl1.SelectedIndex == 0)
            {
                for (int i = 1; i <= Report.DetailGrid.Columns.Count; i++)
                {
                    if (Report.DetailGrid.Columns[i].TitleCell.FreeCell)
                    {
                        continue;
                    }
                    s = Report.DetailGrid.Columns[i].TitleCell.Text;
                    if (Report.DetailGrid.Columns[i].TitleCell.SupCell != null)
                    {
                        s = Report.DetailGrid.Columns[i].TitleCell.SupCell.Text + s;
                    }
                    FieldText.Add(s);
                    s = Report.DetailGrid.Columns[i].ContentCell.DataField;
                    FieldName.Add(s);
                    FieldType.Add(Report.FieldByName(s).FieldType);
                }
                frmPubFind frm = new frmPubFind(this.Text + "[" + CurrentTool + "]", FindSQL, FindOrderBy,
                                                FindKeyWord, FieldText, FieldName, FieldType, false);
                if (frm.ShowDialog() == DialogResult.OK)
                {
                    QuerySQL = frm.QuerySQL;
                    ExecItemRefresh();
                }
            }
            else
            {
                FindKeyWord += "History";
                for (int i = 1; i <= Report1.DetailGrid.Columns.Count - 1; i++)
                {
                    if (Report1.DetailGrid.Columns[i].TitleCell.FreeCell)
                    {
                        continue;
                    }
                    s = Report1.DetailGrid.Columns[i].TitleCell.Text;
                    if (Report1.DetailGrid.Columns[i].TitleCell.SupCell != null)
                    {
                        s = Report1.DetailGrid.Columns[i].TitleCell.SupCell.Text + s;
                    }
                    FieldText.Add(s);
                    s = Report1.DetailGrid.Columns[i].ContentCell.DataField;
                    FieldName.Add(s);
                    FieldType.Add(Report1.FieldByName(s).FieldType);
                }
                frmPubFind frm = new frmPubFind(this.Text + "[" + CurrentTool + "]", FindSQL1, FindOrderBy,
                                                FindKeyWord, FieldText, FieldName, FieldType, false);
                if (frm.ShowDialog() == DialogResult.OK)
                {
                    QuerySQL1 = frm.QuerySQL;
                    ExecItemRefresh();
                }
            }
        }