/// <summary>
/// 检查用的输入是否合法.合法返回true,否则返回false
/// </summary>
/// <param name="values">新增或修改事件的参数集合对象</param>
/// <returns></returns>
private bool CheckUserInput(IOrderedDictionary values)
{
//取生产编号
var txtPn = (TextBox)fvEngLotCardAdd.FindControl("txtProductNum");
//转为大写
var pn = txtPn.Text.ToUpper();
if (!ProductNum.IsProductNum(pn))
{
throw new Exception(pn + ",不是生产编号！");
}
using (var da = new t_eng_lot_cardTableAdapter())
{
var tab = da.GetDataByPn(pn);
if (tab.Rows.Count > 0)
{
throw new Exception(string.Format("新增失败，\n存在生产编号{0}的工序流程卡，请检查后重试！", pn));
}
}
//记录生产编号
values["product_num"] = pn;
//继续检查
return CheckUserInput(values, pn);
}
/// <summary>
/// 导出工程MI资料
/// </summary>
/// <param name="pn">生产编号</param>
/// <param name="saveFilePath">文件路径</param>
/// <returns></returns>
public string ToExcel(string pn, string saveFilePath)
{
//记录保存路径和文件名
this.saveFilePath = saveFilePath;
string msg = string.Empty;
using (var da = new t_eng_lot_cardTableAdapter())
{
var tab = da.GetDataByPn(pn);
if (tab.Rows.Count > 0)
{
msg = ToExcel((DataSetEng.t_eng_lot_cardRow)tab.Rows[0]);
}
else
{
msg = "导出失败，无此生产编号的工程MI资料！";
}
}
return msg;
}