/// <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); }