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