public static bool check_received(int id)
{
CE sqlCe = new CE();
string query = "SELECT * FROM cerpdb.delivery_items WHERE did = '" + id + "' AND delivery_id > 0";
foreach (var l in sqlCe.Select(query, new int[] { 0 }))
{
if (l != null)
{
return true;
}
}
return false;
}
static bool Is_Exist(Int64 id)
{
CE sqlCe = new CE();
foreach (var l in sqlCe.Select(
"SELECT did FROM tbl_delivery_items_received WHERE did = " + id, // - select query
new int[] { 0 } // - index columns
))
{
if (l != null)
{
return true;
}
}
return false;
}
internal static bool id(int id)
{
sqlCe = new CE();
var result = sqlCe.Select("SELECT id FROM GetMaterialIssuance WHERE id = " + id, new int[] { 0 });
foreach (var i in result)
{
return true;
}
return false;
}
