Esempio n. 1
0
        ////''' <summary>
        ////''' 显示DataDic窗体,并把选择结果返回到spreadObj控件
        ////''' </summary>
        ////''' <param name="spreadObj"></param>
        ////''' <param name="rControl">保存返回值的控件集合</param>
        ////''' <param name="fControl">每一个控件对应的字段名称</param>
        ////''' <param name="sQuery">查询语句</param>
        ////''' <param name="sProcName">存储过程名称</param>
        ////''' <param name="sFilter">筛选条件(存储过程时不需要)</param>
        ////''' <param name="iActiveColumn">DataDic窗体Where条件Spread默认活动列</param>
        ////''' <returns></returns>
        ////''' <remarks></remarks>
        public static void Gf_Spread_DD(Control spreadObj, Collection rControl, Collection fControl, string sQuery, string sProcName, int iParaCount, string sFilter, int iActiveColumn)
        {
            DataDic dd = new DataDic();

            dd.IsSpreadCaller    = true;
            dd.SpreadObj         = spreadObj;
            dd.rControl          = rControl;
            dd.fControl          = fControl;
            dd.QuerySQL          = sQuery.ToUpper();
            dd.ProcName          = sProcName;
            dd.ParamCount        = iParaCount;
            dd.sFilter           = sFilter;
            dd.ActiveColumnIndex = iActiveColumn;
            //dd.ShowDialog();
            //dd.Show();
            dd.ShowDialog();//20121231
        }
Esempio n. 2
0
        ////     ''' <summary>
        ////''' 显示DataDic窗体,并把选择结果返回到非Spread的控件
        ////''' </summary>
        ////''' <param name="rControl">保存返回值的控件集合</param>
        ////''' <param name="fControl">每一个控件对应的字段名称</param>
        ////''' <param name="sQuery">查询语句</param>
        ////''' <param name="sProcName">存储过程名称</param>
        ////''' <param name="sFilter">筛选条件(存储过程时不需要)</param>
        ////''' <param name="iActiveColumn">DataDic窗体Where条件Spread默认活动列</param>
        ////''' <returns></returns>
        ////''' <remarks></remarks>
        public static void Gf_Master_DD(Collection rControl, Collection fControl, string sQuery, string sProcName, int iParaCount, string sFilter, int iActiveColumn)
        {
            DataDic dd = new DataDic();

            //dd.ShowDialog();
            //return;
            dd.IsSpreadCaller    = false;
            dd.rControl          = rControl;
            dd.fControl          = fControl;
            dd.QuerySQL          = sQuery.ToUpper();
            dd.ProcName          = sProcName;
            dd.ParamCount        = iParaCount;
            dd.sFilter           = sFilter;
            dd.ActiveColumnIndex = iActiveColumn;
            try
            {
                // dd.Show();
                dd.ShowDialog();//20121231
            }
            catch { }
        }
Esempio n. 3
0
        //---------------------------------------------------------------------------------------
        //  1.ID           : Gf_DD_Display
        //  2.Input  Value : Conn Connection, sQuery String, [MsgChk Boolean]
        //  3.Return Value : Boolean
        //  4.Create Date  :
        //  5.Modify Date  :
        //  6.Comment      : Data Dictionary Result Data Display
        //---------------------------------------------------------------------------------------
        public static bool Gf_DD_Display(System.Data.OleDb.OleDbConnection Conn, string sQuery, bool MsgChk)
        {
            bool    functionReturnValue = false;
            DataDic DataDic             = new DataDic();
            int     iCollCnt            = 0;
            int     iColcount           = 0;

            if (Conn.State == 0)
            {
                if (GeneralCommon.GF_DbConnect() == false)
                {
                    functionReturnValue = false;
                    GeneralCommon.Gp_DD_Clear();
                    int rCount = GeneralCommon.rControl.Count;

                    for (iCollCnt = 0; iCollCnt < rCount; iCollCnt++)
                    {
                        GeneralCommon.rControl.Remove(0);
                    }

                    GeneralCommon.DD.sPname = "";
                    return(functionReturnValue);
                }
            }

            System.Data.DataSet DS = new System.Data.DataSet();

            try
            {
                System.Data.OleDb.OleDbDataAdapter OleDA = new System.Data.OleDb.OleDbDataAdapter(sQuery, Conn);
                OleDA.Fill(DS);

                if (DS.Tables[0].Rows.Count == 0)
                {
                    if (MsgChk)
                    {
                        GeneralCommon.Gp_MsgBoxDisplay("无法找到该资料...!!!", "I");
                    }

                    DataDic.ssResult.Cols.Count = DS.Tables[0].Columns.Count;
                    DataDic.ssWhere.Cols.Count  = DS.Tables[0].Columns.Count;
                    //DataDic.ssResult.Sheets[0].ColumnCount = DS.Tables[0].Columns.Count;// AdoRs.Fields.Count;
                    //DataDic.ssWhere.Sheets[0].ColumnCount = DS.Tables[0].Columns.Count;//AdoRs.Fields.Count;

                    DataDic.ssResult.Rows.Count = 0;
                    DataDic.ssWhere.Rows.Count  = 1;
                    //DataDic.ssResult.Sheets[0].RowCount = 0;
                    //DataDic.ssWhere.Sheets[0].RowCount = 1;

                    DataDic.ssResult.DataSource = DS;
                    DataDic.ssWhere_setting();
                    //DataDic.ssResult.DataSource = DS;
                    //DataDic.ssWhere_setting();

                    for (iColcount = 0; iColcount < DataDic.ssResult.Cols.Count; iColcount++)
                    {
                        DataDic.ssResult.Cols.MinSize = 80;
                        DataDic.ssWhere.Cols.MinSize  = 80;
                        DataDic.ssResult.AllowEditing = false;

                        if (GeneralCommon.DD.DataDicType == "E")
                        {
                            DataDic.ssWhere[0, iColcount] = GeneralCommon.rControl[iColcount].ToString();
                        }
                    }

                    if (GeneralCommon.DD.DicRefType == "C")
                    {
                        DataDic.ShowDialog();
                    }

                    functionReturnValue = false;
                    return(functionReturnValue);
                }

                Cursor.Current      = Cursors.WaitCursor;
                functionReturnValue = true;
                //DataDic.ssResult.Cols.Count = DS.Tables[0].Columns.Count;
                DataDic.ssWhere.Cols.Count = DS.Tables[0].Columns.Count + 1;
                // DataDic.ssWhere.Cols[0].Width = 80;
                // DataDic.ssResult.Rows.Count = 1;
                DataDic.ssWhere.Rows.Count  = 2;
                DataDic.ssResult.DataSource = DS.Tables[0];
                DataDic.ssResult.Cols.Count = DS.Tables[0].Columns.Count + 1;
                DataDic.ssWhere_setting();

                for (iColcount = 0; iColcount < DataDic.ssResult.Cols.Count - 1; iColcount++)
                {
                    DataDic.ssWhere.Cols[iColcount + 1].Caption = DS.Tables[0].Columns[iColcount].ColumnName;
                    DataDic.ssResult.Cols[iColcount].Width      = 80;
                    DataDic.ssWhere.Cols[iColcount + 1].Width   = 80;

                    DataDic.ssResult.Cols[iColcount].AllowEditing = false;

                    if (GeneralCommon.DD.DataDicType == "E")
                    {
                        DataDic.ssWhere.Cols[iColcount].Caption = GeneralCommon.rControl[iColcount].ToString();
                    }
                }

                Cursor.Current = Cursors.Default;

                if (GeneralCommon.DD.DicRefType == "C")
                {
                    DataDic.ShowDialog();
                }
            }
            catch (Exception ex)
            {
                functionReturnValue = false;
                GeneralCommon.Gp_DD_Clear();
                GeneralCommon.rControl.RemoveRange(0, GeneralCommon.rControl.Count);
                GeneralCommon.DD.sPname = "";
                functionReturnValue     = false;
                GeneralCommon.Gp_MsgBoxDisplay("DD_Display Error : " + ex.Message);
                Cursor.Current = Cursors.Default;
            }

            return(functionReturnValue);
        }