コード例 #1
0
 //protected string  CountyData = "[]";
 //protected string  TownData = "[]";
 protected void Page_Load(object sender, EventArgs e)
 {
     // base.DisableTop(true);
     // CountyData = JsonConvert.SerializeObject(SystemAreaCode.GetCountyList());
     // TownData = JsonConvert.SerializeObject(SystemAreaCode.GetCountyList());
     SystemOrg.Update();
     SystemRole.Update();
 }
コード例 #2
0
ファイル: ReloadEnum.aspx.cs プロジェクト: peter7788yes/NIIS2
    protected void Page_Load(object sender, EventArgs e)
    {
        //long Process_MemoryStart = 0;
        //long Process_MemoryEnd = 0;
        //System.Diagnostics.Process MyProcess = System.Diagnostics.Process.GetCurrentProcess();
        //Process_MemoryStart = MyProcess.PrivateMemorySize64;

        //Response.Write(Process_MemoryStart);
        //Console.WriteLine(Process_MemoryStart);

        //Console.WriteLine(GC.GetTotalMemory(true).ToString());

        SystemCode.Update();
        SystemRole.Update();
        SystemRoleOrg.Update();
        SystemAreaCode.Update();


        //Process_MemoryEnd = MyProcess.PrivateMemorySize64;
        //Response.Write(Process_MemoryEnd);
        //Console.WriteLine(Process_MemoryEnd);
        //HomeUrlVM vm =new HomeUrlVM();
        //vm.PageUrl = "/System/CodeM/CodeSetting.aspx";
        //vm.date = DateTime.Now;
        //string s = JsonConvert.SerializeObject(vm);
        //s=QueryStringEncryptToolS.Encrypt(s);
        //s = HttpUtility.UrlEncode(s);
        //Response.Write(s);
        //Response.End();

        //HomeUrlSecret secret = new HomeUrlSecret();
        //secret.RedirectUrl = "Home";

        //string s=JsonConvert.SerializeObject(secret);

        //UrlParameterEncryptT EncryptT = new UrlParameterEncryptT();
        //UrlParameterDecryptT DecryptT = new UrlParameterDecryptT();

        //s = EncryptT.GetOutSecretJsonWithEncrypt(secret);
        //string ss = s;
        //int cc = s.Length;
        //Response.Write(s);
        //Response.Write("<br/>");
        //Response.Write(s.Length);
        //s = HttpUtility.UrlEncode(s);
        //Response.Write("<br/>");
        //Response.Write(s);
        //Response.Write("<br/>");
        //Response.Write(s.Length);
        //Response.Write("<br/>");
        //string a = Request["o"]??"";
        //int b = 0;
        //int.TryParse(Request["c"] ?? "0", out b);
        //HomeUrlSecret secret2 = new HomeUrlSecret();
        //secret2 = DecryptT.GetUrlSecret<HomeUrlSecret>(ss, TimeSpan.FromDays(1), cc);
        //if(secret2.IsValid==true)
        //    Response.Write("2Checksum驗證成功");
        //else
        //    Response.Write("2Checksum驗證失敗");
        //Response.End();
    }
コード例 #3
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        int RoleID = 0;

        int.TryParse(hfR.Value, out RoleID);

        if (RoleID == 0)
        {
            string SC = "<script>alert('資料取得失敗');location.href = '/System/PowerM/RolePowerSetting_Add.aspx';</script>";
            Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", SC, false);
            return;
        }

        string script = "<script>alert('儲存失敗');</script>";

        if (hfV != null)
        {
            string jsonString = hfV.Value;

            List <RolePowerSettingPowerVM> list = new List <RolePowerSettingPowerVM>();
            list = JsonConvert.DeserializeObject <List <RolePowerSettingPowerVM> >(jsonString);


            DataTable dt = new DataTable();
            dt.Columns.Add("ID");
            dt.Columns.Add("RoleID");
            dt.Columns.Add("ModuleID");
            dt.Columns.Add("PowerString");


            foreach (var item in list.Where(item => item.PowerStringOut > 1))
            {
                dt.Rows.Add(0, RoleID, item.mId, item.PowerStringOut);
            }


            System.Transactions.TransactionOptions option = new System.Transactions.TransactionOptions();
            option.IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted;
            option.Timeout        = new TimeSpan(0, 10, 0);
            using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope(TransactionScopeOption.Required, option))
            {
                using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnUser"].ToString()))
                {
                    sc.Open();

                    using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sc))
                    {
                        bulkCopy.BulkCopyTimeout      = 60;
                        bulkCopy.DestinationTableName = "dbo.R_RoleModule";
                        bulkCopy.WriteToServer(dt);
                    }

                    ts.Complete();
                }
            }
            //using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnUser"].ToString()))
            //{
            //    sc.Open();
            //    SqlTransaction st = sc.BeginTransaction();
            //    //SqlBulkCopy批次處理新增 沒有檢驗比對處理
            //    using (SqlBulkCopy sb = new SqlBulkCopy(sc, SqlBulkCopyOptions.Default, st))
            //    {
            //        //foreach (string columnName in GetMapping(stringSource, stringTarget, 'dbo.R_RoleModule'))
            //        //{
            //        //    sb.ColumnMappings.Add(new SqlBulkCopyColumnMapping(columnName, columnName));
            //        //}
            //        sb.DestinationTableName = "dbo.R_RoleModule";
            //        sb.WriteToServer(dt);
            //    }

            //    st.Commit();

            //}
            SystemRole.Update();
            script = "<style>body{display:none;}</style><script>alert('儲存成功');location.href='/System/PowerM/RolePowerSetting.aspx';</script>";
            Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false);
        }


        Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false);
    }