public string Select_db(string ServerName, string UserName, string Password) { string DBName_display = ""; ActResult xresult = new ActResult(); SqlConn.ConnectionString = @"Server=" + ServerName.Trim() + ";User Id=" + UserName.Trim() + ";Password="******"select name from sys.databases where name not in('master','tempdb','model','msdb','AdventureWorksDW','AdventureWorks') and name='REPORTING_DB'"; xresult = ExecuteTable(SQL, SqlConn, null, out dt); if (xresult.Result == ActResult.ResultType.Success) { if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { DBName_display += "<option value=" + dr["name"].ToString() + ">" + dr["name"].ToString() + "</option>"; } } } SqlConn.Close(); } catch (Exception) { throw; } return(DBName_display); }
public ActResult ExecuteTable(string SQL, SqlConnection sqlConn, SqlTransaction Trans, out DataTable dt) { ActResult actResult = new ActResult(); dt = new DataTable(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.Connection = sqlConn; command.Transaction = Trans; command.CommandText = SQL; SqlDataAdapter adpter = new SqlDataAdapter(command); try { adpter.Fill(dt); actResult.Result = ActResult.ResultType.Success; } catch (Exception) { actResult.Result = ActResult.ResultType.Fail; } return(actResult); }
public DataTable Main_Menu(string userkey) { ActResult xresult = new ActResult(); ActResult xresult1 = new ActResult(); ActResult xresult2 = new ActResult(); DataTable MainMenu = new DataTable(); DataTable Sub_menu = new DataTable(); DataTable Sum_in_array = new DataTable(); DataTable temp_dt = new DataTable(); DataSet ds = new DataSet(); /* * Declare to connection string */ mutility.DbName = Settings.Default["DbName"].ToString(); mutility.UserName = Settings.Default["UserName"].ToString(); mutility.Password = Settings.Default["Password"].ToString(); mutility.ServerName = Settings.Default["ServerName"].ToString(); con.ConnectionString = "Data source=" + mutility.ServerName + ";Initial catalog=" + mutility.DbName + ";User ID=" + mutility.UserName + ";Password="******" SELECT * FROM Sys_Permissions_role Spr INNER JOIN Sys_function_permissions Sfp on Spr.functype = Sfp.functype where Sfp.menulist = 'T' and Spr.user_key = '" + userkey + "' and Spr.flag = 1"; xresult = ExecuteTable(Sql_Main, con, null, out MainMenu); ds.Tables.Add(MainMenu); Menu = ds.Tables[0].Copy(); con.Close(); return(Menu); }
public DataTable UserAccessRight(string userkey) { ActResult xresult = new ActResult(); ActResult xresult1 = new ActResult(); ActResult xresult2 = new ActResult(); DataTable MainMenu = new DataTable(); DataTable Sub_menu = new DataTable(); DataTable Sum_in_array = new DataTable(); DataTable temp_dt = new DataTable(); DataSet ds = new DataSet(); int ds_check = 0; /* * Declare to connection string */ mutility.DbName = Settings.Default["DbName"].ToString(); mutility.UserName = Settings.Default["UserName"].ToString(); mutility.Password = Settings.Default["Password"].ToString(); mutility.ServerName = Settings.Default["ServerName"].ToString(); //con.ConnectionString = "Data source=" + mutility.ServerName + ";Initial catalog=" + mutility.DbName + ";User ID=" + mutility.UserName + ";Password="******" SELECT * FROM Sys_Permissions_role Spr INNER JOIN Sys_function_permissions Sfp on Spr.functype = Sfp.functype where Sfp.menulist = 'T' and Spr.user_key = '" + userkey + "' and Spr.flag = 1"; xresult = ExecuteTable(Sql_Main, con, null, out MainMenu); //ds.Tables.Add(MainMenu); string SqL_SubMain = @" SELECT * FROM Sys_Permissions_role Spr INNER JOIN Sys_function_permissions Sfp on Spr.functype = Sfp.functype where Sfp.menulist = 'T' and Spr.user_key = '" + userkey + "' and Spr.flag =2"; xresult1 = ExecuteTable(SqL_SubMain, con, null, out Sub_menu); if (xresult.Result == ActResult.ResultType.Success) { if (Sub_menu.Rows.Count > 0) { foreach (DataRow dr in MainMenu.Rows) { string SQl = @" SELECT * FROM Sys_function_permissions Sfp INNER JOIN Sys_permissions_role Spr on Spr.functype = Sfp.functype where Sfp.menulist = 'T' and Spr.user_key = '" + userkey + @"' and Sfp.flag =1 and Spr.flag!=0 and Sfp.parent_id='" + dr["functype"].ToString() + @"' ORDER BY Sfp.order_key ASC"; xresult2 = ExecuteTable(SQl, con, null, out Sum_in_array); if (xresult2.Result == ActResult.ResultType.Success) { ds.Tables.Add(Sum_in_array); ds_check = 0; } } } else { ds_check = 1; } } con.Close(); if (ds_check == 0) { Menu = ds.Tables[0].Copy(); for (int i = 1; i < ds.Tables.Count; i++) { Menu.Merge(ds.Tables[i].Copy()); } } return(Menu); }