public void GetLineName() { BLL_Document Bll = new BLL_Document(); JZ.BLL.sys_line sysBaseLine = Session["SysBaseLine"] as JZ.BLL.sys_line; LineName = sysBaseLine.LineName; }
public static void GetConnection() { string DataSource = @""; string DataInstance = ""; string DataUserName = ""; string DataPassword = ""; sys_line projectModel = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line; if (projectModel != null) { DataSource = projectModel.DataSourceAddress; DataInstance = projectModel.DataBaseName; DataUserName = projectModel.UserName; DataPassword = projectModel.PassWord; } connectionString = "server=" + DataSource + ";database=" + DataInstance + ";uid=" + DataUserName + ";pwd=" + DataPassword + ";"; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetLineName(); String id = Request.Params["id"]; string MName = Request.Params["MName"]; if (!String.IsNullOrEmpty(id)) { if (Session["SysBaseLine"] != null) { StringBuilder sb1 = new StringBuilder(); JZ.BLL.sys_line sysBaseLine = Session["SysBaseLine"] as JZ.BLL.sys_line; LoadReport(sysBaseLine.DataSourceAddress, sysBaseLine.DataBaseName, sysBaseLine.UserName, sysBaseLine.PassWord, id); } } } }
public BOBase() { bool DataISAttach = false; bool DataIntegratedLogin = false; string DataAdapterType = "sqlclient"; string DataBaseType = "mssqlserver2k5"; string DataSource = @""; string DataInstance = ""; string DataUserName = ""; string DataPassword = ""; sys_line projectModel = System.Web.HttpContext.Current.Session["SysBaseLine"] as sys_line; if (projectModel != null) { DataSource = projectModel.DataSourceAddress; DataInstance = projectModel.DataBaseName; DataUserName = projectModel.UserName; DataPassword = projectModel.PassWord; } CreateInstance(DataAdapterType, DataBaseType, DataIntegratedLogin, DataSource, DataInstance, DataUserName, DataPassword, DataISAttach, ""); }
public void CreateProjectModel_BaseSys(string appString) { if (!String.IsNullOrEmpty(appString)) { DataSet ds = new DataSet(); string SqlText = "SELECT * FROM dbo.sys_line WHERE ID='" + appString + "'"; ds = LineDbHelperSQL.Query(SqlText); sys_line sysBaseLine = new sys_line(); if (ds != null && ds.Tables.Count > 0) { #region 保存当前选择线路的值,添加的用户的时候判断是否重复,以及区分新旧线 sysBaseLine.ID = new Guid(ds.Tables[0].Rows[0]["ID"].ToString()); sysBaseLine.Description = ds.Tables[0].Rows[0]["Description"].ToString(); sysBaseLine.DataBaseName = ds.Tables[0].Rows[0]["DataBaseName"].ToString(); sysBaseLine.DataSourceAddress = ds.Tables[0].Rows[0]["DataSourceAddress"].ToString(); sysBaseLine.IPAddress = ds.Tables[0].Rows[0]["IPAddress"].ToString(); sysBaseLine.IsActive = System.Convert.ToInt32(ds.Tables[0].Rows[0]["IsActive"].ToString()); sysBaseLine.LineName = ds.Tables[0].Rows[0]["LineName"].ToString(); sysBaseLine.PassWord = ds.Tables[0].Rows[0]["PassWord"].ToString(); sysBaseLine.UserName = ds.Tables[0].Rows[0]["UserName"].ToString(); sysBaseLine.Domain = ds.Tables[0].Rows[0]["Domain"].ToString(); #endregion } SqlText = @"INSERT dbo.sys_BaseLine_UsersLoginLog ( UserName , IpAddress , LoginTime , LineName , Desic , biz1 , biz2 ) VALUES ( '" + System.Web.HttpContext.Current.Session["UserName"].ToString() + "' , '" + System.Web.HttpContext.Current.Request.UserHostAddress + "' , '" + DateTime.Now.ToString() + "' ,'" + sysBaseLine.ID + "' , '" + sysBaseLine.LineName + "' ,'' ,'' )"; LineDbHelperSQL.ExecuteSql(SqlText); System.Web.HttpContext.Current.Session["SysBaseLine"] = sysBaseLine; } }