/// <summary>
/// 添加批量追溯信息
/// </summary>
private void GetBatchInfoToModel()
{
#region 添加批量追溯信息
if (RemoteMaterialHT != null && RemoteMaterialHT.Count > 0)
{
LocalMaterialHT.Clear();
foreach (DictionaryEntry item in RemoteMaterialHT) // 遍历哈希表
{
//从数据库获取当前批次材料信息
BatchNoMDL model = batchDAL.GetModel(string.Format("MaterialCode='{0}'", item.Key.ToString()));
LocalMaterialHT.Add(item.Key.ToString(), model);
//获取更新的字段
materialFieldModel = materialFieldDAL.GetModel(string.Format("materialcode='{0}'", item.Key.ToString()));
//更新对应字段
#region 更新对应字段
if (materialFieldModel != null)
{
switch (materialFieldModel.FieldName)
{
//制动泵编码
case "brakepumpcode":
resultModel.brakepumpcode = model.BatchNo;
break;
//密封垫批次号
case "gasketbatchno":
resultModel.gasketbatchno = model.BatchNo;
break;
//六角(法兰面)螺母
case "hexagonalnutbatchno":
resultModel.hexagonalnutbatchno = model.BatchNo;
break;
//压力传感器批次号
case "pressuresensorbatchno":
resultModel.pressuresensorbatchno = model.BatchNo;
break;
//消音器(制动泵隔音垫)
case "silencerbatchno":
resultModel.silencerbatchno = model.BatchNo;
break;
//结合管(制动连接管)
case "connectingpipe":
resultModel.connectingpipe = model.BatchNo;
break;
//助力器制动泵支架
case "boosterbrakepumpbracket":
resultModel.boosterbrakepumpbracket = model.BatchNo;
break;
}
}
#endregion
}
}
#endregion
}
/// <summary>
/// 添加批量追溯信息
/// </summary>
private void GetBatchInfoToModel()
{
#region 添加批量追溯信息
if (RemoteMaterialHT != null && RemoteMaterialHT.Count > 0)
{
LocalMaterialHT.Clear();
foreach (DictionaryEntry item in RemoteMaterialHT) // 遍历哈希表
{
//从数据库获取当前批次材料信息
BatchNoMDL model = batchDAL.GetModel(string.Format("MaterialCode='{0}'", item.Key.ToString()));
LocalMaterialHT.Add(item.Key.ToString(), model);
//获取更新的字段
materialFieldModel = materialFieldDAL.GetModel(string.Format("materialcode='{0}'", item.Key.ToString()));
//更新对应字段
#region 更新对应字段
if (materialFieldModel != null)
{
switch (materialFieldModel.FieldName)
{
//踏板总成
case "pedalassycode":
resultModel.pedalassycode = model.BatchNo;
break;
//油门踏板
case "accelpedalcode":
resultModel.accelpedalcode = model.BatchNo;
break;
//离合器把手批次号
case "cluthhandlebatchno":
resultModel.cluthhandlebatchno = model.BatchNo;
break;
//螺栓批次号
case "boltbatchno":
resultModel.boltbatchno = model.BatchNo;
break;
//螺母批次号
case "nutbatchno":
resultModel.nutbatchno = model.BatchNo;
break;
}
}
#endregion
}
}
#endregion
}
/// <summary>
/// 获取产品BOM信息
/// </summary>
private void Select()
{
try
{
string sql = " 1=1 ";
string method = context.Request.Params["method"].ToString();
if (method == "model")
{
string MaterialCode = context.Request.Params["MaterialCode"].ToString();
if (!string.IsNullOrEmpty(MaterialCode))
{
sql += string.Format(" AND MaterialCode = {0}", MaterialCode);
}
MaterialFieldMDL model = DataDAL.GetModel(sql);
if (model != null)
{
ReturnData.Code = "1";
ReturnData.Msg = "OK";
ReturnData.Data = model;
}
}
else if (method == "search")
{
string MaterialCodeList = context.Request.Params["MaterialCodeList"].ToString();
if (!string.IsNullOrEmpty(MaterialCodeList))
{
sql += string.Format(" AND MaterialCode in ({0})", MaterialCodeList);
}
DataSet set = DataDAL.GetList(sql);
if (set != null && set.Tables.Count > 0)
{
DataTable table = set.Tables[0];
if (table != null && table.Rows.Count > 0)
{
object obj = TableHelper.TableToObj(table);
ReturnData.Code = "1";
ReturnData.Msg = "OK";
ReturnData.Data = obj;
}
}
}
}
catch (Exception ex)
{
CLog.WriteErrLog(ex.Message);
}
}
//5.材料字段表
#region 载字段表
private void DownloadMaterialField()
{
try
{
DataTable table = filedDAL.GetDataTable("");
if (table != null && table.Rows.Count > 0)
{
int count = table.Rows.Count;
this.progressBar.Maximum = count;
this.progressBar.Value = 0;
for (int i = 0; i < count; i++)
{
DataRow row = table.Rows[i];
MaterialFieldMDL model = filedDAL.DataRowToModel(row);
bool rst = lFieldDAL.Add(model);
this.progressBar.Value = i;
}
}
}
catch (Exception ex)
{
CLog.WriteErrLog(ex.Message);
}
}
/// <summary>
/// 记录扫描信息
/// </summary>
private void RecordScanInfo()
{
try
{
if (IsHjScan) //合件扫描记录
{
#region 封装Model
resultModel = new PedalResultMDL();
resultModel.barcode = this.txtHJCode.Text;
resultModel.productcode = this.txtProductCode.Text;
resultModel.userid = BaseVariable.UserEntity.UserID;
resultModel.stationid = BaseVariable.DeviceEntity.StationID;
//resultModel.CreateTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
#endregion
}
else //材料扫描记录
{
//字段表
if (!BaseVariable.NetworkStatus || !BaseVariable.ServerStatus)
{
materialFieldModel = lMaterialFieldDAL.GetModel(string.Format("materialcode='{0}' and materialname='{1}'", materialCode, materialName));
}
else
{
materialFieldModel = materialFieldDAL.GetModel(string.Format("materialcode='{0}' and materialname='{1}'", materialCode, materialName));
}
//更改相关信息
#region 对应更新字段
switch (materialFieldModel.FieldName)
{
//踏板总成
case "pedalassycode":
resultModel.pedalassycode = this.lblCurrentMaterialCode.Text;
break;
//油门踏板
case "accelpedalcode":
resultModel.accelpedalcode = this.lblCurrentMaterialCode.Text;
break;
//离合器把手批次号
case "cluthhandlebatchno":
resultModel.cluthhandlebatchno = this.lblCurrentMaterialCode.Text;
break;
//螺栓批次号
case "boltbatchno":
resultModel.boltbatchno = this.lblCurrentMaterialCode.Text;
break;
//螺母批次号
case "nutbatchno":
resultModel.nutbatchno = this.lblCurrentMaterialCode.Text;
break;
}
#endregion
}
}
catch (Exception ex)
{
CLog.WriteErrLog("[FrmScan.RecordScanInfo]" + ex.Message);
}
}
/// <summary>
/// 记录扫描信息
/// </summary>
private void RecordScanInfo()
{
try
{
if (IsHjScan) //合件扫描记录
{
#region 封装Model
resultModel = new BrakepumpResultMDL();
resultModel.barcode = this.txtHJCode.Text;
resultModel.productcode = this.txtProductCode.Text;
resultModel.userid = BaseVariable.UserEntity.UserID;
resultModel.stationid = BaseVariable.DeviceEntity.StationID;
//resultModel.CreateTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
#endregion
}
else //材料扫描记录
{
//字段表
if (!BaseVariable.NetworkStatus || !BaseVariable.ServerStatus)
{
materialFieldModel = lMaterialFieldDAL.GetModel(string.Format("materialcode='{0}' and materialname='{1}'", materialCode, materialName));
}
else
{
materialFieldModel = materialFieldDAL.GetModel(string.Format("materialcode='{0}' and materialname='{1}'", materialCode, materialName));
}
//更改相关信息
#region 对应更新字段
switch (materialFieldModel.FieldName)
{
//制动泵编码
case "brakepumpcode":
resultModel.brakepumpcode = this.lblCurrentMaterialCode.Text;
break;
//密封垫批次号
case "gasketbatchno":
resultModel.gasketbatchno = this.lblCurrentMaterialCode.Text;
break;
//六角(法兰面)螺母
case "hexagonalnutbatchno":
resultModel.hexagonalnutbatchno = this.lblCurrentMaterialCode.Text;
break;
//压力传感器批次号
case "pressuresensorbatchno":
resultModel.pressuresensorbatchno = this.lblCurrentMaterialCode.Text;
break;
//消音器(制动泵隔音垫)
case "silencerbatchno":
resultModel.silencerbatchno = this.lblCurrentMaterialCode.Text;
break;
//结合管(制动连接管)
case "connectingpipe":
resultModel.connectingpipe = this.lblCurrentMaterialCode.Text;
break;
//助力器制动泵支架
case "boosterbrakepumpbracket":
resultModel.boosterbrakepumpbracket = this.lblCurrentMaterialCode.Text;
break;
}
#endregion
}
}
catch (Exception ex)
{
CLog.WriteErrLog("[FrmScan.RecordScanInfo]" + ex.Message);
}
}
