/// <summary>
/// 堆垛完成进行存储
/// </summary>
/// <param name="missionID">批号，</param>
/// <param name="zone">区域，</param>
/// <param name="robotID">堆垛机器人编号</param>
/// <returns></returns>
public int addProNumToLib(string missionID, int zone, string robotID)
{
string sql = "exec SetStowInfoByBarCode '" + missionID + "','" + zone + "','" + robotID + "'";
int i = MyDataLib.ExecNoneQueryBySql(sql);
return(i);
}
/// <summary>
/// 保存条码
/// </summary>
/// <param name="product">产品</param>
/// <param name="barcode">条码</param>
public int saveStowCode(ProductInfo product, string barcode)
{
string sql = "insert into saveStowCode (barcode,stowid,completeStowCode,num,stowdatetime)values('"
+ barcode + "','" + product.RobotID + "','" + product.completeStowCode + "','" + product.CurrentCounts + "'," + "GETDATE())";
int i = MyDataLib.ExecNoneQueryBySql(sql);
return(i);
}
//修改产品
public int changeProInfo(ProductInfo product)
{
string sql = "update StowMissionn_list set Fupqty='" + product.ComepleteNum.ToString() + "',Fqty='" + product.Total.ToString()
+ "',fTuoQty='" + product.CurrentCounts.ToString() + "',completeStowCode='" + product.completeStowCode + "' where area='" + product.Zone.ToString() + "'";
int i = MyDataLib.ExecNoneQueryBySql(sql);
return(i);
}
/// <summary>
///添加新产品-----从界面更新-》数据库
/// </summary>
/// <param name="myRobotID"></param>
/// <param name="objListProduct"></param>
public int updateMyDataLib(ProductInfo product)
{
string sql = "exec insertStowMissionn_list '" + product.MissionID + "','" + product.MaterielCode + "','" + product.Customer
+ "','" + product.Spec + "','" + product.Total.ToString() + "','" + product.Zone.ToString() + "','" + product.RobotID + "','" + product.completeStowCode + "'";
int i = MyDataLib.ExecNoneQueryBySql(sql);
return(i);
}