//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(); }
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(); }
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); }