private static List <OrderSet> GetOrder(All.Class.DataReadAndWrite conn, string sql)
{
List <OrderSet> result = new List <OrderSet>();
using (DataTable dt = conn.Read(sql))
{
if (dt != null && dt.Rows.Count > 0)
{
OrderSet tmpOrder;
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpOrder = new OrderSet();
tmpOrder.OrderName = All.Class.Num.ToString(dt.Rows[i]["OrderName"]);
tmpOrder.LenNingCode = All.Class.Num.GetVisableStr(All.Class.Num.ToString(dt.Rows[i]["LenNingCode"]));
tmpOrder.LenNingStart = All.Class.Num.ToInt(dt.Rows[i]["LenNingStart"]);
tmpOrder.LenNingEnd = All.Class.Num.ToInt(dt.Rows[i]["LenNingEnd"]);
tmpOrder.BarCode = All.Class.Num.GetVisableStr(All.Class.Num.ToString(dt.Rows[i]["BarCode"]));
tmpOrder.BarStart = All.Class.Num.ToInt(dt.Rows[i]["BarStart"]);
tmpOrder.BarEnd = All.Class.Num.ToInt(dt.Rows[i]["BarEnd"]);
tmpOrder.OrderTime = All.Class.Num.ToDateTime(dt.Rows[i]["OrderTime"]);
tmpOrder.OrderYear = All.Class.Num.ToInt(dt.Rows[i]["OrderYear"]);
tmpOrder.OrderMonth = All.Class.Num.ToInt(dt.Rows[i]["OrderMonth"]);
tmpOrder.OrderDay = All.Class.Num.ToInt(dt.Rows[i]["OrderDay"]);
tmpOrder.PrintFile = All.Class.Num.GetVisableStr(All.Class.Num.ToString(dt.Rows[i]["PrintFile"]));
tmpOrder.BoShi = All.Class.Num.ToString(dt.Rows[i]["BoShi"]);
result.Add(tmpOrder);
}
}
}
return(result);
}
/// <summary>
/// 加载数据库连接
/// </summary>
public void Load()
{
string dataFile = string.Format("{0}\\Data\\DataConnect.Mdb", All.Class.FileIO.GetNowPath());
LocalData = All.Class.DataReadAndWrite.GetData(dataFile, "LocalData");
ReportData = All.Class.DataReadAndWrite.GetData(dataFile, "ReportData");
ReadData = All.Class.DataReadAndWrite.GetData(dataFile, "ReadData");
WriteData = All.Class.DataReadAndWrite.GetData(dataFile, "WriteData");
DataBarCode = All.Class.DataReadAndWrite.GetData(dataFile, "BarCode");
TestTimeData.Login(".\\Data\\", "TodayTestTime.mdb", "", "");
Local = new HeiFeiMideaDll.cDataLocal();
Local.LocalData = LocalData;
Local.ReadData = ReadData;
Local.WriteData = WriteData;
Read = new cDataRead(ReadData);
Write = new cDataWrite(WriteData);
All.Class.DataReadAndWrite tmp = All.Class.DataReadAndWrite.GetData(dataFile, "TmpData");
RemotUpdate();
}
/// <summary>
/// 保存故障
/// </summary>
/// <param name="allErrorStation"></param>
/// <param name="conn"></param>
public static bool Save(List <ErrorStation> allErrorStation, All.Class.DataReadAndWrite conn)
{
bool result = false;
int count = 0;
ClearStation(conn);
if (allErrorStation != null)
{
allErrorStation.ForEach(//工位
errorStation =>
{
if (errorStation.ErrorEnum != null)
{
errorStation.ErrorEnum.ForEach( //分类
errorEnum => {
if (conn.Write(string.Format("insert into SetErrorStation (Station,ErrorFather) values ({0},'{1}')",
errorStation.WorkStation, errorEnum.Value)) >= 1)
{
count++;
}
});
}
});
}
if (count > 0)
{
result = true;
}
return(result);
}
public static cNiuJu Read(bool yaSuoJi, bool fengJi, int chengXuHao, All.Class.DataReadAndWrite conn)
{
cNiuJu result = new cNiuJu();
using (DataTable dt = conn.Read(string.Format("select * from SetNiuJu where YaSuoJi='{0}'and FengJi='{1}' and ChengXuHao={2} order by ID", yaSuoJi, fengJi, chengXuHao)))
{
if (dt != null && dt.Rows.Count > 0)
{
result.YaSuoJi = yaSuoJi;
result.FengJi = fengJi;
result.ChengXuHao = chengXuHao;
result.BackImage = All.Class.Num.ToString(dt.Rows[0]["BackImage"]);
result.BackWidth = All.Class.Num.ToInt(dt.Rows[0]["BackWidth"]);
result.BackHeight = All.Class.Num.ToInt(dt.Rows[0]["BackHeight"]);
result.Info = All.Class.Num.ToString(dt.Rows[0]["Info"]);
for (int i = 0; i < dt.Rows.Count; i++)
{
System.Drawing.Rectangle r = new System.Drawing.Rectangle();
r.X = All.Class.Num.ToInt(dt.Rows[i]["SonLeft"]);
r.Y = All.Class.Num.ToInt(dt.Rows[i]["SonTop"]);
r.Width = All.Class.Num.ToInt(dt.Rows[i]["SonWidth"]);
r.Height = All.Class.Num.ToInt(dt.Rows[i]["SonHeight"]);
result.Sons.Add(r);
}
}
}
return(result);
}
public ZheWang(All.Class.DataReadAndWrite SQL)
{
sql = SQL;
dtZheWang = sql.Read("Select * from StatueZheWang");
dtZheWang.TableName = "StatueZheWang";
Data2Class(true);
}
/// <summary>
/// 将机型保存到数据库
/// </summary>
/// <param name="mode"></param>
/// <returns></returns>
public static bool Save(ModeZheWangSet mode, All.Class.DataReadAndWrite Conn)
{
Delete(mode.ID, Conn);
//字符串
string sql = "insert into SetZheWang ({0}) values ({1})";
string title = "ModeId,Mode,ModeInfo {0}{1}{2}";
string value = "'{0}','{1}','{2}'{3}{4}{5}";
//标题
string playFile = ",PlayFile1";
string start = ",Start1";
string end = ",End1";
title = string.Format(title, playFile, start, end);
//值
playFile = string.Format(",'{0}'", mode.PlayFile);
start = string.Format(",{0}", mode.Start);
end = string.Format(",{0}", mode.End);
value = string.Format(value, mode.ID, mode.Mode, mode.Info, playFile, start, end);
//组合后写入数据库
sql = string.Format(sql, title, value);
return(Conn.Write(sql) == 1);
}
public cData()
{
if (!System.IO.Directory.Exists(string.Format("{0}\\Data\\", All.Class.FileIO.GetNowPath())))
{
System.IO.Directory.CreateDirectory(string.Format("{0}\\Data\\", All.Class.FileIO.GetNowPath()));
}
TestTimeData = new All.Class.Access();
}
public void Flush(All.Class.DataReadAndWrite conn)
{
bool readOne = false;
bool readTwo = false;
bool readThree = false;
if (frmMain.mMain.AllDataXml.LocalSettings.TestNo == 2 ||
frmMain.mMain.AllDataXml.LocalSettings.TestNo == 7)
{
using (DataTable dt = conn.Read("select LuoSi as AllCount,Space from StatueNiuJu order by Space"))
{
if (dt != null && dt.Rows.Count > 0)
{
int index = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
index = All.Class.Num.ToInt(dt.Rows[i]["Space"]);
switch (index)
{
case 0:
CountOne = All.Class.Num.ToInt(dt.Rows[i]["AllCount"]);
readOne = true;
break;
case 1:
CountTwo = All.Class.Num.ToInt(dt.Rows[i]["AllCount"]);
readTwo = true;
break;
case 2:
CountThree = All.Class.Num.ToInt(dt.Rows[i]["AllCount"]);
readThree = true;
break;
}
//if ((frmMain.mMain.AllDataXml.LocalSettings.TestNo == 2 && index == 0)
// || (frmMain.mMain.AllDataXml.LocalSettings.TestNo == 7 && index == 1)
// || (frmMain.mMain.AllDataXml.LocalSettings.TestNo == 7 && index == 2))
//{
// SetCount(index, All.Class.Num.ToInt(dt.Rows[i]["AllCount"]));
//}
}
}
}
}
if (!readOne)
{
CountOne = 0;
}
if (!readTwo)
{
CountTwo = 0;
}
if (!readThree)
{
CountThree = 0;
}
}
/// <summary>
/// 获取指定工位故障
/// </summary>
/// <param name="workStation"></param>
/// <returns></returns>
public static List <ErrorStation> GetError(int workStation, All.Class.DataReadAndWrite conn)
{
List <ErrorStation> error = new List <ErrorStation>();
ErrorStation tmpStation;
ErrorEnum tmpErrorEnum;
int station = 0;
string errorEnum = "";
int stationIndex = 0;
int errorEnumIndex = 0;
string sql = "select Station,Error from V_ErrorStation";
if (workStation > 0)
{
sql = string.Format("{0} where Station={1}", sql, workStation);
}
sql = string.Format("{0} order by Station,Error", sql);
using (DataTable dt = conn.Read(sql))
{
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
station = All.Class.Num.ToInt(dt.Rows[i]["Station"]);
errorEnum = All.Class.Num.ToString(dt.Rows[i]["Error"], "");
//查找是否已添加当前工位
stationIndex = error.FindIndex(
tmp =>
{
return(tmp.WorkStation == station);
});
if (stationIndex < 0)//添加一个工位数据
{
tmpStation = new ErrorStation();
tmpStation.WorkStation = station;
error.Add(tmpStation);
stationIndex = error.Count - 1;
}
//查找是否有当前故障分类
errorEnumIndex = error[stationIndex].ErrorEnum.FindIndex(
tmp =>
{
return(tmp.Value == errorEnum);
});
if (errorEnumIndex < 0)//添加一个故障分类
{
tmpErrorEnum = new ErrorEnum();
tmpErrorEnum.Value = errorEnum;
error[stationIndex].ErrorEnum.Add(tmpErrorEnum);
errorEnumIndex = error[stationIndex].ErrorEnum.Count - 1;
}
}
}
}
return(error);
}
/// <summary>
/// 根据订单名称得到订单设置
/// </summary>
/// <param name="orderName"></param>
/// <param name="conn"></param>
/// <returns></returns>
public static OrderSet GetOrder(string orderName, All.Class.DataReadAndWrite conn)
{
List <OrderSet> result = GetOrder(conn, string.Format("select * from SetOrder Where OrderName='{0}'", orderName));
if (result == null || result.Count <= 0)
{
return(null);
}
return(result[0]);
}
/// <summary>
/// 插入订单
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public static bool InsertOrder(OrderSet order, All.Class.DataReadAndWrite conn)
{
string sql = "insert into SetOrder ({0}) values ({1})";
string title = "OrderName,BarCode,BarStart,BarEnd,LenNingCode,LenNingStart,LenNingEnd,PrintFile,OrderTime,OrderYear,OrderMonth,OrderDay,BoShi";
string value = string.Format("'{0}','{1}',{2},{3},'{4}',{5},{6},'{7}','{8:yyyy-MM-dd HH:mm:ss}',{9},{10},{11},'{12}'",
order.OrderName, order.BarCode, order.BarStart, order.BarEnd, order.LenNingCode, order.LenNingStart, order.BarEnd,
order.PrintFile, order.OrderTime, order.OrderYear, order.OrderMonth, order.OrderDay, order.BoShi);
return(conn.Write(string.Format(sql, title, value)) == 1);
}
/// <summary>
/// 插入用户
/// </summary>
/// <param name="userName"></param>
/// <param name="passWord"></param>
/// <returns></returns>
public static bool InsertUser(LengNinUser user, All.Class.DataReadAndWrite conn)
{
string tmpUse = "";
for (int i = 0; i < user.Use.Length; i++)
{
tmpUse = string.Format("{0},'{1}'", tmpUse, user.Use[i]);
}
return(conn.Write(string.Format("insert into SetUsersLengNin values('{0}','{1}','{2:yyyy-MM-dd HH:mm:ss}'{3})",
user.Text, user.Word, DateTime.Now, tmpUse)) >= 1);
}
/// <summary>
/// 保存所有对应关系
/// </summary>
/// <param name="allMode"></param>
/// <param name="conn"></param>
/// <returns></returns>
public static bool SaveAllMode(Dictionary <string, BoShiValue> allMode, All.Class.DataReadAndWrite conn)
{
bool result = true;
allMode.Keys.ToList().ForEach(
mode =>
{
conn.Write(string.Format("delete from SetMideaToBoshi where Midea='{0}'", mode));
result = (result && (conn.Write(string.Format("insert into SetMideaToBoShi values('{0}','{1}','{2}')", mode, allMode[mode].ID, allMode[mode].Mode)) == 1));
});
return(result);
}
/// <summary>
/// 保存所有故障源
/// </summary>
/// <param name="allErrorFrom"></param>
/// <returns></returns>
public static bool SaveAllErrorFrom(List <ErrorFrom> allErrorFrom, All.Class.DataReadAndWrite conn)
{
bool result = true;
WriteAllErrorFrom(conn);
allErrorFrom.ForEach(
errorFrom =>
{
result = result && (conn.Write(string.Format("insert into SetErrorFrom (ErrorFrom) Values ('{0}')", errorFrom.Text)) == 1);
});
return(result);
}
public bool Save(All.Class.DataReadAndWrite conn)
{
bool result = true;
conn.Write(string.Format("delete from SetNiuJu Where YaSuoJi='{0}'and FengJi='{1}' and ChengXuHao={2}",
YaSuoJi, FengJi, ChengXuHao));
for (int i = 0; i < Sons.Count; i++)
{
result = result && (conn.Write(string.Format("insert into SetNiuJu (YaSuoJi,FengJi,ChengXuHao,Info,BackImage,BackWidth,BackHeight,SonLeft,SonTop,SonWidth,SonHeight) Values ('{0}','{1}',{2},'{3}','{4}',{5},{6},{7},{8},{9},{10})",
YaSuoJi, FengJi, ChengXuHao, Info, BackImage, BackWidth, BackHeight, Sons[i].Left, Sons[i].Top, Sons[i].Width, Sons[i].Height)) == 1);
}
return(result);
}
/// <summary>
/// 保存订单
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public static bool SaveOrder(List <OrderSet> order, All.Class.DataReadAndWrite conn)
{
bool result = true;
order.ForEach(
tmpOrder =>
{
DeleteOrder(tmpOrder, conn);
result &= InsertOrder(tmpOrder, conn);
});
return(result);
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
public static bool Save(List <InfoLengNin> infoLengNin, All.Class.DataReadAndWrite conn)
{
bool result = true;
if (infoLengNin != null)
{
for (int i = 0; i < infoLengNin.Count; i++)
{
result = result & (conn.Write(string.Format("update InfoLengNinStation Set StationName='{0}',TestStation='{1}',TimeOut={2} where WorkStation={3}", infoLengNin[i].StationName, infoLengNin[i].TestStation, infoLengNin[i].TimeOut, infoLengNin[i].WorkStation)) == 1);
}
}
return(result);
}
/// <summary>
/// 保存故障列表
/// </summary>
/// <param name="allErrorEnum"></param>
/// <param name="conn"></param>
public static bool Save(List <ErrorEnum> allErrorEnum, All.Class.DataReadAndWrite conn)
{
bool result = false;
int count = 0;
ClearEnum(conn);
if (allErrorEnum != null)
{
allErrorEnum.ForEach(
errorEnum =>
{
if (conn.Write(string.Format("insert into SetErrorFather (Error) values ('{0}')", errorEnum.Value)) >= 1)
{
count++;
}
if (errorEnum.Errors != null)
{
errorEnum.Errors.ForEach( //故障名称
error =>
{
if (conn.Write(string.Format("insert into SetError (Error,FatherID) values ('{0}','{1}')",
error.Value, errorEnum.Value)) >= 1)
{
count++;
}
if (error.ErrorFrom != null)
{
error.ErrorFrom.ForEach( //故障来源
errorFrom =>
{
if (conn.Write(string.Format("insert into SetErrorSon (Error,FatherID) values ('{0}','{1}')",
errorFrom.Value, error.Value)) >= 1)
{
count++;
}
});
}
});
}
});
}
if (count > 0)
{
result = true;
}
return(result);
}
public static string[] AllYaSuoJi(All.Class.DataReadAndWrite conn)
{
List <string> result = new List <string>();
using (DataTable dt = conn.Read("select DISTINCT ChengXuHao,Info from SetNiuJu where YaSuoJi='True'"))
{
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
result.Add(string.Format("{0}#程序->{1}", dt.Rows[i]["ChengXuHao"], dt.Rows[i]["info"]));
}
}
}
return(result.ToArray());
}
/// <summary>
/// 获取所有故障源
/// </summary>
/// <param name="conn"></param>
/// <returns></returns>
public static List <ErrorFrom> GetAllErrorFrom(All.Class.DataReadAndWrite conn)
{
List <ErrorFrom> result = new List <ErrorFrom>();
using (DataTable dt = conn.Read("select ErrorFrom from SetErrorFrom"))
{
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
result.Add(new ErrorFrom(All.Class.Num.ToString(dt.Rows[i]["ErrorFrom"])));
}
}
}
return(result);
}
/// <summary>
/// 获取所有订单名称
/// </summary>
/// <param name="conn"></param>
/// <returns></returns>
public static List <string> GetOrder(All.Class.DataReadAndWrite conn)
{
List <string> result = new List <string>();
using (DataTable dt = conn.Read(string.Format("select OrderName From SetOrder Order by OrderTime desc")))
{
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
result.Add(All.Class.Num.ToString(dt.Rows[i]["OrderName"]));
}
}
}
return(result);
}
/// <summary>
/// 加载数据库连接
/// </summary>
public void Load()
{
int start = Environment.TickCount;
string dataFile = string.Format("{0}\\Data\\DataConnect.Mdb", All.Class.FileIO.GetNowPath());
FlushData = All.Class.DataReadAndWrite.GetData(dataFile, "FlushData");
Local = new HeiFeiMideaDll.cDataLocal(FlushData);
if (frmMain.mMain.AllDataXml.LocalSettings.TestNo == 1)
{
DataBarCode = All.Class.DataReadAndWrite.GetData(dataFile, "BarCode");
}
if (frmMain.mMain.AllDataXml.LocalSettings.TestNo == 11)
{
LenNingQi = All.Class.DataReadAndWrite.GetData(dataFile, "LenNingQi");
}
}
///// <summary>
///// 机型转化为可传递的字符串
///// </summary>
///// <returns></returns>
//public string ClassToStr()
//{
// Dictionary<string, string> buff = new Dictionary<string, string>();
// buff.Add("ID", this.ID);
// buff.Add("Mode", this.Mode);
// buff.Add("Info", this.Info);
// buff.Add("PlayFile1", PlayFile);
// buff.Add("Star1", Start.ToString());
// buff.Add("End1", End.ToString());
// return All.Class.SSFile.Dictionary2Text(buff);
//}
///// <summary>
///// 字符串还原为机型
///// </summary>
///// <param name="str"></param>
///// <returns></returns>
//public static ModeZheWangSet StrToClass(string str)
//{
// ModeZheWangSet result = new ModeZheWangSet();
// Dictionary<string, string> buff = All.Class.SSFile.Text2Dictionary(str);
// result.ID = buff["ID"];
// result.Mode = buff["Mode"];
// result.Info = buff["Info"];
// result.PlayFile = buff["PlayFile1"];
// result.Start = All.Class.Num.ToInt(buff["Start1"]);
// result.End = All.Class.Num.ToInt(buff["End1"]);
// return result;
//}
#endregion
/// <summary>
/// 根据机型ID得到机型
/// </summary>
/// <param name="modeID"></param>
/// <returns></returns>
public static ModeZheWangSet GetMode(string modeID, All.Class.DataReadAndWrite Conn)
{
ModeZheWangSet result = new ModeZheWangSet();
using (DataTable dt = Conn.Read(string.Format("select * from SetZheWang where ModeID='{0}'", modeID)))
{
if (dt != null && dt.Rows.Count >= 1)
{
result.ID = All.Class.Num.ToString(dt.Rows[0]["ModeID"]);
result.Mode = All.Class.Num.ToString(dt.Rows[0]["Mode"]);
result.Info = All.Class.Num.ToString(dt.Rows[0]["ModeInfo"]);
result.PlayFile = All.Class.Num.ToString(dt.Rows[0]["PlayFile1"]);
result.Start = All.Class.Num.ToInt(dt.Rows[0]["Start1"]);
result.End = All.Class.Num.ToInt(dt.Rows[0]["End1"]);
}
}
return(result);
}
/// <summary>
/// 获取所有机型
/// </summary>
/// <returns></returns>
public static List <ModeSet> GetModeList(All.Class.DataReadAndWrite Conn)
{
List <ModeSet> result = new List <ModeSet>();
using (DataTable dt = Conn.Read("select ModeID,Mode,ModeInfo from SetMode order by ID desc"))
{
if (dt != null && dt.Rows.Count > 0)
{
ModeSet tmpModeSet;
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpModeSet = new ModeSet();
tmpModeSet.ID = All.Class.Num.ToString(dt.Rows[i]["ModeID"]);
tmpModeSet.Mode = All.Class.Num.ToString(dt.Rows[i]["Mode"]);
tmpModeSet.Info = All.Class.Num.ToString(dt.Rows[i]["ModeInfo"]);
result.Add(tmpModeSet);
}
}
}
return(result);
}
/// <summary>
/// 获取所有美的与博世机型对应
/// </summary>
/// <param name="conn"></param>
/// <returns></returns>
public static Dictionary <string, BoShiValue> GetAllMode(All.Class.DataReadAndWrite conn)
{
Dictionary <string, BoShiValue> result = new Dictionary <string, BoShiValue>();
string midea = "";
BoShiValue boshi = new BoShiValue("", "");
using (DataTable dt = conn.Read("select * from SetMideaToBoShi Order by BoShi"))
{
for (int i = 0; i < dt.Rows.Count; i++)
{
midea = All.Class.Num.ToString(dt.Rows[i]["Midea"]);
boshi = new BoShiValue(All.Class.Num.ToString(dt.Rows[i]["BoSHi"]),
All.Class.Num.ToString(dt.Rows[i]["BoShiJiXing"]));
if (!result.ContainsKey(midea))
{
result.Add(midea, boshi);
}
}
}
return(result);
}
/// <summary>
/// 从数据库加载设置数据
/// </summary>
/// <param name="conn"></param>
public static List <InfoLengNin> Load(All.Class.DataReadAndWrite conn)
{
List <InfoLengNin> result = new List <InfoLengNin>();
InfoLengNin tmp;
using (DataTable dt = conn.Read("select WorkStation,StationName,TestStation,TimeOut,UserName from InfoLengNinStation order by WorkStation"))
{
if (dt != null && dt.Rows.Count == HeiFeiMideaDll.cMain.AllLengNinQiCount)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmp = new InfoLengNin(All.Class.Num.ToInt(dt.Rows[i]["WorkStation"]));
tmp.StationName = All.Class.Num.ToString(dt.Rows[i]["StationName"]);
tmp.TestStation = All.Class.Num.ToBool(dt.Rows[i]["TestStation"]);
tmp.TimeOut = All.Class.Num.ToInt(dt.Rows[i]["TimeOut"]);
tmp.UserName = All.Class.Num.ToString(dt.Rows[i]["UserName"]);
result.Add(tmp);
}
}
}
return(result);
}
/// <summary>
/// 从文本文件中反射数据库连接
/// </summary>
/// <param name="fileName">文本文件位置</param>
/// <param name="text">数据描述文本</param>
/// <returns></returns>
public static DataReadAndWrite GetData(string fileName, string text)
{
All.Class.DataReadAndWrite result = null;
XmlNode tmpNode = All.Class.XmlHelp.GetXmlNode(fileName);
foreach (XmlNode tmpConn in tmpNode.ChildNodes)
{
if (tmpConn.NodeType != XmlNodeType.Element)
{
continue;
}
Dictionary <string, string> connAttribute = All.Class.XmlHelp.GetAttribute(tmpConn);
if (connAttribute.ContainsKey("Name") && connAttribute["Name"] == text)
{
try
{
Dictionary <string, string> connStr = All.Class.XmlHelp.GetInner(tmpConn);
All.Class.Reflex <All.Class.DataReadAndWrite> r = new All.Class.Reflex <All.Class.DataReadAndWrite>("All", connAttribute["Class"]);
result = (All.Class.DataReadAndWrite)r.Get();
if (result != null && connAttribute.ContainsKey("Text"))
{
result.Text = connAttribute["Text"];
}
if (!result.Login(connStr["Address"], connStr["DataBase"], connStr["UserName"], connStr["Password"]))
{
All.Class.Error.Add(string.Format("{0}:数据库登陆失败,请检查数据库连接", result.Text), Environment.StackTrace);
}
}
catch (Exception e)
{
All.Class.Error.Add(e);
}
break;
}
}
return(result);
}
///// <summary>
///// 机型转化为可传递的字符串
///// </summary>
///// <returns></returns>
//public string ClassToStr()
//{
// Dictionary<string, string> buff = new Dictionary<string, string>();
// buff.Add("ID", this.ID);
// buff.Add("Mode", this.Mode);
// buff.Add("Info", this.Info);
// for (int i = 0; i < PlayFile.Length; i++)
// {
// buff.Add(string.Format("PlayFile{0}", i + 1), PlayFile[i]);
// buff.Add(string.Format("Start{0}", i + 1), Start[i].ToString());
// buff.Add(string.Format("End{0}", i + 1), End[i].ToString());
// }
// for (int i = 0; i < YaSuoJiID.Length; i++)
// {
// buff.Add(string.Format("YaSuoJiID{0}", i + 1), YaSuoJiID[i]);
// }
// return All.Class.SSFile.Dictionary2Text(buff);
//}
///// <summary>
///// 字符串还原为机型
///// </summary>
///// <param name="str"></param>
///// <returns></returns>
//public static ModeSet StrToClass(string str)
//{
// ModeSet result = new ModeSet();
// Dictionary<string, string> buff = All.Class.SSFile.Text2Dictionary(str);
// result.ID = buff["ID"];
// result.Mode = buff["Mode"];
// result.Info = buff["Info"];
// for (int i = 0; i < result.PlayFile.Length; i++)
// {
// result.PlayFile[i] = buff[string.Format("PlayFile{0}", i + 1)];
// result.Start[i] = All.Class.Num.ToInt(buff[string.Format("Start{0}", i + 1)]);
// result.End[i] = All.Class.Num.ToInt(buff[string.Format("End{0}", i + 1)]);
// }
// for (int i = 0; i < result.YaSuoJiID.Length; i++)
// {
// result.YaSuoJiID[i] = buff[string.Format("YaSuoJiID{0}", i + 1)];
// }
// return result;
//}
#endregion
/// <summary>
/// 根据机型ID得到机型
/// </summary>
/// <param name="modeID"></param>
/// <returns></returns>
public static ModeSet GetMode(string modeID, All.Class.DataReadAndWrite Conn)
{
ModeSet result = new ModeSet();
using (DataTable dt = Conn.Read(string.Format("select * from SetMode where ModeID='{0}'", modeID)))
{
if (dt != null && dt.Rows.Count >= 1)
{
result.ID = All.Class.Num.ToString(dt.Rows[0]["ModeID"]);
result.Mode = All.Class.Num.ToString(dt.Rows[0]["Mode"]);
result.Info = All.Class.Num.ToString(dt.Rows[0]["ModeInfo"]);
for (int i = 0; i < HeiFeiMideaDll.cMain.AllTestComputer; i++)
{
result.PlayFile[i] = All.Class.Num.ToString(dt.Rows[0][string.Format("PlayFile{0}", i + 1)]);
result.Start[i] = All.Class.Num.ToInt(dt.Rows[0][string.Format("Start{0}", i + 1)]);
result.End[i] = All.Class.Num.ToInt(dt.Rows[0][string.Format("End{0}", i + 1)]);
}
for (int i = 0; i < result.YaSuoJiID.Length; i++)
{
result.YaSuoJiID[i] = All.Class.Num.ToString(dt.Rows[0][string.Format("YaSuoJiID{0}", i + 1)]);
}
for (int i = 0; i < result.StrBar.Length; i++)
{
result.StrBar[i] = All.Class.Num.ToString(dt.Rows[0][string.Format("StrBar{0}", i + 1)]);
}
result.NiuJuIDOne = All.Class.Num.ToInt(dt.Rows[0]["NiuJuID1"]);
result.NiuJuIDTwo = All.Class.Num.ToInt(dt.Rows[0]["NiuJuID2"]);
result.MachineID = All.Class.Num.ToInt(dt.Rows[0]["MachineID"]);
for (int i = 0; i < result.FengJiID.Length; i++)
{
result.FengJiID[i] = All.Class.Num.ToString(dt.Rows[0][string.Format("FengJiID{0}", i + 1)]);
}
result.DianKongID = All.Class.Num.ToString(dt.Rows[0]["DianKongID"]);
result.ZheWangID = All.Class.Num.ToString(dt.Rows[0]["ZheWangID"]);
}
}
return(result);
}
/// <summary>
/// 获取用户名设置
/// </summary>
/// <returns></returns>
public static List <LengNinUser> GetAllUser(All.Class.DataReadAndWrite conn)
{
List <LengNinUser> user = new List <LengNinUser>();
LengNinUser tmpUserSet;
using (DataTable dt = conn.Read("select * from SetUsersLengNin order by InTime"))
{
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpUserSet = new LengNinUser();
tmpUserSet.Text = All.Class.Num.ToString(dt.Rows[i]["UserName"]);
tmpUserSet.Word = All.Class.Num.ToString(dt.Rows[i]["UserPassword"]);
for (int j = 0; j < cMain.AllLengNinQiCount; j++)
{
tmpUserSet.Use[j] = All.Class.Num.ToBool(dt.Rows[i][string.Format("use{0}", j)]);
}
user.Add(tmpUserSet);
}
}
}
return(user);
}
/// <summary>
/// 获取已返修完成的故障
/// </summary>
/// <returns></returns>
public static List <TestError> GetTestOverError(All.Class.DataReadAndWrite conn)
{
List <TestError> result = new List <TestError>();
TestError testError;
using (DataTable dt = conn.Read(string.Format("select * from StatueError where Repair='true'")))
{
for (int i = 0; i < dt.Rows.Count; i++)
{
testError = new TestError();
testError.Barcode = All.Class.Num.ToString(dt.Rows[i]["Barcode"]);
testError.Error = All.Class.Num.ToString(dt.Rows[i]["Error"]);
testError.ErrorNum = All.Class.Num.ToInt(dt.Rows[i]["ErrorNum"]);
testError.ErrorTime = All.Class.Num.ToDateTime(dt.Rows[i]["ErrorTime"]);
testError.Repair = All.Class.Num.ToBool(dt.Rows[i]["Repair"]);
testError.RepairTime = All.Class.Num.ToDateTime(dt.Rows[i]["RepairTime"]);
testError.WorkStation = All.Class.Num.ToInt(dt.Rows[i]["WorkStation"]);
testError.ErrorFrom = All.Class.Num.ToString(dt.Rows[i]["ErrorFrom"]);
testError.ErrorSpace = All.Class.Num.ToInt(dt.Rows[i]["ErrorSpace"]);
result.Add(testError);
}
}
return(result);
}
