Esempio n. 1
0
 public bool DeleteData(string TableName, string Step, string DeleteCond)
 {
     try
     {
         string[] CondList;
         if (DeleteCond != null)
         {
             CondList = FwxCmnFunction.UnPackCondition(DeleteCond);
         }
         else
         {
             CondList = null;
         }
         switch (TableName)
         {
         //case "RWEBFUNDEF":
         //    if (Step == "1")
         //    {
         //        dt = SvrGlobalVariable.DBQuery.GetFuncDataTable("SEL_0CFUNCNAME", null, new string[] { CondList[0] });
         //    }
         //    break;
         default:
             return(oStdMain.DeleteData(TableName, Step, DeleteCond));
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 2
0
        public string GetFuncDataString(string FunctionName, string QueryCond)
        {
            try
            {
                string   sData = "";
                string[] CondList;
                if (QueryCond != null)
                {
                    CondList = FwxCmnFunction.UnPackCondition(QueryCond);
                }
                else
                {
                    CondList = null;
                }
                switch (FunctionName)
                {
                default:
                    return(oStdMain.GetFuncDataString(FunctionName, QueryCond));
                }

                return(sData);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 3
0
        public string GetFuncDataString(string FunctionName, string QueryCond)
        {
            try
            {
                string   sData = "";
                string[] CondList;
                if (QueryCond != null)
                {
                    CondList = FwxCmnFunction.UnPackCondition(QueryCond);
                }
                else
                {
                    CondList = null;
                }
                switch (FunctionName)
                {
                case "GetSysTime":
                    sData = oStdFunction.GetSysDate();
                    break;
                }

                return(sData);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 4
0
        public string GetFuncDataTable(string FunctionName, string QueryCond)
        {
            try
            {
                DataTable dtRet = null;
                string    sRet;
                string[]  CondList;
                ArrayList FieldArray = new ArrayList();
                int       i;

                if (QueryCond != null)
                {
                    CondList = FwxCmnFunction.UnPackCondition(QueryCond);
                    for (i = 0; i < CondList.Length; i++)
                    {
                        FieldArray.Add(CondList[i]);
                    }
                }
                else
                {
                    CondList = null;
                }

                Object[] oPara = new Object[1];
                oPara[0] = FieldArray;

                Type       FunctionType = oStdFunc.GetType();
                MethodInfo mi           = FunctionType.GetMethod(FunctionName);
                if (mi != null)
                {
                    dtRet = (DataTable)mi.Invoke(oStdFunc, oPara);
                }
                else
                {
                    dtRet = oStdMain.GetFuncDataTable(FunctionName, QueryCond);
                }

                sRet = StandardFunction.GetErrorMessage() + FwxCmnFunction.DataTableToString(dtRet);

                return(sRet);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 5
0
        public bool DeleteData(string TableName, string Step, string DeleteCond)
        {
            try
            {
                string[] CondList;
                if (DeleteCond != null)
                {
                    CondList = FwxCmnFunction.UnPackCondition(DeleteCond);
                }
                else
                {
                    CondList = null;
                }

                return(oTableDelete.DeleteData(TableName, Step, CondList));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 6
0
        public bool InsertData(string TableName, string Step, string QueryCond)
        {
            try
            {
                string[] CondList;
                if (QueryCond != null)
                {
                    CondList = FwxCmnFunction.UnPackCondition(QueryCond);
                }
                else
                {
                    CondList = null;
                }

                return(oTableInsert.InsertData(TableName, Step, CondList));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 7
0
        public int SelectDataCount(string TableName, string Step, string QueryCond)
        {
            try
            {
                string[] CondList;
                if (QueryCond != null)
                {
                    CondList = FwxCmnFunction.UnPackCondition(QueryCond);
                }
                else
                {
                    CondList = null;
                }

                return(oTableSelectCount.SelectDataCount(TableName, Step, CondList));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 8
0
        public DataTable FillData(string TableName, string Step, string QueryCond)
        {
            try
            {
                DataTable dtRet = null;
                string[]  CondList;
                if (QueryCond != null)
                {
                    CondList = FwxCmnFunction.UnPackCondition(QueryCond);
                }
                else
                {
                    CondList = null;
                }

                dtRet = oTableFill.FillData(TableName, Step, CondList);
                return(dtRet);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 9
0
        public string FillData(string TableName, string Step, string QueryCond)
        {
            try
            {
                DataTable dtRet = null;
                string    sRet  = "";
                string[]  CondList;
                if (QueryCond != null)
                {
                    CondList = FwxCmnFunction.UnPackCondition(QueryCond);
                }
                else
                {
                    CondList = null;
                }
                switch (TableName)
                {
                //case "RWEBFUNDEF":
                //    if (Step == "1")
                //    {
                //        dt = SvrGlobalVariable.DBQuery.GetFuncDataTable("SEL_0CFUNCNAME", null, new string[] { CondList[0] });
                //    }
                //    break;
                default:
                    dtRet = oStdMain.FillData(TableName, Step, QueryCond);
                    break;
                }
                sRet = StandardFunction.GetErrorMessage() + FwxCmnFunction.DataTableToString(dtRet);

                return(sRet);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }