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