/// <summary> /// 获取当前任务的数据库连接串 /// </summary> /// <param name="dt"></param> /// <returns></returns> public Model.ConnectInfo GetConnectInfo(Model.Synergismlogdt dt) { DAL.Regist rdal = new Regist(); Model.Regist rmdoel = rdal.GetModel(dt.Accid); if (rmdoel != null) { Model.ConnectInfo cimodel = new Model.ConnectInfo(); cimodel.AccId = rmdoel.Cacc_id; cimodel.Source = rmdoel.Datasource; cimodel.Password = rmdoel.Cpassword; cimodel.Srv = rmdoel.Caddress; //应用服务器 add by wangdd cimodel.sSrv = rmdoel.Cservername; cimodel.SubId = "DP"; //测试 cimodel.UserId = rmdoel.Cuser_id; cimodel.YearId = rmdoel.Ibeginyear.ToString(); cimodel.Serial = BLL.Common.GetSerial(); cimodel.BEnable = rmdoel.Benable == "1" || rmdoel.Benable == "是"; cimodel.Constring = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID=sa;Password={2};Current Language=Simplified Chinese", rmdoel.Caddress, rmdoel.Caccname, rmdoel.Cdbpwd); cimodel.Date = BLL.Common.GetVerifyData(dt); if (cimodel.Date == DateTime.Now.ToString("yyyy-MM-dd")) { cimodel.Date = BLL.Common.GetLoginDate(rmdoel); } return(cimodel); } return(null); }
public string getConnStr(Model.Synergismlogdt dt) { DAL.Regist rdal = new Regist(); Model.Regist rmdoel = rdal.GetModel(dt.Accid); if (rmdoel != null) { return(string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID=sa;Password={2};Current Language=Simplified Chinese", rmdoel.Caddress, rmdoel.Caccname, rmdoel.Cdbpwd)); } else { return(""); } }