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>
/// <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);
}
//public static string GetZheWangNextBarCode(List<OrderSet> orderSet, string modeID, All.Class.DataReadAndWrite conn)
//{
// string result = "";
//int StartX = 0;
//int EndX = 0;
//int orderIndex = orderSet.FindIndex(
// order =>
// {
// if (order.LenNingCode != modeID)
// {
// return false;
// }
// string sql = string.Format("select Top 1 LenNingCode from PrintLenNing where orderName='{0}' order by id Desc" ,order.OrderName);
// using (DataTable dt = conn.Read(sql))
// {
// if (dt != null && dt.Columns.Count > 0)
// {
// int index = All.Class.Num.ToInt(All.Class.Num.ToString(dt.Rows[0]["LenNingCode"]).Substring(startX, endX - startX + 1)) + 1;
// if (index >= start && index <= end)
// {
// result = code.Replace("".PadLeft(endX - startX + 1, '*'), string.Format(string.Format("{0}{1}{2}", "{0:D", endX - startX + 1, "}"), index));
// }
// else
// {
// result = code.Replace("".PadLeft(endX - startX + 1, '*'), string.Format(string.Format("{0}{1}{2}", "{0:D", endX - startX + 1, "}"), start));
// }
// }
// else
// {
// All.Class.Log.Add(string.Format("读取数据库失败\r\n读取语句 -> ", sql), Environment.StackTrace);
// }
// }
// return true;
// });
// return result;
//}
/// <summary>
/// 获取指定工位的下一条码
/// </summary>
/// <param name="orderSet"></param>
/// <param name="workIndex"></param>
/// <returns></returns>
public static string GetNextBarCode(OrderSet orderSet, int workIndex, All.Class.DataReadAndWrite conn)
{
if (orderSet.BoShi != "博世")
{
return("");
}
string result = ""; //返回结果
string columnName = ""; //查表的列名
string tableName = ""; //查询的表名
int startX = 0; //*号的开始位置
int endX = 0; //*号的结束位置
int start = 0; //条码的起始号
int end = 0; //条码的结束号
string code = ""; //条码号
switch (workIndex)
{
case 1:
columnName = "BarCode";
tableName = "PrintMachine";
startX = orderSet.BarCode.IndexOf('*');
endX = orderSet.BarCode.LastIndexOf('*');
code = orderSet.BarCode;
start = orderSet.BarStart;
end = orderSet.BarEnd;
break;
case 11:
columnName = "LenNingCode";
tableName = "PrintLenNing";
startX = orderSet.LenNingCode.IndexOf('*');
endX = orderSet.LenNingCode.LastIndexOf('*');
code = orderSet.LenNingCode;
start = orderSet.LenNingStart;
end = orderSet.LenNingEnd;
break;
}
string sql = string.Format("select {0} from {1} where orderName='{2}' order by {0}", columnName, tableName, orderSet.OrderName);
using (DataTable dt = conn.Read(sql))
{
if (dt != null && dt.Columns.Count > 0)
{
if (dt.Rows.Count > 0)
{
List <int> allOrderIndex = new List <int>(); //所有订单中要打印的序号
for (int i = start; i <= end; i++)
{
allOrderIndex.Add(i);
}
int index = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
index = All.Class.Num.ToInt(All.Class.Num.ToString(dt.Rows[i][columnName]).Substring(startX, endX - startX + 1));
if (allOrderIndex.Contains(index))
{
allOrderIndex.Remove(index); //从所有要打印的序号中移除已打印的序号
}
}
for (int i = 0; i < allOrderIndex.Count; i++)
{
if (allOrderIndex[i] >= start && allOrderIndex[i] <= end)
{
result = code.Replace("".PadLeft(endX - startX + 1, '*'), string.Format(string.Format("{0}{1}{2}", "{0:D", endX - startX + 1, "}"), allOrderIndex[i]));
break;
}
}
}
else
{
result = code.Replace("".PadLeft(endX - startX + 1, '*'), string.Format(string.Format("{0}{1}{2}", "{0:D", endX - startX + 1, "}"), start));
}
}
else
{
All.Class.Log.Add(string.Format("读取数据库失败\r\n读取语句 -> ", sql), Environment.StackTrace);
}
}
//DateTime now = DateTime.Now;
//result = result.ToUpper();
//result = result.Replace("YYYY", string.Format("{0:yyyy}", now));
//result = result.Replace("YY", string.Format("{0:yy}", now));
//result = result.Replace("MM", string.Format("{0:MM}", now));
//result = result.Replace("DD", string.Format("{0:dd}", now));
return(result); // = All.Class.Num.GetVisableHex(result);
}
/// <summary>
/// 从条码找到对应机型
/// </summary>
/// <param name="barCode"></param>
/// <param name="formatStr">已知的格式化字符串</param>
/// <returns></returns>
public static OrderSet GetOrder(string barCode, int workStation, string[] formatStr, All.Class.DataReadAndWrite conn)
{
OrderSet result = null;
if (formatStr == null || formatStr.Length <= 0)
{
All.Class.Log.Add("当前条码格式为空，无法查找对应的订单");
return(result);
}
//将条码还原为格式化的条码即 0000000000000000还原为0000-000-******-00000这种
string formatValue = "";
string orderBar = barCode;
for (int i = 0; i < formatStr.Length; i++)
{
if (All.Class.Num.GetVisableStr(formatStr[i]).Length == barCode.Length)
{
formatValue = formatStr[i];
break;
}
}
if (formatValue == "")
{
All.Class.Log.Add(string.Format("当前条码没有找到相应的条码格式\r\n当前条码 -> {0}", barCode), Environment.StackTrace);
return(result);
}
byte[] buff = Encoding.ASCII.GetBytes(formatValue);
int startX = -1;
int endX = -1;
for (int i = 0; i < buff.Length; i++)
{
if (buff[i] == Convert.ToByte('*'))
{
endX = i;
if (startX < 0)
{
startX = i;
}
continue;
}
//barCode = barCode.Insert(i, Encoding.ASCII.GetString(new byte[] { buff[i] }));
}
if (startX < 0 || endX < 0)
{
All.Class.Log.Add(string.Format("当前条码格式没有找到流水号的位置\r\n当前格式 -> {0}", formatValue), Environment.StackTrace);
return(result);
}
int index = All.Class.Num.ToInt(barCode.Substring(startX, endX - startX + 1));
orderBar = barCode.Substring(0, startX).PadRight(endX + 1, '*') + barCode.Substring(endX + 1);
//找数据库的条码源列
string sourceColumnName = "";
switch (workStation)
{
case 1:
case 2:
case 3:
case 4:
case 5:
case 6:
case 7:
case 8:
case 9:
case 10:
sourceColumnName = "BarCode";
break;
case 11:
sourceColumnName = "LenNingCode";
break;
}
using (DataTable dt = conn.Read(string.Format("select * from SetOrder where {0}='{1}'", sourceColumnName, orderBar)))
{
if (dt != null && dt.Rows.Count > 0)
{
int start = 0;
int end = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
start = All.Class.Num.ToInt(dt.Rows[i]["BarStart"]);
end = All.Class.Num.ToInt(dt.Rows[i]["BarEnd"]);
if (start <= index && index <= end)
{
result = new OrderSet();
result.OrderName = All.Class.Num.ToString(dt.Rows[i]["OrderName"]);
result.LenNingCode = All.Class.Num.GetVisableStr(All.Class.Num.ToString(dt.Rows[i]["LenNingCode"]));
result.LenNingStart = All.Class.Num.ToInt(dt.Rows[i]["LenNingStart"]);
result.LenNingEnd = All.Class.Num.ToInt(dt.Rows[i]["LenNingEnd"]);
result.BarCode = All.Class.Num.GetVisableStr(All.Class.Num.ToString(dt.Rows[i]["BarCode"]));
result.BarStart = All.Class.Num.ToInt(dt.Rows[i]["BarStart"]);
result.BarEnd = All.Class.Num.ToInt(dt.Rows[i]["BarEnd"]);
result.OrderTime = All.Class.Num.ToDateTime(dt.Rows[i]["OrderTime"]);
result.OrderYear = All.Class.Num.ToInt(dt.Rows[i]["OrderYear"]);
result.OrderMonth = All.Class.Num.ToInt(dt.Rows[i]["OrderMonth"]);
result.OrderDay = All.Class.Num.ToInt(dt.Rows[i]["OrderDay"]);
result.PrintFile = All.Class.Num.GetVisableStr(All.Class.Num.ToString(dt.Rows[i]["PrintFile"]));
result.BoShi = All.Class.Num.ToString(dt.Rows[i]["BoShi"]);
break;
}
}
}
}
return(result);
}
/// <summary>
/// 删除订单
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public static bool DeleteOrder(OrderSet order, All.Class.DataReadAndWrite conn)
{
return(conn.Write(string.Format("delete from SetOrder where OrderName='{0}'", order.OrderName)) == 1);
}