/// <summary> ///指标类型代码 /// </summary> /// <param name="name"></param> /// <returns></returns> public static string get_VITYPE(string name) { string strsql = "select VITYPE from VITYPEINFO where VINAME=@name"; SqlParameter parm = new SqlParameter("@name", name); string result = DataBaseOperate.getResult(strsql, parm); return(result); }
/// <summary> /// 返回数据库中字段的中文名 /// </summary> /// <param name="tablename"></param> /// <returns></returns> public static string get_TableCHName(string tablename) { string strsql = "select TableCHName from DIC_TABLENAME where TableEName=@name"; SqlParameter param = new SqlParameter("@name", tablename); string result = DataBaseOperate.getResult(strsql, param); return(result); }
/// <summary> ///传感器类型中文名 /// </summary> /// <param name="name"></param> /// <returns></returns> public static string get_SensorNAME(string name) { string strsql = "select SENSORNAME from SENSORTYPEINFO where SENSORTYPE=@name"; SqlParameter parm = new SqlParameter("@name", name); string result = DataBaseOperate.getResult(strsql, parm); return(result); }