protected void btnAddRcd_Click(object sender, EventArgs e)
{
if (this.txtID.Text.Trim() == "")
{
Methods.AjaxMessageBox(this, "序列号不能为空！"); return;
}
int rc = Methods.getModelIDCount(this.txtID.Text.Trim());
if (rc == 0)
{
Methods.AjaxMessageBox(this, "此序列号在数据库中不存在！"); return;
}
else if (rc < 0) { Methods.AjaxMessageBox(this, "查询产品序列号时出现异常，详情请查看日志！"); return; }
int Len = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["MIDLenInSN"]);
if (this.txtID.Text.Trim().Length <= Len)
{
Methods.AjaxMessageBox(this, "此序列号长度必须" + Len + "位以上！"); return;
}
string mid = this.txtID.Text.Trim().Substring(0, Len);
WSProcedureCtrl.ProcedureCtrl pctrl = new ProcedureCtrl();
if (!pctrl.CheckModel(mid, SessionUser.ID, 0))
{
Methods.AjaxMessageBox(this, "序列号对应的品号与计划中的品号不一致！"); return;
}
if (Methods.getTypeOfModelID(mid) == "1")//如果是产品
{
if(this.TreeRShip.Nodes.Count>0)
{
foreach (TreeNode rnode in this.TreeRShip.Nodes[0].ChildNodes)
{
if(rnode.Value.Substring(0, Len)==mid)
{
Methods.AjaxMessageBox(this,"在关联树状列表中已存在！"); break;
}
}
}
try
{
string name = "";
sqlaccess.Open();
ds = sqlaccess.OpenQuerry("select tm.Name,t.id from ta_structure t,ta_model tm where t.id=tm.id and t.id='" + mid + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
name = ds.Tables[0].Rows[0][0].ToString();
this.generTree(mid, name);
this.generRSTree(this.txtID.Text.Trim(), name);
}
}
catch (Exception ex)
{
LogManager.Write(this, ex.Message);
}
finally
{
sqlaccess.Close();
}
}
else
{
if(this.TreeStructure.Nodes.Count<0)
{
Methods.AjaxMessageBox(this, "请输入产品序列号"); return;
}
foreach (TreeNode node in this.TreeStructure.Nodes[0].ChildNodes)
{
if(node.Value==mid)
{
if (this.TreeRShip.Nodes[0].ChildNodes.Count > 0)
{
foreach (TreeNode rnode in this.TreeRShip.Nodes[0].ChildNodes)
{
if (rnode.Value.Substring(0, Len) == mid)
{
Methods.AjaxMessageBox(this, "在关联树状列表中已存在！"); break;
}
this.TreeRShip.Nodes[0].ChildNodes.Add(new TreeNode(this.txtID.Text.Trim(), this.txtID.Text.Trim()));
break;
}
}
else
{
this.TreeRShip.Nodes[0].ChildNodes.Add(new TreeNode(this.txtID.Text.Trim(), this.txtID.Text.Trim()));
}
}
}
}
this.TreeRShip.ExpandAll();
this.TreeStructure.ExpandAll();
}
protected void btnAddRcd_Click(object sender, EventArgs e)
{
this.txtID.Focus();
if (this.txtID.Text.Trim() == "")
{
Methods.AjaxMessageBox(this, "产品序列号不能为空！"); return;
}
int rc = Methods.getModelIDCount(this.txtID.Text.Trim());
if(rc>0)
{
Methods.AjaxMessageBox(this, "此产品序列号已经存在！"); return;
}
else if (rc < 0) { Methods.AjaxMessageBox(this, "查询产品序列号时出现异常，详情请查看日志！"); return; }
ds = (DataSet)ViewState["tmpds"];
for (int i = 0; i < ds.Tables[0].Rows.Count;i++ )
{
if (this.txtID.Text.Trim() == ds.Tables[0].Rows[i]["ID"].ToString())
{
Methods.AjaxMessageBox(this,"此产品序列号已经存在！"); return;
}
}
int Len = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["MIDLenInSN"]);
if (this.txtID.Text.Trim().Length <= Len)
{
Methods.AjaxMessageBox(this,"此产品序列号长度必须"+Len+"位以上！"); return;
}
DataRow r = ds.Tables[0].NewRow();//将数据源添加一新行
Guid gd = Guid.NewGuid();
string sn = gd.ToString();
string PlanID = "";
int ProcedureID = -1;
string ModelID = Methods.GetPlanPIDByEID(SessionUser.ID, out PlanID);
string mid = this.txtID.Text.Trim().Substring(0, Len);
//if(mid!=ModelID)
//{
// Methods.AjaxMessageBox(this,"序列号对应的品号与计划中的品号不一致！"); return;
//}
WSProcedureCtrl.ProcedureCtrl pctrl = new ProcedureCtrl();
if (!pctrl.CheckModel(mid, SessionUser.ID, 0))
{
Methods.AjaxMessageBox(this, "序列号对应的品号与计划中的品号不一致！"); return;
}
ProcedureID = Convert.ToInt32(Methods.GetProcIDByMID(mid, PlanID));//
if (ProcedureID < 0)
{
Methods.AjaxMessageBox(this, "提示：没有对应的产品流程号！");
}
r["ID"] = this.txtID.Text.Trim();
r["SN"] = sn;//GUID
r["ModelID"] = mid;
r["PlanID"] = PlanID;
r["ProcedureID"] = ProcedureID;
r["FoundTime"] = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:dd");
r["Remark"] = "";
ds.Tables[0].Rows.InsertAt(r, 0);
ds.AcceptChanges();
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
this.txtID.Text = "";
}
protected void btnAddRcd_Click(object sender, EventArgs e)
{
this.txtSN.Focus();
if (this.btnAddRcd.Text == "验证产品序列号")
{
if (this.txtID.Text.Trim() == "")
{
Methods.AjaxMessageBox(this, "产品序列号不能为空！"); return;
}
int rc = Methods.getModelIDCount(this.txtID.Text.Trim());
if (rc == 0)
{
Methods.AjaxMessageBox(this, "此产品序列号在数据库中不存在！"); return;
}
else if (rc < 0) { Methods.AjaxMessageBox(this, "查询产品序列号时出现异常，详情请查看日志！"); return; }
//ds = (DataSet)ViewState["tmpds"];
//for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
//{
// if (this.txtID.Text.Trim() == ds.Tables[0].Rows[i]["ID"].ToString())
// {
// Methods.AjaxMessageBox(this, "此产品序列号的记录已经存在！"); return;
// }
//}
int Len = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["MIDLenInSN"]);
if (this.txtID.Text.Trim().Length <= Len)
{
Methods.AjaxMessageBox(this, "此产品序列号长度必须" + Len + "位以上！"); return;
}
string PlanID = "";
string ModelID = Methods.GetPlanPIDByEID(SessionUser.ID, out PlanID);
string mid = this.txtID.Text.Trim().Substring(0, Len);
//if(mid!=ModelID)
//{
// Methods.AjaxMessageBox(this,"序列号对应的品号与计划中的品号不一致！"); return;
//}
WSProcedureCtrl.ProcedureCtrl pctrl = new ProcedureCtrl();
if (!pctrl.CheckModel(mid, SessionUser.ID, 0))
{
Methods.AjaxMessageBox(this, "序列号对应的品号与计划中的品号不一致！"); return;
}
ViewState["PlanID"] = PlanID;
ViewState["mid"]= mid;
this.btnAddRcd.Text = "添加产品条码";
this.lblCode.Text = "扫描产品条码";
this.txtID.Visible = false;
this.txtSN.Visible = true;
this.txtSN.Text = "";
this.txtSN.Focus();
}
else
{
ds = (DataSet)ViewState["tmpds"];
DataRow r = ds.Tables[0].NewRow();//将数据源添加一新行
r["ID"] = this.txtID.Text.Trim();
r["ModelID"] = ViewState["mid"];
r["PlanID"] = ViewState["PlanID"];
r["SN"] = this.txtSN.Text.Trim();
ds.Tables[0].Rows.InsertAt(r, 0);
ds.AcceptChanges();
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
this.btnAddRcd.Text = "验证产品序列号";
this.lblCode.Text = "扫描产品序列号";
this.txtID.Visible = true;
this.txtID.Text = "";
this.txtSN.Visible = false;
this.txtID.Focus();
}
}