private void btnAdd_Click(object sender, EventArgs e) { Object[] array = new Object[6]; for (int j = 0; j < pomod.Count; j++) { if (txtScanItemNo.SelectedValue.ToString().Equals(pomod[j].lineno.ToString())) { QHMobile.POModule assignPO = new POModule(); array[0] = pomod[j].lineno; assignPO.lineno = pomod[j].lineno; array[1] = pomod[j].itemNo; assignPO.itemNo = pomod[j].itemNo; array[2] = pomod[j].description; assignPO.description = pomod[j].description; array[3] = txtqty.Text.Trim(); assignPO.quantity = Convert.ToDecimal(txtqty.Text.Trim()); array[4] = txtlocation.Text.Trim(); assignPO.location = txtlocation.Text.Trim(); array[5] = txtbin.Text.Trim(); assignPO.bin = txtbin.Text.Trim(); dt.Rows.Add(array); assignPOList.Add(assignPO); CompactSQL compa = new CompactSQL(); compa.InsertPOAssign("POAssign", array, PutNumber, TONumber); lblTotalQty.Text = "Total Qty of this item is : " + pomod[j].quantity; } GrdTO.DataSource = dt; } }
private void GetRecordsFromSQL(SqlCeDataReader getallrecords) { do { Object[] array = new Object[6]; QHMobile.POModule assignPO = new POModule(); assignPO.lineno = Convert.ToInt32(getallrecords["LineNo"]); array[0] = getallrecords["LineNo"].ToString(); array[1] = getallrecords["itemNo"].ToString(); assignPO.itemNo = getallrecords["itemNo"].ToString(); array[2] = getallrecords["Description"].ToString(); assignPO.description = getallrecords["Description"].ToString(); array[3] = getallrecords["Quantity"].ToString(); assignPO.quantity = Convert.ToInt32(getallrecords["Quantity"]); array[4] = getallrecords["Location"].ToString(); assignPO.location = getallrecords["Location"].ToString(); array[5] = getallrecords["BinCode"].ToString(); assignPO.bin = getallrecords["BinCode"].ToString(); dt.Rows.Add(array); assignPOList.Add(assignPO); } while (getallrecords.Read()); GrdTO.DataSource = dt; }
private void CreatePutAway() { try { PutAlwaysQH.PutAlwaysQH_Service putSev = new QHMobile.PutAlwaysQH.PutAlwaysQH_Service(); putSev.Url = WebServiceInstants.GetURL(ServiceType.PutAlwaysQH); putSev.Credentials = nc; PurchaseQH.PurchaseQH_Service poservice = new QHMobile.PurchaseQH.PurchaseQH_Service(); poservice.Url = WebServiceInstants.GetURL(ServiceType.PurchaseQH); poservice.Credentials = nc; PutAlwaysQH.PutAlwaysQH putAwayCreate = new QHMobile.PutAlwaysQH.PutAlwaysQH(); PurchaseQH.PurchaseQH poRead = poservice.Read(TONumber); putSev.Create(ref putAwayCreate); PutNumber = putAwayCreate.No; putAwayCreate.Source_Document = QHMobile.PutAlwaysQH.Source_Document.Purchase_Order; putAwayCreate.Location_Code = "QH1";//poRead.Location_Code; putSev.Update(ref putAwayCreate); putAwayCreate.Source_No = txtTO.Text.Trim(); putSev.Update(ref putAwayCreate); PutAlwaysLinesQH.PutAlwaysLinesQH_Service lineservice = new QHMobile.PutAlwaysLinesQH.PutAlwaysLinesQH_Service(); lineservice.Url = WebServiceInstants.GetURL(ServiceType.PutAlwaysLinesQH); lineservice.Credentials = nc; List <PutAlwaysLinesQH.PutAlwaysLinesQH_Filter> filterArray = new List <QHMobile.PutAlwaysLinesQH.PutAlwaysLinesQH_Filter>(); PutAlwaysLinesQH.PutAlwaysLinesQH_Filter fitlerNumber = new PutAlwaysLinesQH.PutAlwaysLinesQH_Filter(); fitlerNumber.Field = PutAlwaysLinesQH.PutAlwaysLinesQH_Fields.No; fitlerNumber.Criteria = PutNumber; filterArray.Add(fitlerNumber); PutAlwaysLinesQH.PutAlwaysLinesQH[] GridPutAwayLines = lineservice.ReadMultiple(filterArray.ToArray(), null, 0); for (int k = 0; k < GridPutAwayLines.Length; k++) { PutAlwaysLinesQH.PutAlwaysLinesQH toUpdate = new QHMobile.PutAlwaysLinesQH.PutAlwaysLinesQH(); toUpdate = lineservice.Read(PutAlwaysLinesQH.Activity_Type.Invt_Put_away.ToString(), PutNumber, GridPutAwayLines[k].Line_No); toUpdate.Bin_Code = null; lineservice.Update(ref toUpdate); } PutAlwaysLinesQH.PutAlwaysLinesQH[] PutAwayRead = lineservice.ReadMultiple(filterArray.ToArray(), null, 0); for (int i = 0; i < PutAwayRead.Length; i++) { QHMobile.POModule po = new POModule(); po.itemNo = PutAwayRead[i].Item_No; po.lineno = PutAwayRead[i].Line_No; po.description = PutAwayRead[i].Description; po.location = PutAwayRead[i].Location_Code; po.quantity = PutAwayRead[i].Quantity; pomod.Add(po); } BindToGridLines(pomod); } catch (Exception ex) { MessageBox.Show(ex.Message); } }