private void GetNum()
{
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Rows = from a in mdb.RecordReceiptHeaders orderby a.Id descending select a;
if (Rows.Count() == 0)
{
txtRecordReceiptNo.Text = "1";
}
else
{
ADAM.DataBase.RecordReceiptHeader dr = Rows.First();
txtRecordReceiptNo.Text = (dr.RecordReceiptNo + 1).ToString();
}
}
protected void btnShowReport_Click(object sender, ImageClickEventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtRecordReceiptNo.Text))
{
Response.Write("<script>alert('من فضلك تأكد من رقم محضر الاستلام')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString();
var Rows = from a in Mdb.RecordReceiptHeaders where a.RecordReceiptNo == long.Parse(txtRecordReceiptNo.Text) select a;
if (Rows.Count() > 0)
{
ADAM.DataBase.RecordReceiptHeader dr = Mdb.RecordReceiptHeaders.Single(a => a.RecordReceiptNo == long.Parse(txtRecordReceiptNo.Text));
var DRows = from a in Mdb.RecordReceiptDetails where a.RecordReceiptHeaderId == dr.Id select a;
foreach (ADAM.DataBase.RecordReceiptDetail ddr in DRows)
{
var AuditRows = from a in Mdb.AuditDetails where a.RecordReceiptDetailsId == ddr.Id && (a.AcceptQty == 0 || a.RefusedQty == 0) select a;
if (AuditRows.Count() <= 0)
{
Response.Write("<script>alert('لا يوجد اصناف تحت الفحص لطباعتها')</script>");
}
else
{
ShowReport();
}
}
Response.Write("<script>alert('لا يوجد اصناف تحت الفحص لطباعتها')</script>");
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم محضر الاستلام')</script>");
return;
}
}
catch { Response.Write("<script>alert('خطأ أثناء تحميل التقرير')</script>"); }
}
