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