public static Crafwork GetCrafwork(string whereString)
{
Crafwork crafwork = null;
string sql = "select * from [Mes].[dbo].[T_crafwork] " + whereString;
using (SqlDataReader reader = DBHelper.ExecuteSqlReader(sql))
{
if (reader != null && reader.Read())
{
try
{
crafwork = new Crafwork();
if (DBNull.Value != reader["id"])
{
crafwork.Id = Convert.ToInt32(reader["id"]);
}
if (DBNull.Value != reader["crafworkcode"])
{
crafwork.CrafworkCode = reader["crafworkcode"].ToString();
}
if (DBNull.Value != reader["filename"])
{
crafwork.FileName = reader["filename"].ToString();
}
}
catch { crafwork = null; }
}
}
return(crafwork);
}
/// <summary>
/// 查询并获取新的生产工艺规格文件
/// </summary>
/// <param name="state"></param>
private void updateWorkSheetInfo(object state)
{
string worksheetNo = (string)state;
ProductPlan productPlan =
ProductPlanDAL.GetProductPlan("where worksheetno='" + worksheetNo + "'");
if (productPlan == null)
{
return;
}
Crafwork crafwork = CrafworkDAL.GetCrafwork("where id=" + productPlan.Mid);
if (crafwork == null)
{
return;
}
WorksheetNo = worksheetNo;
this.Dispatcher.Invoke(() => {
tbQrcode.Text = string.Empty;
tbWroksheetNo.Text = productPlan.WorkSheetNo;
tbCrafworkCode.Text = crafwork.CrafworkCode;
tbSpecification.Text = productPlan.Specification;
tbMaterialNo.Text = productPlan.MaterialNo;
tbColor.Text = productPlan.Color;
tbLength.Text = productPlan.Length + "";
tbBack.Text = productPlan.Bak;
tbArrLength.Text = productPlan.ArrLength + "";
});
// 获取工艺参数文件
ProductionInfo.PdfService.PdfFileName = crafwork.FileName;
}
