PDA Logistics Distribution System Project combat

WinCE version and mobile version are available according to customer's actual requirements

Combining barcode technology to realize mobile informatization of logistics distribution

1, Barcode Collection

In the warehouse to find goods, and input corresponding specifications model, the unregistered bar code scan registration bar code, bar code must be unique, cannot repeat, can be a commodity corresponding to multiple bar code, not a bar code corresponding to multiple commodities.

2, Inventory Inquiries

Check the inventory of the goods by scanning the barcode, inputting the product code, and the specification model.

3, out of storage management

By scanning the document bar code or enter the document number, query the goods access to and from the Library information (commodity code, name + specification model, quantity), by scanning the bar code or input commodity code, specifications for the number of proofing, after proofreading to confirm.

4, return management in advance

When the supplier after the goods or and with the supplier to determine the return goods, the new received return order (single head includes: Department, supplier, warehousing or retreat, system single, remark), scan the designated commodity, determine the number, the approval of the correct after saving, audit documents.

5, management of logistics dispatch workers

Scan specifies the delivery of documents and also display the specified documents of the commodity Code, specification model, quantity, after scanning the designated consignor, delivery vehicles, drivers, lines, save generation Dispatch, and audit.

6, Logistics Receipt Management

The delivery driver carries the document to the customer's home, after the customer sign in, the driver scans or enters the corresponding document and displays the goods in the system for the sign processing.

7, Inventory Management

Refresh the predefined counting documents, enter or select the documents to be counted, scan each item on the inventory list, determine the quantity, and save it.

8, approval of expense approval

Refresh the fee approval list for the specified period, and confirm the signature.

Support Wireless mobile, and can be real-time and logistics distribution system database docking

Specific part of the module interface

The code is as follows

Copy Code

public void NewRecord () { Isgetdata = true; Try { Cursor.current = Cursors.waitcursor; String strSQL = ""; m_state = 0; this.tb_storeTableAdapter.Connection.ConnectionString = Globalvariable.m_conn;                 if ( GlobalVariable.Conn.State = = connectionstate.closed) GlobalVariable.Conn.Open ();                 SqlCommand cmd = GlobalVariable.Conn.CreateCommand ();                 System.Data.SqlClient.SqlDataAdapter da = null;                 DataSet ds = new DataSet ();                 String ls_gcode= "";                 this. Lblgcode.text = "";                 this. Lblname.text = "";                 this. Lblmodel.text = "";                 if ( this.hhdataset.tables["Tb_store"]!= null)                  {                      this.hhdataset.tables["Tb_store"]. Clear ();                } if (this. TxtBarcode.Text.Trim (). Length < 10) { strSQL = "Select C_gcode from Tb_gds (nolock)" + "Where c_gcode= '" + this. TxtBarcode.Text.Trim () + "'"; Cmd.commandtext = strSQL; Cmd.commandtype = CommandType.Text; da = new SqlDataAdapter (cmd); Da. Fill (ds, "Tb_gds"); if (ds. tables["Tb_gds"]. Rows.Count > 0) { Ls_gcode = ds. tables["Tb_gds"]. rows[0]["C_gcode"]. ToString (); } if (Ls_gcode. Length <= 0) { This. Lblname.text = "The scanned product was not found!" "; if (this. TxtBarcode.Text.Length > 0) MessageBox.Show ("The scanned product was not found!") "," hint ", MessageBoxButtons.OK, Messageboxicon.exclamation, Messageboxdefaultbutton.button1); } } Else { strSQL = "Select C_gcode from Tb_barcode (nolock)" + "Where c_barcode= '" + this. TxtBarcode.Text.Trim () + "'"; Cmd.commandtext = strSQL; Cmd.commandtype = CommandType.Text; da = new SqlDataAdapter (cmd); Da. Fill (ds, "C_barcode"); if (ds. tables["C_barcode"]. Rows.Count > 0) { Ls_gcode = ds. tables["C_barcode"]. rows[0]["C_gcode"]. ToString (); } if (Ls_gcode. Length <= 0) { This. Lblname.text = "The scanned product was not found!" "; if (this. TxtBarcode.Text.Length > 0) MessageBox.Show ("The scanned product was not found!") "," hint ", MessageBoxButtons.OK, Messageboxicon.exclamation, Messageboxdefaultbutton.button1); } } strSQL = "Select A.c_gcode,a.c_name,a.c_model,b.c_number,b.c_move_in_number,b.c_move_out_number,b.c_onway_sale_ Number,b.c_onway_w_number "+ "From Tb_gds A (nolock), Tb_gdsadno B (nolock)" + "Where A.c_gcode=b.c_gcode and b.c_gcode= '" + Ls_gcode + "' and b.c_store_id= '" + globalvariable.m_compid + "'"; Cmd.commandtext = strSQL; Cmd.commandtype = CommandType.Text; da = new SqlDataAdapter (cmd); if (this.hhdataset.tables["Tb_store"]!= null) { this.hhdataset.tables["Tb_store"]. Clear (); } Da. Fill (This.hhdataset, "Tb_store"); Getdatalist (); SumTotal ();                 da. Dispose ();                 ds. Dispose ();                 cmd. Dispose ();            }             catch (Exception ex)              {                  MessageBox.Show ("Database connection failed!") "+ Ex." Message, "Hint", MessageBoxButtons.OK, Messageboxicon.exclamation, Messageboxdefaultbutton.button1);            }             isgetdata = false;             cursor.current = Cursors.Default;        }