ASP.NET 修改DataSet中指定DataTable的值

/// <summary>
    /// 得到督办单数据
    /// </summary>
    /// <param name="caseid">案件记录号</param>
    /// <param name="ds"></param>
    /// <returns></returns>
    public static int GetCaseInfo(int userid, int caseid, ref DataSet ds)
    {
        try
        {
            //设置存储过程参数
            OracleParameter[] paras = new OracleParameter[17];
            // 当使用外链页面登录时,则使用默认admin用户Id获取督办单相关数据 潘杰 2011-12-06 16:28:18
            paras[0] = new OracleParameter("p_userid", userid);
            paras[1] = new OracleParameter("p_caseid", caseid);
            paras[2] = new OracleParameter("p_caseinfo", OracleDbType.RefCursor);
            paras[3] = new OracleParameter("p_teaminfo", OracleDbType.RefCursor);
            paras[4] = new OracleParameter("p_curresult", OracleDbType.RefCursor);
            paras[5] = new OracleParameter("p_historyresult", OracleDbType.RefCursor);
            paras[6] = new OracleParameter("p_backinfo", OracleDbType.RefCursor);
            paras[7] = new OracleParameter("p_delayinfo", OracleDbType.RefCursor);
            paras[8] = new OracleParameter("p_solution", OracleDbType.RefCursor);
            paras[9] = new OracleParameter("p_stepinfo", OracleDbType.RefCursor);
            paras[10] = new OracleParameter("p_adjunct", OracleDbType.RefCursor);
            paras[11] = new OracleParameter("p_record", OracleDbType.RefCursor);
            paras[12] = new OracleParameter("p_teltype", OracleDbType.RefCursor);
            paras[13] = new OracleParameter("p_satifyinfo", OracleDbType.RefCursor);
            paras[14] = new OracleParameter("p_caselevel", OracleDbType.RefCursor);
            paras[15] = new OracleParameter("p_currenthfqk", OracleDbType.RefCursor);
            paras[16] = new OracleParameter("p_historyhfqk", OracleDbType.RefCursor);
            //设置存储过程指定参数类型为输出参数
            paras[2].Direction = ParameterDirection.Output;
            paras[3].Direction = ParameterDirection.Output;
            paras[4].Direction = ParameterDirection.Output;
            paras[5].Direction = ParameterDirection.Output;
            paras[6].Direction = ParameterDirection.Output;
            paras[7].Direction = ParameterDirection.Output;
            paras[8].Direction = ParameterDirection.Output;
            paras[9].Direction = ParameterDirection.Output;
            paras[10].Direction = ParameterDirection.Output;
            paras[11].Direction = ParameterDirection.Output;
            paras[12].Direction = ParameterDirection.Output;
            paras[13].Direction = ParameterDirection.Output;
            paras[14].Direction = ParameterDirection.Output;
            paras[15].Direction = ParameterDirection.Output;
            paras[16].Direction = ParameterDirection.Output;
            ds = DbHelperOra.RunProcedure("pkg_caseinfo.proc_caseinfo", paras, "dt_caseinfo");
            ds.Tables[0].TableName = "dt_caseinfo";
            ds.Tables[1].TableName = "dt_teaminfo";
            ds.Tables[2].TableName = "dt_curresult";
            ds.Tables[3].TableName = "dt_historyresult";
            ds.Tables[4].TableName = "dt_backinfo";
            ds.Tables[5].TableName = "dt_delayinfo";
            ds.Tables[6].TableName = "dt_solution";
            ds.Tables[7].TableName = "dt_stepinfo";
            ds.Tables[8].TableName = "dt_adjunct";
            ds.Tables[9].TableName = "dt_record";
            ds.Tables[10].TableName = "dt_teltype";
            ds.Tables[11].TableName = "dt_satifyinfo";
            ds.Tables[12].TableName = "dt_caselevel";//谢绍宁 2014-8-22 10:33:04
            ds.Tables[13].TableName = "dt_currenthfqk";
            ds.Tables[14].TableName = "dt_historyhfqk";

            #region MyRegion
            //DataTable dt0 = ds.Tables[0].Copy();
            DataTable dt0 = ds.Tables[0].Clone();
            dt0.Columns.Remove("市民姓名");
            dt0.Columns.Remove("市民电话");
            dt0.Columns.Add("市民姓名");
            dt0.Columns.Add("市民电话");
            foreach (DataRow dr in ds.Tables[0].Rows)//循环行
            {
                DataRow newdr = dt0.NewRow();
                //newdr.ItemArray = dr.ItemArray;
                newdr["市民姓名"] = dr["市民姓名"];
                newdr["市民电话"] = dr["市民电话"];
                if (Convert.ToInt32(dr["隐藏当事人资料"].ToString()) == 1 && dr["数据来源"].ToString() != "148")//148城市留言板
                {
                    try
                    {
                        WebReference.DepartSvrInterface sm4 = new WebReference.DepartSvrInterface();
                        string smname = dr["市民姓名"].ToString();
                        string smtel = dr["市民电话"].ToString();
                        newdr["市民电话"] = (!string.IsNullOrEmpty(smtel) && smtel.Length < 12) ? strPublic(1, smtel) : strPublic(1, sm4.SM4Encryption(1, smtel));//市民电话隐藏关键字,SM4Encryption中1解密,2加密
                        newdr["市民姓名"] = (!string.IsNullOrEmpty(smname) && smname.Length < 12) ? strPublic(2, smname) : strPublic(2, sm4.SM4Encryption(1, smname));//市民姓名隐藏关键字,SM4Encryption中1解密,2加密

                    }
                    catch (Exception ex)
                    {
                        newdr["市民姓名"] = "保密";
                        newdr["市民电话"] = "保密";

                    };

                }
                else
                {
                    newdr["市民姓名"] = dr["市民姓名"].ToString() == "" ? "&nbsp;" : dr["市民姓名"].ToString();
                    newdr["市民电话"] = dr["市民电话"].ToString() == "" ? "&nbsp;" : dr["市民电话"].ToString();

                }

                #region MyRegion
                newdr["数据来源"] = dr["数据来源"];
                newdr["案件记录号"] = dr["案件记录号"];
                newdr["案件公文号"] = dr["案件公文号"];
                newdr["案件类型编号"] = dr["案件类型编号"];
                newdr["来话内容"] = dr["来话内容"];
                newdr["办理时间MIN"] = dr["办理时间MIN"];
                newdr["派单员备注"] = dr["派单员备注"];
                newdr["领导批示"] = dr["领导批示"];
                newdr["详细地址"] = dr["详细地址"];
                newdr["规定完成时间"] = dr["规定完成时间"];
                newdr["前台案件类型"] = dr["前台案件类型"];
                newdr["隐藏当事人资料"] = dr["隐藏当事人资料"];
                newdr["pdyid"] = dr["pdyid"];
                newdr["派单员备注"] = dr["派单员备注"];
                newdr["案件级别"] = dr["案件级别"];
                newdr["重复记录号"] = dr["重复记录号"];
                newdr["二次督办状态"] = dr["二次督办状态"];
                newdr["是否转职能部门"] = dr["是否转职能部门"];
                #endregion
                dt0.Rows.Add(newdr);
            }
            DataSet newds = new DataSet();
            dt0.TableName = "dt_caseinfo";
            newds.Tables.Add(dt0);
            DataTable dt1 = ds.Tables[1].Copy();
            DataTable dt2 = ds.Tables[2].Copy();
            DataTable dt3 = ds.Tables[3].Copy();
            DataTable dt4 = ds.Tables[4].Copy();
            DataTable dt5 = ds.Tables[5].Copy();
            DataTable dt6 = ds.Tables[6].Copy();
            DataTable dt7 = ds.Tables[7].Copy();
            DataTable dt8 = ds.Tables[8].Copy();
            DataTable dt9 = ds.Tables[9].Copy();
            DataTable dt10 = ds.Tables[10].Copy();
            DataTable dt11 = ds.Tables[11].Copy();
            DataTable dt12 = ds.Tables[12].Copy();
            DataTable dt13 = ds.Tables[13].Copy();
            DataTable dt14 = ds.Tables[14].Copy();
            newds.Tables.Add(dt1);
            newds.Tables.Add(dt2);
            newds.Tables.Add(dt3);
            newds.Tables.Add(dt4);
            newds.Tables.Add(dt5);
            newds.Tables.Add(dt6);
            newds.Tables.Add(dt7);
            newds.Tables.Add(dt8);
            newds.Tables.Add(dt9);
            newds.Tables.Add(dt10);
            newds.Tables.Add(dt11);
            newds.Tables.Add(dt12);
            newds.Tables.Add(dt13);
            newds.Tables.Add(dt14);
            ds.Clear();
            ds = newds.Copy();
            #endregion

            return 1;
        }
        catch (Exception ex)
        {
            return 0;
        }
    }

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值