/// <summary> /// 获取材质规格列表 /// </summary> /// <returns></returns> public DataSet GetStockList() { string sql = ""; sql += " SELECT s.etName,s.lName,mf.mfSpec INTO #s FROM dbo.W_Stock s INNER JOIN dbo.B_MaterialFile mf ON s.mfID = mf.mfID " + " WHERE mf.mfName = '钢板' GROUP BY mf.mfSpec,s.etName,s.lName " + " ORDER BY s.etName,s.lName,mf.mfSpec " + " SELECT etName FROM #s GROUP BY etName ORDER BY etName " + " SELECT lName FROM #s GROUP BY lName ORDER BY CASE WHEN lName LIKE 'Q%' THEN 0 ELSE 1 END,lName " + " SELECT mfSpec FROM #s GROUP BY mfSpec ORDER BY dbo.fSortNumber(mfSpec) " + " DROP TABLE #s "; return(YKDataClass.Query(sql)); }
/// <summary> /// 登陆框中获取服务器和数据库下拉框 /// </summary> /// <returns></returns> public static DataSet getDBForCmb(string startUrl, string theUrl) { DataSet ds = new DataSet(); #region 获取初始连接字符串 try { XmlDocument xmlIPDoc = new XmlDocument(); xmlIPDoc.Load(startUrl + "\\UpdateList.xml"); if (theUrl == "url2") { XmlNode xsDBConnect = xmlIPDoc.SelectSingleNode("//sDBConnect2"); if (xsDBConnect != null) { //YKDataClass .ConnectionString = FZYK .Com .YKSysCom .Decrypt(xsDBConnect .InnerText); YKDataClass.ConnectionString = xsDBConnect.InnerText; } else { XmlNode xDBConnect = xmlIPDoc.SelectSingleNode("//DBConnect2"); if (xDBConnect != null) { YKDataClass.ConnectionString = xDBConnect.InnerText;//数据库连接字符串 } } } else { XmlNode xsDBConnect = xmlIPDoc.SelectSingleNode("//sDBConnect"); if (xsDBConnect != null) { //YKDataClass .ConnectionString = FZYK .Com .YKSysCom .Decrypt(xsDBConnect .InnerText); YKDataClass.ConnectionString = xsDBConnect.InnerText; } else { XmlNode xDBConnect = xmlIPDoc.SelectSingleNode("//DBConnect"); if (xDBConnect != null) { YKDataClass.ConnectionString = xDBConnect.InnerText;//数据库连接字符串 } } } string sqlstr = "select * from IPRecord;select * from DBrecord order by id desc;select convert(char(10),getdate(),120); "; ds = YKDataClass.Query(sqlstr); if (ds.Tables.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["isReadOnly"] != null && ds.Tables[0].Rows[i]["isReadOnly"].ToString().Equals("1")) { ds.Tables[0].Rows[i]["ServerIP"] = ds.Tables[0].Rows[i]["ServerIP"] + "(ReadOnly)"; } } } #endregion } catch (Exception) { } return(ds); }