public static string get_items_received()
{
string result = string.Empty;
CE sqlCe = new CE();
dt = new DataTable("table");
dt = sqlCe.DataTable("SELECT " +
"did, " +
"mid, " +
"received_qty, " +
"status, " +
"remarks " +
"FROM tbl_delivery_items_received " +
"WHERE delivery_id = " + delivery_id);
if (dt != null)
{
StringWriter sw = new StringWriter();
dt.WriteXml(sw);
result = sw.ToString().Trim().Replace("\r\n", "");
}
return result;
}
public static void save_to_localdb()
{
try
{
CE sqlCe = new CE();
dt = new DataTable("table");
dt = config.get(api.GetDeliveryItems(delivery_id));
DataRow[] result = dt.Select();
string query = string.Empty;
foreach (DataRow l in result)
{
if (!Is_Exist(Convert.ToInt64(l["id"])))
{
query = "INSERT INTO tbl_delivery_items_received (delivery_id, did, mid, code, po_qty, received_qty, status) " +
"VALUES " +
"('" + delivery_id + "', " +
"'" + l["id"].ToString() + "', " +
"'" + l["mid"].ToString() + "', " +
"'" + l["code"].ToString() + "', " +
"'" + l["po_qty"].ToString() + "', " +
"'" + l["received"].ToString() + "', " +
"'22');";
sqlCe.Execute(query);
}
}
query = "SELECT delivery_id, did, mid, code, po_qty, received_qty " +
"FROM tbl_delivery_items_received WHERE delivery_id = " + delivery_id;
dt = new DataTable("table");
dt = sqlCe.DataTable(query);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static DataTable getMaterialItemsByBarCode(string b_code)
{
sqlCe = new CE();
return sqlCe.DataTable("SELECT * FROM GetMaterialIssuanceItems WHERE id '" + miid + "' AND code = '" + b_code + "'");
}