// static MagnaDBEntities db = new MagnaDBEntities();
/// <summary>
/// 用于打印普通打印单
/// </summary>
/// <param name="dtlist">要打印的list</param>
/// <param name="erweima">二维码</param>
/// <param name="id">名称</param>
/// <returns></returns>
public static bool PrintM(List <GetIndex> dtlist, string erweima, string id, string title, bool isdou = true)
{
string DateTimeNow;
// db = new MagnaDBEntities();
classes = px_MaterialsortprintingDAL.Querymg_classes().ToList();
List <PrintModel> list = new List <PrintModel>();
PrintClass t = new PrintClass();
bool flag = false;
OrderList oo = GetBtnClass.olst.FirstOrDefault(s => s.SortName == title);
foreach (var item in dtlist)
{
oo.wlprintindex = oo.wlprintindex + 1;
PrintModel pm = new PrintModel();
pm.序号 = oo.wlprintindex;
pm.车身号 = item.车身号.ToString();
pm.车型 = item.等级.ToString();
pm.主副驾 = item.主副驾.ToString();
pm.零件号 = item.零件号;
pm.数量 = "1";
list.Add(pm);
}
DataTable dt = null;
List <OrderList> ol = new List <OrderList>();
foreach (var item in GetBtnClass.BtnClassList)
{
OrderList o = new OrderList();
o.SortName = ToDataTable.getWLName(item.SortName);
o.Ascordesc = item.Ascordesc;
ol.Add(o);
}
bool flagAsc = ol.FirstOrDefault(s => s.SortName.Equals(title)).Ascordesc;
if (!flagAsc)
{
dt = ToDataTable.ListToDataTable(list.OrderBy(s => s.序号).ToList());
}
else
{
dt = ToDataTable.ListToDataTable(list.OrderByDescending(s => s.序号).ToList());
}
//if (id.IndexOf("前排")==-1)
//{
// dt.Columns.Remove("主副驾");
//}
var InternetPrinter = px_InternetPrinterDAL.QueryInternetPrinterListForPart().ToList();
for (int i = 0; i < InternetPrinter.Count; i++)
{
string name = InternetPrinter[i].IName.ToString();
string Role = InternetPrinter[i].IRole.ToString();//此打印机名称要与控制面板中打印名称一致
string[] Role2 = Role.Split(';');
foreach (string j in Role2)
{
string text = id;
if (j.Equals(text))
{
for (int k = 0; k < int.Parse(InternetPrinter[i].IRamark); k++)
{
flag = t.Print(dt, title, erweima, name);
}
}
}
}
if (flag && isdou)
{
string isprint_toStr = "";
List <mg_PartOrde> mg_PartOrde = px_MaterialsortprintingDAL.mg_PartOrde().ToList();
string aaa = "";
foreach (var item in dtlist)
{
px_PrintModel px = new px_PrintModel();
px.PXID = erweima;
px.orderid = item.车身号;
px.cartype = item.等级;
px.XF = item.主副驾;
px.LingjianHao = item.零件号;
px.sum = "1";
px.ordername = item.零件号描述;
px.dayintime = DateTime.Now;
px.printpxid = list.FirstOrDefault(s => s.主副驾 == item.主副驾 && s.车身号 == item.车身号 && s.零件号 == item.零件号).序号;
px_PrintDAL.Insertpx_Print(px);
//增加 相应生产线的物料打印后给mg_PartOrder表对应生产线数据行打印字段OrderIsPrint置1
//
System.Threading.Thread.Sleep(1);
DateTimeNow = DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + " " + DateTime.Now.TimeOfDay.ToString().Substring(0, 12);
//DateTime.Now.Hour + ":" + DateTime.Now.Minute + ":" + DateTime.Now.Second + "." + DateTime.Now.Millisecond;
isprint_toStr = mg_PartOrde.FirstOrDefault(s => s.id == item.PartOrderID.ToString()).OrderIsPrintSYS;
isprint_toStr = isprint_toStr + ";" + item.主副驾 + item.零件号描述;
string sql = "update mg_PartOrder set OrderIsPrintSYS='" + isprint_toStr
+ "' where ID ='" + item.PartOrderID + "' ";
SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, CommandType.Text, sql, null);
aaa += item.车身号 + " " + item.主副驾 + item.零件号描述 + " " + DateTimeNow + "\r\n";
if (!item.零件号描述.Equals("坐垫骨架") && !item.零件号描述.Equals("靠背骨架"))
{
string sql1 = "update mg_PartOrder set OrderIsPrint='1', OrderPrintTime='" + DateTimeNow
+ "' where ID ='" + item.PartOrderID + "' and OrderPrintTime is null ";
SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, CommandType.Text, sql1, null);
}
else
{//琉璃小屋
// db.Database.ExecuteSqlCommand("update mg_PartOrder set OrderIsPrint='1' where ID ='" + item.PartOrderID + "' and OrderPrintTime is null ");
}
}
}
return(flag);
}
public void AutoPrintSent_All()
{
//获取所有未打印集合
// var listindex = getmodel.GetListModels().Where(s => s.IsPrint == 0).ToList();
List <px_PanrameterModel> panrameter = null;
try
{
panrameter = px_PanrameterDAL.QueryPanrameterListForPart().ToList();
}
catch { Thread.Sleep(200); panrameter = px_PanrameterDAL.QueryPanrameterListForPart().ToList(); }
List <GetIndex> list = null;
var internetprintnamelist = px_InternetPrinterDAL.QueryInternetPrinterListForPart().ToList();
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "坐垫面套").IsAutoPrint == true)
{
WlFlag wf = boolflag.FirstOrDefault(s => s.name == "坐垫面套");
if (true)
{
wf.flag = false;
string erweima = getpara();
list = getmodel.GetIndexWJ("坐垫面套", "前排").ToList();
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "前排坐垫面套", ToDataTable.getWLName("坐垫面套", "前排"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "坐垫面套").IsAutoSend)
{
Send("前排坐垫面套", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "靠背面套").IsAutoPrint == true)
{
WlFlag wf = boolflag.FirstOrDefault(s => s.name == "靠背面套");
if (true)
{
wf.flag = false;
string erweima = getpara();
list = getmodel.GetIndexWJ("靠背面套", "前排");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "前排靠背面套", ToDataTable.getWLName("靠背面套", "前排"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "靠背面套").IsAutoSend)
{
Send("前排靠背面套", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "坐垫骨架").IsAutoPrint == true)
{
WlFlag wf = boolflag.FirstOrDefault(s => s.name == "坐垫骨架");
if (true)
{
wf.flag = false;
string erweima = getpara();
list = getmodel.GetIndexWJ("坐垫骨架", "前排");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "前排坐垫骨架", ToDataTable.getWLName("坐垫骨架", "前排"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "坐垫骨架").IsAutoSend)
{
Send("前排坐垫骨架", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "靠背骨架").IsAutoPrint == true)
{
if (true)
{
string erweima = getpara();
list = getmodel.GetIndexWJ("靠背骨架", "前排");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "前排靠背骨架", ToDataTable.getWLName("靠背骨架", "前排"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "靠背骨架").IsAutoSend)
{
Send("前排靠背骨架", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "线束").IsAutoPrint == true)
{
if (true)
{
string erweima = getpara();
list = getmodel.GetIndexWJ("线束", "前排");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "前排线束", ToDataTable.getWLName("线束", "前排"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "线束").IsAutoSend)
{
Send("前排线束", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "大背板").IsAutoPrint == true)
{
if (true)
{
string erweima = getpara();
list = getmodel.GetIndexWJ("大背板", "前排");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "前排大背板", ToDataTable.getWLName("大背板", "前排"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "大背板").IsAutoSend)
{
Send("前排大背板", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "40靠背").IsAutoPrint == true)
{
if (true)
{
string erweima = getpara();
list = getmodel.GetIndexWJ("靠背面套", "后40");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "后40靠背面套", ToDataTable.getWLName("靠背面套", "后40"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "40靠背").IsAutoSend)
{
Send("后40靠背面套", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "40侧头枕").IsAutoPrint == true)
{
if (true)
{
string erweima = getpara();
list = getmodel.GetIndexWJ("侧头枕", "后40");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "后40侧头枕", ToDataTable.getWLName("侧头枕", "后40"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "40侧头枕").IsAutoSend)
{
Send("后40侧头枕", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "后排中央扶手").IsAutoPrint == true)
{
if (true)
{
string erweima = getpara();
list = getmodel.GetIndexWJ("扶手", "后60");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "后60扶手", ToDataTable.getWLName("扶手", "后60"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "后排中央扶手").IsAutoSend)
{
Send("后60扶手", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "后排中央头枕").IsAutoPrint == true)
{
if (true)
{
string erweima = getpara();
list = getmodel.GetIndexWJ("中头枕", "后60");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "后60中头枕", ToDataTable.getWLName("中头枕", "后60"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "后排中央头枕").IsAutoSend)
{
Send("后60中头枕", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "60靠背").IsAutoPrint == true)
{
if (true)
{
string erweima = getpara();
list = getmodel.GetIndexWJ("靠背面套", "后60");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "后60靠背面套", ToDataTable.getWLName("靠背面套", "后60"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "60靠背").IsAutoSend)
{
Send("后60靠背面套", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "60侧头枕").IsAutoPrint == true)
{
if (true)
{
string erweima = getpara();
list = getmodel.GetIndexWJ("侧头枕", "后60");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "后60侧头枕", ToDataTable.getWLName("侧头枕", "后60"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "60侧头枕").IsAutoSend)
{
Send("后60侧头枕", erweima);
}
}
}
}
}
if (GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "后坐垫").IsAutoPrint == true)
{
if (true)
{
string erweima = getpara();
list = getmodel.GetIndexWJ("坐垫面套", "后坐垫");
list = Getmg_partorder_ordertype_ProcessData(list, -1);
if (list != null && list.Count >= 0)
{
if (list.Count > 0)
{
bool flag = CallPrint.PrintM(list, erweima, "后坐垫坐垫面套", ToDataTable.getWLName("坐垫面套", "后坐垫"));
if (flag && GetBtnClass.BtnClassList.FirstOrDefault(s => s.SortName == "后坐垫").IsAutoSend)
{
Send("后坐垫坐垫面套", erweima);
}
}
}
}
}
//int autocount = GetBtnClass.BtnClassList.Where(s => s.IsAutoPrint == true).ToList().Count();
//int wfcount = boolflag.Where(s => s.flag == false).ToList().Count();
//if (autocount == wfcount)
//{
// foreach (var item in boolflag)
// {
// item.flag = true;
// }
//}
}