C# Dbconn.GetDataSetBySP方法代码示例

        public DataSet GetData()
        {
            string strxm = "";
            string strfromId = "";
            string strtoid = "";

            try
            {
                if (m_request != null && m_request.Tables.Count > 0)
                {
                    strxm = m_request.Tables[0].Rows[0]["xm"].ToString();
                    strfromId = m_request.Tables[0].Rows[0]["fromId"].ToString();
                    strtoid = m_request.Tables[0].Rows[0]["toid"].ToString();
                }

                if (strxm == "" || strfromId == "" ||strtoid == "")
                {
                    throw new Exception("参数为空");
                }

                string[] strParam = new string[3];
                string[] strValue = new string[3];
                strParam[0] = "@xm";
                strParam[1] = "@fromId";
                strParam[2] = "@toid";

                strValue[0] = strxm;
                strValue[1] = strfromId;
                strValue[2] = strtoid;

                Dbconn conn = new Dbconn("DpPrint_ESB");
                DataSet ds = conn.GetDataSetBySP("printsku_DL20150117", strParam, strValue);

                ArrayList columnList = new ArrayList();
                columnList.Add("SKUID");
                columnList.Add("ID0");
                columnList.Add("ID");
                columnList.Add("SEQ");
                columnList.Add("SKU");

                for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
                {
                    if(! columnList.Contains(ds.Tables[0].Columns[i].ColumnName.ToUpper()))
                    {
                        ds.Tables[0].Columns.Remove(ds.Tables[0].Columns[i].ColumnName);
                        i--;
                    }
                }
                return ds;
            }
            catch
            {
                throw;
            }
        }

        /// <summary>
        /// 编辑用户信息
        /// </summary>
        /// <returns></returns>
        public bool Execute()
        {
            Dbconn conn = new Dbconn("MDM_Master");
            Dbconn conn_Market = new Dbconn("MDM_Market");

            try
            {
                string strexpression_id = m_request.Tables[0].Rows[0]["expression_id"].ToString();
                string strbody_id = m_request.Tables[0].Rows[0]["body_id"].ToString();
                string struser_login_name = m_request.Tables[0].Rows[0]["user_login_name"].ToString();
                string struser_name = m_request.Tables[0].Rows[0]["user_name"].ToString();
                string struser_notuse = m_request.Tables[0].Rows[0]["user_notuse"].ToString();
                string strAction = m_request.Tables[0].Rows[0]["Action"].ToString();
               
                DataSet ds = conn_Market.GetDataSet(@"SELECT [Body_ID]  FROM [MKT_User_CN_For_HZY_F22] WHERE 
                [email protected]",new string[1]{struser_login_name});


                //如果是添加，先核对用户ID对不对
                if (strAction == "Add" && ds.Tables[0].Rows.Count>0)
                {
                    throw new Exception("要添加的用户登录名已经存在，请核对");
                }

                if (strAction == "Add")
                {
                    strbody_id = conn.GetDataTable("SELECT NEWID() as ID", new string[0]).Rows[0][0].ToString();

                    conn.GetDataSetBySP("SP_CreateMasterData", new string[2] { "@MDMName", "@bodyID" }, new string[2] { "User", strbody_id });

                    AddNewRow(conn, strbody_id, struser_name, struser_login_name, struser_notuse);
                }
                else
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        strbody_id = ds.Tables[0].Rows[i]["Body_ID"].ToString();
                        AddNewRow(conn, strbody_id, struser_name, struser_login_name, struser_notuse);
                    }
                }
                return true;
            }
            catch
            {
                
                throw;
            }



        }

        public DataSet GetData()
        {
            string strdt1 = "";
            string strdt2 = "";
            string strpp = "";
            string strlx = "";

            try
            {
                if (m_request != null && m_request.Tables.Count > 0)
                {
                    strdt1 = m_request.Tables[0].Rows[0]["datetimemin"].ToString();
                    strdt2 = m_request.Tables[0].Rows[0]["datetimemax"].ToString();
                    strpp = m_request.Tables[0].Rows[0]["brand"].ToString();
                    strlx = m_request.Tables[0].Rows[0]["season"].ToString();
                }

                if (strdt1 == "" || strdt2 == "" || strpp == "")
                {
                    throw new Exception("参数为空");
                }

                string[] strParam = new string[4];
                string[] strValue = new string[4];
                strParam[0] = "@DT1";
                strParam[1] = "@DT2";
                strParam[2] = "@PP";
                strParam[3] = "@LB";

                strValue[0] = strdt1;
                strValue[1] = strdt2;
                strValue[2] = strpp;
                strValue[3] = strlx;

                Dbconn conn = new Dbconn("ERP_PROD");
                DataSet ds = conn.GetDataSetBySP("SP_PLM_WHLOCount", strParam, strValue);


                return ds;
            }
            catch
            {
                throw;
            }
        }

        /// <summary>
        /// 根据AML语言执行对应的存储过程并返回结果
        /// </summary>
        /// <returns></returns>
        public DataSet GetData()
        {
            
            try
            {
                strDBConnName = m_request.Tables[0].Rows[0]["DBCfgName"].ToString();
                strSPName = m_request.Tables[0].Rows[0]["SPName"].ToString();
                strInputFormat = m_request.Tables[0].Rows[0]["InputFormat"].ToString().ToUpper();
                strInputFormatSPSupport = m_request.Tables[0].Rows[0]["InputFormatSPSupport"].ToString();
                strOutputContentType = m_request.Tables[0].Rows[0]["OutputContentType"].ToString();
                strConditionStr = m_request.Tables[0].Rows[0]["ConditionStr"].ToString();
            }
            catch (Exception)
            {                
                throw;
            }

            //判断存储过程支持的格式与传入的格式,如果不支持,需要进行转换
            if (strInputFormatSPSupport.IndexOf(strInputFormat) == -1)
            { 
                //XML转成AML
                if (strInputFormat == "XML" && strConditionStr!="")
                {
                    DataSet ds1 = Common.Common.GetDSByExcelXML(strConditionStr);
                    strConditionStr = Common.Common.GetAMLByDs(ds1);
                    strInputFormat = "AML";
                }
                //AML转成XML
                else if (strInputFormat == "AML" && strConditionStr != "")
                {
                    DataSet ds1 = Common.Common.GetDsByAML(strConditionStr);
                    strConditionStr = Common.Common.GetExcelXMLStringByDs(ds1);
                    strInputFormat = "XML";
                }

            }

            Dbconn conn = new Dbconn(strDBConnName);
            DataSet ds = new DataSet();
            ds = conn.GetDataSetBySP(strSPName, new string[4] { "@InputFormat", "@OutputFormat", "@OutputContentType", "@ConditionStr" },
                                     new string[4] { strInputFormat,strOutputFormat,strOutputContentType,strConditionStr});
            return ds;
        }

        /// <summary>
        /// Test
        /// </summary>
        /// <returns></returns>
        public DataSet GetData()
        {
            try
            {

                string strXML = this.m_request.Tables[0].Rows[0]["XML"].ToString();

                ServerMDM_AccountQuery_GetByValues sqlServer = new ServerMDM_AccountQuery_GetByValues();
                string strConn = sqlServer.GetConnectionStr("HZY_DHH", "PROD", "maweiqing", "KIJS7^x");

                Dbconn conn = new Dbconn(strConn,true);

                DataSet ds = conn.GetDataSetBySP("WSXML_W_CLOTH_DHH_NF", new string[1] { "XML" }, new string[1] { strXML });
                return ds;
            }
            catch
            {
                throw;

            }



        }

        /// <summary>
        /// 执行SP_Create_Market_Table_New存储过程
        /// </summary>
        /// <returns></returns>
        public DataSet GetData()
        {
            try
            {

                string strTableName = "GetData";
                string strTableColumns = "";
                string strWhere = "";
                string strMainEntity = "";

                DataSet returnDs = new DataSet();
                if (m_request != null)
                {
                    for (int i = 0; i < m_request.Tables[0].Rows.Count; i++)
                    {
                        strTableColumns = m_request.Tables[0].Rows[i]["Columns"].ToString();
                        strWhere = m_request.Tables[0].Rows[i]["Where"].ToString();
                        strMainEntity = m_request.Tables[i].Rows[0]["MainEntity"].ToString();
                        Dbconn conn = new Dbconn("MDM_Master");

                        string[] strParam;
                        string[] strValue;

                        if (m_request.Tables[0].Columns.Contains("page"))
                        {
                            strValue = new string[8];
                            strParam = new string[8];
                        }
                        else
                        {
                            strValue = new string[5];
                            strParam = new string[5];
                        }

                        strParam[0] = "@TableName";
                        strParam[1] = "@TableColumns";
                        strParam[2] = "@Where";
                        strParam[3] = "@MainEntity";
                        strParam[4] = "@TableType";


                        strValue[0] = strTableName;
                        strValue[1] = strTableColumns;
                        strValue[2] = strWhere;
                        strValue[3] = strMainEntity;
                        strValue[4] = m_TableType;

                        if (m_request.Tables[0].Columns.Contains("page"))
                        {
                            strParam[5] = "@Page";
                            strParam[6] = "@PageRowCount";
                            strParam[7] = "@OrderBy";

                            strValue[5] = m_request.Tables[0].Rows[0]["page"].ToString();
                            strValue[6] = m_request.Tables[0].Rows[0]["PageRowCount"].ToString();
                            strValue[7] = m_request.Tables[0].Rows[0]["Order"].ToString();
                        }

                        DataSet ds = new DataSet();

                        ds = conn.GetDataSetBySP("SP_Create_Market_Table_New", strParam, strValue);

                        if (ds.Tables[0].Columns.Contains("STATE"))
                        {
                            throw new Exception("Error:" + ds.Tables[0].Rows[0]["Message"].ToString());
                        }

                        
                        //ds.Tables[0].Columns.Remove("timestamps");
                        //ds.Tables[0].Columns.Remove("rowIndex");

                        returnDs.Tables.Add(ds.Tables[0].Copy());

                        if (ds.Tables.Count > 1)
                        {
                            ds.Tables[1].TableName = "PageRowCount";
                            returnDs.Tables.Add(ds.Tables[1].Copy());
                        }
                    }

                }
                return returnDs;
            }
            catch
            {
                throw;

            }



        }

        /// <summary>
        /// 新建或修改申购单
        /// </summary>
        /// <returns></returns>
        public DataSet SetPOApply(Dbconn conn, String strType)
        {
            DataSet ds = new DataSet();
            string strActor = m_request.Tables[0].Rows[0]["actor"].ToString();
            string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
            string strXML1 = m_request.Tables[0].Rows[0]["XML1"].ToString();
            //获取申购单主表数据
            DataSet dsXML = Common.Common.GetDSByExcelXML(strXML);
            String strOPType = dsXML.Tables["OPTYPE"].Rows[0][0].ToString().ToUpper();
            String strID = dsXML.Tables["LIST"].Rows[0]["ID"].ToString();
            String strTaskID = dsXML.Tables["LIST"].Rows[0]["TaskID"].ToString();
            String strCONO = dsXML.Tables["LIST"].Rows[0]["CONO"].ToString();
            String strDIVI = dsXML.Tables["LIST"].Rows[0]["DIVI"].ToString(); 

            String strXMLC = "【操作类型,SAVE】【实体,单据保存】"
                           + "【CONO," + strCONO + "】【DIVI," + strDIVI + "】"
                           + "【TableXML," + strXML + "】"
                           + "【TableXMLsub," + strXML1 + "】"
                           + "【Type," + strType + "】【Actor," + strActor + "】【ID," + strID + "】"
                           + "【TaskID," + strTaskID + "】"
                           + "【返回内容, id,单据号,流程id】";

            ds = conn.GetDataSetBySP("API_LV.POApply", new string[4] { "@InputFormat", "@OutputFormat"
                    , "@OutputContentType", "@ConditionStr" }
                   , new string[4] { "AML", "DB", "RS", strXMLC });
            return ds;
        }

        /// <summary>
        /// 获取预算信息
        /// </summary>
        /// <returns></returns>
        public DataSet GetYSInfo(Dbconn conn, String strType)
        {
            DataSet ds = new DataSet();
            String strSQL = "";

            //获取条件值  
            string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
            DataSet dsXML = Common.Common.GetDSByExcelXML(strXML);
            string strCONO = dsXML.Tables["LIST"].Rows[0]["CONO"].ToString();
            string strDIVI = dsXML.Tables["LIST"].Rows[0]["DIVI"].ToString();
            string strCenterCode = dsXML.Tables["LIST"].Rows[0]["CenterCode"].ToString();
            string strDate = dsXML.Tables["LIST"].Rows[0]["Date"].ToString();
            string strBillCode = dsXML.Tables["LIST"].Rows[0]["BillCode"].ToString();

            String strXMLC = "【操作类型,GET】【实体, LVAPP预算查询】"
                           + "【CONO," + strCONO + "】【DIVI," + strDIVI + "】"
                           + "【《W》成本中心, " + strCenterCode + "】"
                           + "【《W》查询日期," + strDate + "】"
                           + "【《W》申购单号, " + strBillCode + "】"
                           + "【条件内容,】"
                           + "【返回内容,】";

            ds = conn.GetDataSetBySP("[API_LV].[POApply]", new string[4] { "@InputFormat", "@OutputFormat"
                    , "@OutputContentType", "@ConditionStr" }
                   , new string[4] { "AML", "DB", "RS", strXMLC });
            return ds;

        }

        /// <summary>
        /// 明细关联或替换鉴定单
        /// </summary>
        /// <returns></returns>
        public DataSet LinkCCAS(Dbconn conn, String strType)
        {
            DataSet ds = new DataSet();
            String strSQL = "";

            //获取条件值 
            string strActor = m_request.Tables[0].Rows[0]["actor"].ToString();
            string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
            DataSet dsXML = Common.Common.GetDSByExcelXML(strXML); 
            string strCONO = dsXML.Tables["LIST"].Rows[0]["CONO"].ToString();
            string strDIVI = dsXML.Tables["LIST"].Rows[0]["DIVI"].ToString();

            String strXMLC = "【操作类型,LinkCCAS】【实体,关联鉴定单】【CONO," + strCONO + "】【DIVI," + strDIVI + "】"
                           + "【Actor," + strActor + "】"
                           + "【TableXML," + strXML + "】"
                           + "【返回内容, 执行结果】"; 

            ds = conn.GetDataSetBySP("API_LV.POApply", new string[4] { "@InputFormat", "@OutputFormat"
                    , "@OutputContentType", "@ConditionStr" }
                   , new string[4] { "AML", "DB", "RS", strXMLC });
            return ds; 
        }

        /// <summary>
        /// 低值易耗品报销勾对
        /// </summary>
        /// <param name="conn"></param>
        /// <param name="strType"></param>
        /// <returns></returns>
        public DataSet SetPOApplySubmit(Dbconn conn, String strType)
        {
            DataSet ds = new DataSet(); ;

            //获取条件值 
            string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
            DataSet dsXML = Common.Common.GetDSByExcelXML(strXML);

            String strActor = dsXML.Tables["LIST"].Rows[0]["Actor"].ToString();
            string strSubmitID = dsXML.Tables["LIST"].Rows[0]["SubmitID"].ToString();

            String strXMLC = "【操作类型,SAVE】【实体,报销财务勾对】【CONO,】【DIVI,】"
                           + "【《W》操作人, " + strActor + "】"
                           + "【《W》勾对记录, " + strSubmitID + "】"
                           + "【条件内容,】"
                           + "【返回内容,主表列表】";

            ds = conn.GetDataSetBySP("[API_LV].[POApply]", new string[4] { "@InputFormat", "@OutputFormat"
                    , "@OutputContentType", "@ConditionStr" }
                   , new string[4] { "AML", "DB", "RS", strXMLC });
            return ds;

        }

        /// <summary>
        /// 获取 UNIQUE_KEY
        /// </summary>
        /// <returns></returns>
        public string getUniqueKey(Dbconn conn)
        {
            DataSet ds = new DataSet();
            string code = "";
            String strXMLC = "【操作类型,GET】【DIVI,D01】【CONO,HWA】【主分类编码,HR】【关键字,HR】";
            ds = conn.GetDataSetBySP("[SRV_MDM].[BillCode]", new string[4] { "@InputFormat", "@OutputFormat"
                    , "@OutputContentType", "@ConditionStr" }
                   , new string[4] { "AML", "DB", "RS", strXMLC });
            if (ds.Tables != null)
            {
                code = ds.Tables[0].Rows[0]["billcode"].ToString();;
            } 
            return code;

        }

        /// <summary>
        /// 固定资产申购单预算校验
        /// </summary>
        /// <returns></returns>
        public DataSet CheckFABudget(string strType, Dbconn conn)
        {
            DataSet ds = new DataSet();

            //获取条件值
            string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
            DataSet dsXML = Common.Common.GetDSByExcelXML(strXML); 
            string strPOApplyCode = dsXML.Tables["LIST"].Rows[0]["POApplyCode"].ToString();

            String strXMLC = "【操作类型,GET】【实体,FAAPP预算校验】【CONO,】【DIVI,】" 
                           + "【《W》申购单号," + strPOApplyCode + "】" 
                           + "【返回内容, 主表列表】";

            ds = conn.GetDataSetBySP("API_FA.BudgetOfTYBZ", new string[4] { "@InputFormat", "@OutputFormat"
                    , "@OutputContentType", "@ConditionStr" }
                   , new string[4] { "AML", "DB", "RS", strXMLC });

            return ds;
        }

        private void AddNewRow(Dbconn conn, string strbody_id, string struser_name, string struser_login_name, string struser_notuse)
        {
            string[] strParam = new string[5];
            strParam[0] = "@MDMName";
            strParam[1] = "@PropertyName";
            strParam[2] = "@ExpressionName";
            strParam[3] = "@BodyID";
            strParam[4] = "@Values";

            string[] strValues = new string[5];
            strValues[0] = "User";
            strValues[1] = "用户姓名";
            strValues[2] = "CN";
            strValues[3] = strbody_id;
            strValues[4] = struser_name;

            conn.GetDataSetBySP("SP_InsertValue", strParam, strValues);
            strValues[0] = "User";
            strValues[1] = "用户所属App";
            strValues[2] = "CN";
            strValues[3] = strbody_id;
            strValues[4] = "F22";
            conn.GetDataSetBySP("SP_InsertValue", strParam, strValues);

            strValues[0] = "User";
            strValues[1] = "登录用户名";
            strValues[2] = "CN";
            strValues[3] = strbody_id;
            strValues[4] = struser_login_name;
            conn.GetDataSetBySP("SP_InsertValue", strParam, strValues);

            strValues[0] = "User";
            strValues[1] = "是否停用";
            strValues[2] = "CN";
            strValues[3] = strbody_id;
            strValues[4] = struser_notuse;
            conn.GetDataSetBySP("SP_InsertValue", strParam, strValues);

            if (struser_notuse == "1")
            {
                strValues[0] = "User";
                strValues[1] = "停用日期";
                strValues[2] = "CN";
                strValues[3] = strbody_id;
                strValues[4] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                conn.GetDataSetBySP("SP_InsertValue", strParam, strValues);
            }
            else
            {
                strValues[0] = "User";
                strValues[1] = "停用日期";
                strValues[2] = "CN";
                strValues[3] = strbody_id;
                strValues[4] = "";
                conn.GetDataSetBySP("SP_InsertValue", strParam, strValues);
            }
        }

        /// <summary>
        /// 利润中心损益表配置 配置-修改-查询
        /// </summary>
        /// <returns></returns>
        public DataSet ISRows(Dbconn conn, String strType)
        {
            DataSet ds_Return = new DataSet();
            string strActor = m_request.Tables[0].Rows[0]["actor"].ToString();
            string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
            DataSet dsXML = Common.Common.GetDSByExcelXML(strXML); 
            DataSet ds = new DataSet();
            String strSQL = "";
            if (strType == "UpdISRows")
            {
                DataTable dtOptypes = dsXML.Tables["OPTYPE"];
                bool bResult = true;
                conn.BeginTransaction();
                for (int i = 0; i < dtOptypes.Rows.Count; i++)
                {
                    //如果包含rowindex，就循环移除
                    if (dsXML.Tables[i + 1].Columns.Contains("rowindex"))
                    {
                        dsXML.Tables[i + 1].Columns.Remove("rowindex");
                    }
                    if (dtOptypes.Rows[i][0].ToString().ToUpper() == "UPDATE")
                    {
                        DataTable dt_List2 = dsXML.Tables[i + 1];
                        //添加更新主键，按照GUID更新
                        ArrayList ListKey = new ArrayList();
                        ListKey.Add("bg6_id");
                        bResult = conn.Update("B01_MDM.BG6_IncomeStatement", dt_List2, ListKey);
                    }
                     
                }
                conn.CommitTransaction();
                if (bResult)
                {
                    dt_EditResult.Rows.Add(new object[] { true, "保存成功！" });
                }
                else
                {
                    dt_EditResult.Rows.Add(new object[] { false, "保存失败！" });

                }
                ds_Return.Tables.Add(dt_EditResult);
                return ds_Return; 
            }
            else if (strType == "ISRows")
            { 
                //获取条件值   
                string strPage = dsXML.Tables["LIST"].Rows[0]["Page"].ToString();
                string strNum = dsXML.Tables["LIST"].Rows[0]["Num"].ToString();
                string strCons = dsXML.Tables["LIST"].Rows[0]["Cons"].ToString();
                string strOrderBy = dsXML.Tables["LIST"].Rows[0]["OrderBy"].ToString();
                string[] strParam = new string[] { };
                strSQL = @"  SELECT * FROM B01_MDM.BG6_IncomeStatement
                            WHERE 1=1 " + strCons;
                ds = conn.GetDataSetForPageList(strSQL, strParam, int.Parse(strPage), int.Parse(strNum), strOrderBy);
                return ds;
            }
            else if (strType == "ISRowsHZ")
            {
                //获取条件值   
                string strCONO = dsXML.Tables["LIST"].Rows[0]["CONO"].ToString();
                string strDIVI = dsXML.Tables["LIST"].Rows[0]["DIVI"].ToString();
                string strType1 = dsXML.Tables["LIST"].Rows[0]["Type"].ToString();
                string strYear = dsXML.Tables["LIST"].Rows[0]["Year"].ToString();
                string strBrand = dsXML.Tables["LIST"].Rows[0]["Brand"].ToString();
                string strCostCenter = dsXML.Tables["LIST"].Rows[0]["CostCenter"].ToString();
                string strShopType = dsXML.Tables["LIST"].Rows[0]["ShopType"].ToString();
                string strDLCode = dsXML.Tables["LIST"].Rows[0]["DLCode"].ToString();
                string strXLCode = dsXML.Tables["LIST"].Rows[0]["XLCode"].ToString();
                string strCom = dsXML.Tables["LIST"].Rows[0]["Com"].ToString();
                string strDept = dsXML.Tables["LIST"].Rows[0]["Dept"].ToString();
                string strProject = dsXML.Tables["LIST"].Rows[0]["Project"].ToString();
                string strState = dsXML.Tables["LIST"].Rows[0]["State"].ToString();

                String strXMLC = "【操作类型,GET】【实体, 利润中心损益】"
                                + "【CONO," + strCONO + "】【DIVI," + strDIVI + "】"
                                + "【《W》汇总方式, " + strType1 + "】"
                                + "【《W》年份," + strYear + "】 【《W》品牌," + strBrand + "】"
                                + "【《W》成本中心," + strCostCenter + "】【《W》店铺类型," + strShopType + "】"
                                + "【《W》大类编码," + strDLCode + "】【《W》小类编码," + strXLCode + "】"
                                + "【《W》公司, " + strCom + "】"
                                + "【《W》部门," + strDept + "】【《W》项目名称," + strProject + "】"
                                + "【《W》状态," + strState + "】"
                                + "【条件内容,】" 
		                        + "【返回内容,】";

                ds = conn.GetDataSetBySP("[API_BM].[IncomeStatement]", new string[4] { "@InputFormat", "@OutputFormat"
                        , "@OutputContentType", "@ConditionStr" }
                        , new string[4] { "AML", "DB", "RS", strXMLC });
                return ds;
            } 
            return ds;
        }

        /// <summary>
        /// 部门预算汇总(含追加)
        /// </summary>
        /// <returns></returns>
        public DataSet GetDeptKMGQRowsA(Dbconn conn, String strType)
        {
            DataSet ds = new DataSet();
            String strSQL = "";

            //获取条件值  
            string strXML = m_request.Tables[0].Rows[0]["XML"].ToString();
            DataSet dsXML = Common.Common.GetDSByExcelXML(strXML);
            string strCONO = dsXML.Tables["LIST"].Rows[0]["CONO"].ToString();
            string strDIVI = dsXML.Tables["LIST"].Rows[0]["DIVI"].ToString();
            string strType1 = dsXML.Tables["LIST"].Rows[0]["Type"].ToString();
            string strYear = dsXML.Tables["LIST"].Rows[0]["Year"].ToString();
            string strBrand = dsXML.Tables["LIST"].Rows[0]["Brand"].ToString();
            string strDept = dsXML.Tables["LIST"].Rows[0]["Dept"].ToString();
            string strProject = dsXML.Tables["LIST"].Rows[0]["Project"].ToString();
            string strCostCenter = dsXML.Tables["LIST"].Rows[0]["CostCenter"].ToString();
            string strDLCode = dsXML.Tables["LIST"].Rows[0]["DLCode"].ToString();
            string strXLCode = dsXML.Tables["LIST"].Rows[0]["XLCode"].ToString();
            string strState = dsXML.Tables["LIST"].Rows[0]["State"].ToString();

            String strXMLC = "【操作类型,GET】【实体, 部门预算科目汇总】"
                           + "【CONO," + strCONO + "】【DIVI," + strDIVI + "】"
                           + "【《W》汇总方式, " + strType1 + "】"
                           + "【《W》年份," + strYear + "】 【《W》品牌," + strBrand + "】"
                           + "【《W》部门," + strDept + "】【《W》项目名称," + strProject + "】"
                           + "【《W》成本中心," + strCostCenter + "】"
                           + "【《W》大类编码," + strDLCode + "】【《W》小类编码," + strXLCode + "】"
                           + "【《W》状态," + strState + "】"
                           + "【条件内容,】"
                           + "【返回内容,】";

            ds = conn.GetDataSetBySP("[API_BM].[BudgetA]", new string[4] { "@InputFormat", "@OutputFormat"
                    , "@OutputContentType", "@ConditionStr" }
                   , new string[4] { "AML", "DB", "RS", strXMLC });
            return ds;

        }