public void CreateSelectionDataTable(string datasource) { IRoadsDao roadDao = MyApp.Dal.RoadsDao; roadDao.DataSource = datasource; using (IDbConnection conn = roadDao.Select.OpenDbConnection()) { conn.ExecuteNonQuery(File.ReadAllText(PathUtil.MapAbsolutePath("Config/select.sql"), Encoding.ASCII)); } }
public void TestScence() { string databaseId = this.Scene.Context.RoadWayDatabaseId; string databaseName = databaseId.GetDatbaseNameById(); using (IRoadsDao dao = this.Scene.Dal.RoadsDao) { dao.DataSource = databaseName; using (IDbConnection conn = dao.IHPMS.OpenDbConnection()) { conn.ExecuteNonQuery("use ihpms;"); } } }
public List <T> Get <T>() where T : class, ISelection { string databaseId = this.Scene.Context.RoadWayDatabaseId; string databaseName = databaseId.GetDatbaseNameById(); using (IRoadsDao dao = this.Scene.Dal.RoadsDao) { dao.DataSource = databaseName; using (IDbConnection conn = dao.Select.OpenDbConnection()) { return(conn.SelectFmt <T>("select * from Selection")); } } }
public List <string> GetVal_OP(string stnd_name) { string databaseId = this.Scene.Context.RoadWayDatabaseId; string databaseName = databaseId.GetDatbaseNameById(); using (IRoadsDao dao = this.Scene.Dal.RoadsDao) { dao.DataSource = databaseName; using (IDbConnection conn = dao.IHPMS.OpenDbConnection()) { string sql = string.Format("SELECT VAL_OP1 FROM PMSELTS WHERE STND_NAME = '{0}'", stnd_name); return(conn.Column <string>(sql)); } }; }
public List <int> GetCodeInWorkArea(string StndName, ref int NumElts) { string databaseId = this.Scene.Context.RoadWayDatabaseId; string databaseName = databaseId.GetDatbaseNameById(); List <int> ret = new List <int>(); using (IRoadsDao dao = this.Scene.Dal.RoadsDao) { dao.DataSource = databaseName; using (IDbConnection conn = dao.IHPMS.OpenDbConnection()) { ret = conn.Column <int>(string.Format("SELECT CODE FROM CODEINFO WHERE STNDNAME = '{0}' AND CODE>0", StndName)); } } NumElts = ret.Count; return(ret); }
public List <T> Get <T>(T entity) where T : ICODEINFO { //using (IDbConnection conn = MyApp.Dal.BasisDao.IHPMS.OpenDbConnection()) //{ // return conn.SelectFmt<T>("select * from CODEINFO where STNDNAME = {0} and info != 'no data'", entity.STNDNAME); //} string databaseId = this.Scene.Context.RoadWayDatabaseId; string databaseName = databaseId.GetDatbaseNameById(); using (IRoadsDao dao = this.Scene.Dal.RoadsDao) { dao.DataSource = databaseName; using (IDbConnection conn = dao.IHPMS.OpenDbConnection()) { return(conn.SelectFmt <T>("select * from CODEINFO where STNDNAME = {0} and info != 'no data'", entity.STNDNAME)); } } }
public void CopyData <T>(string datasource) { OrmLiteConfig.DialectProvider = SqlServerOrmLiteDialectProvider.Instance; var connectionString = string.Format(ConfigStringsFactory.NewConfigStrings().IHPMSConnectionString, ""); IRoadsDao roadDao = MyApp.Dal.RoadsDao; roadDao.DataSource = datasource; using (IDbConnection sourceConn = connectionString.OpenDbConnection()) { List <T> data = sourceConn.Select <T>(); if (data.Count > 0) { using (IDbConnection targetConn = roadDao.IHPMS.OpenDbConnection()) { targetConn.InsertAll <T>(data); } } } }
public List <T> Get <T>(IPMSELT entity) where T : class, IPMSELT { string databaseId = this.Scene.Context.RoadWayDatabaseId; string databaseName = databaseId.GetDatbaseNameById(); using (IRoadsDao dao = this.Scene.Dal.RoadsDao) { dao.DataSource = databaseName; using (IDbConnection conn = dao.IHPMS.OpenDbConnection()) { //return conn.SelectFmt<T>("SELECT * FROM PMSELTS WHERE UPDATE_MULT = -1"); if (entity.UPDATE_MULT != null) { return(conn.Select <T>(q => q.UPDATE_MULT == entity.UPDATE_MULT)); } else if (entity.STND_NAME != null) { return(conn.Select <T>(q => q.STND_NAME == entity.STND_NAME)); } return(conn.Select <T>()); } } }