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