Exemple #1
0
    public string DoA014Query(string a014_id_, string objid_, string table____)
    {
        string sql_ = objid_;

        string[] sqllist   = Regex.Split(objid_, "<V></V>", RegexOptions.IgnoreCase);
        string   e_sqllist = "";

        for (int i = 0; i < sqllist.Length; i++)
        {
            string str_sql = sqllist[i];
            if (str_sql == null || str_sql.Length < 5)
            {
                continue;
            }
            /*获取要处理的sql*/
            try
            {
                string e_sql = "pkg_a.doa014('" + a014_id_ + "','" + table____ + "','" + str_sql + "','" + GlobeAtt.A007_KEY + "',[A311_KEY])";
                e_sqllist += "begin " + e_sql + ";end;";
                e_sql      = Fun.execSql(e_sql, GlobeAtt.A007_KEY, GlobeAtt.A002_KEY, "A014_ID=" + a014_id_);
                if (e_sql != "0")
                {
                    return(e_sql);
                }
            }
            catch (Exception ex)
            {
                return("00" + ex.Message);
            }
        }
        //    public string execSqlList(string sqlxml, string user_id_, string menu_id_,string key_id,string a014_id_)
        Fun.execSqlList(e_sqllist, GlobeAtt.A007_KEY, GlobeAtt.A002_KEY, "[A311_KEY]", a014_id_);
        return("00" + BaseMsg.getMsg("M0018"));;
    }