// GET api/position/5
public string Get(int id)
{
Mssql ms = new Mssql();
string ret = ms.getLastPosition(id);
return(ret);
}
// GET api/position
public string Get()
{
Mssql ms = new Mssql();
return(ms.getLastPosition("867822027117158"));
//return new string[] { "value1", "value2" };
}
/// <summary>
/// 获取配置信息
/// </summary>
/// <param name="configName"></param>
/// <param name="typeName"></param>
/// <returns></returns>
public static bool GetConfig(string configName, string typeName)
{
if (configName != null && typeName != null)
{
Mssql sql = new Mssql();
string sqlStr = @"SELECT Valid FROM WG_CONFIG WHERE ConfigName = '{0}' AND Type = '{1}' AND Valid = 'Y' ";
return(sql.SQLexist(connWG, string.Format(sqlStr, configName, typeName)));
}
else
{
return(false);
}
}
static void Main(string[] args)
{
Mssql <Bank> TEST = new Mssql <Bank>();
List <Bank> TheList = TEST.ReadTable();
foreach (var item in TheList)
{
Console.WriteLine(item.LfdNr);
Console.WriteLine(item.Kennung);
Console.WriteLine(item.Name);
Console.WriteLine(item.Ort);
Console.WriteLine(item.PLZ);
Console.WriteLine(item.Straße);
Console.WriteLine(item.TSCREATE);
Console.WriteLine(item.TSUPDATE);
Console.WriteLine("");
Console.WriteLine("");
Console.WriteLine("");
}
Console.ReadLine();
}
public InvmbBoxSize(Mssql mssql, string connYF, Logger logger)
{
this.mssql = mssql;
this.connYF = connYF;
this.logger = logger;
}
public BomList(Mssql mssql, string connYF, Logger logger)
{
this.mssql = mssql;
this.connYF = connYF;
this.logger = logger;
}
public ERP_COPAB02(Mssql mssql, string connYF, Logger logger)
{
this.mssql = mssql;
this.connYF = connYF;
this.logger = logger;
}
public CreateScPlanSnapShot(Mssql mssql, string connWG, Logger logger)
{
this.mssql = mssql;
this.connWG = connWG;
this.logger = logger;
}
public DeleteCoptrError(Mssql mssql, string connYF, Logger logger)
{
this.mssql = mssql;
this.connYF = connYF;
this.logger = logger;
}
public FixPurtc(Mssql mssql, string connYF, Logger logger)
{
this.mssql = mssql;
this.connYF = connYF;
this.logger = logger;
}
public SetMoctaGroup(Mssql mssql, string connYF, Logger logger)
{
this.mssql = mssql;
this.connYF = connYF;
this.logger = logger;
}
public ERP_BOMB05(Mssql mssql, string connYF, Logger logger)
{
this.mssql = mssql;
this.connYF = connYF;
this.logger = logger;
}
public string PostPosition(Pos p)
{
Mssql ms = new Mssql();
return(ms.sqlInsert(p).ToString());
}
public string PostLastPosition(Pos p)
{
Mssql ms = new Mssql();
return(ms.getLastPosition("867822027117158"));
}
public string postStartEnd(DateTimeStartEnd se)
{
Mssql ms = new Mssql();
return(ms.getPtsByStartEndTime(se.starttime, se.endtime));
}
