/// <summary>
/// 从数据库更新-》界面
/// </summary>
/// <param name="objListProduct"></param>
public List <ProductInfo> UpdateProductFromDataLib(List <ProductInfo> objListProduct, string RobotId)
{
string sql = "select * from dbo.StowMissionn_list where StowNo='" + RobotId + "' and yxbz='Y'";//通过机器人ID查找
DataTable dt = MyDataLib.SearchItem(sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
objListProduct.Add(new ProductInfo()
{
RobotID = dt.Rows[i]["StowNo"].ToString(), //机器人ID
completeStowCode = dt.Rows[i]["completeStowCode"].ToString(), //完成堆垛托号
MissionID = dt.Rows[i]["TaskNo"].ToString(), //任务单号
Customer = dt.Rows[i]["Customer"].ToString(), //客户
Zone = int.Parse(dt.Rows[i]["area"].ToString()), //垛区
Total = int.Parse(dt.Rows[i]["Fqty"].ToString()), //总数
ComepleteNum = int.Parse(dt.Rows[i]["Fupqty"].ToString()), //完成数量
CurrentCounts = int.Parse(dt.Rows[i]["fTuoQty"].ToString()), //已码数量
//PerZoneNumbers = int.Parse(dt.Rows[i]["PerZoneNum"].ToString()),//每垛数量
//Direction = int.Parse(dt.Rows[i]["Direction"].ToString()),//方向
MaterielCode = dt.Rows[i]["fnumber"].ToString(), //物料代码
Spec = dt.Rows[i]["spec"].ToString(), //规格
});
}
}
return(objListProduct);
}
/// <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);
}
