/// <summary>
/// 获取扫描之后的数据
/// </summary>
/// <returns></returns>
public static DataSourceClass GetData()
{
DataSourceClass data = new DataSourceClass();
DataSource source = new DataSource();
try
{
using (JDJS_Modules_Tool_Demands_DBEntities model = new JDJS_Modules_Tool_Demands_DBEntities())
{
var scan = model.ScanResultTable.FirstOrDefault();
if (scan != null)
{
if (scan.Type == "刀柄")
{
data.scanType = "扫描刀柄编号：";
data.scanResult = "扫描刀柄编号：" + scan.ScanResult;
source = model.DataSource.Where(r => r.HiltNum == scan.ScanResult).FirstOrDefault();
}
else if (scan.Type == "刀具")
{
data.scanType = "扫描刀具ID：";
data.scanResult = "扫描刀具ID：" + scan.ScanResult;
source = model.DataSource.Where(r => r.ToolId == scan.ScanResult).FirstOrDefault();
}
if (source != null)
{
data.ID = source.ID;
data.HiltNum = source.HiltNum == null ? "" : source.HiltNum;
data.HiltSpecification = source.HiltSpecification == null ? "" : source.HiltSpecification;
data.ToolCurrLife = source.ToolCurrLife == null ? "" : source.ToolCurrLife;
data.ToolId = source.ToolId == null ? "" : source.ToolId;
data.ToolJump = source.ToolJump == null ? "" : source.ToolJump;
data.ToolLength = source.ToolLength == null ? "" : source.ToolLength;
data.ToolMaxLife = source.ToolMaxLife == null ? "" : source.ToolMaxLife;
data.ToolName = source.ToolName == null ? "" : source.ToolName;
data.ToolRealR = source.ToolRealR == null ? "" : source.ToolRealR;
data.ToolSpecification = source.ToolSpecification == null ? "" : source.ToolSpecification;
data.ToolTheoryR = source.ToolTheoryR == null ? "" : source.ToolTheoryR;
}
}
}
}
catch (Exception ex)
{
}
return(data);
}
/// <summary>
/// 扫描的方法
/// </summary>
/// <param name="lpMsg">扫描的内容</param>
public static string ScanMethod(string lpMsg)
{
//lpRichTextBox.AppendText(lpMsg);
// MessageBox.Show(lpMsg, "结果");
if (lpMsg != null && lpMsg != "")
{
try
{
string type = "";
if (lpMsg.StartsWith("TS") || lpMsg.StartsWith("ts"))
{
type = "刀柄";
}
else
{
type = "刀具";
}
using (JDJS_Modules_Tool_Demands_DBEntities model = new JDJS_Modules_Tool_Demands_DBEntities())
{
var table = model.ScanResultTable;
if (table.Count() < 1)
{
ScanResultTable sc = new ScanResultTable()
{
ScanResult = lpMsg,
Type = type
};
using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction())
{
try
{
model.ScanResultTable.Add(sc);
model.SaveChanges();
mytran.Commit();
}
catch (Exception ex)
{
mytran.Rollback();
}
}
}
else
{
using (System.Data.Entity.DbContextTransaction mytran = model.Database.BeginTransaction())
{
try
{
foreach (var item in table)
{
item.ScanResult = lpMsg;
item.Type = type;
}
model.SaveChanges();
mytran.Commit();
}
catch (Exception ex)
{
mytran.Rollback();
}
}
}
}
lpMsg = "";
return("ok");
}
catch (Exception ex)
{
lpMsg = "";
return(ex.Message);
}
}
else
{
return("二维码内容错误：" + lpMsg);
}
}
