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