protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 3;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
if (string.IsNullOrEmpty(txtOrderNo.Text))
{
Response.Write("<script>alert('من فضلك تأكد من ادخال رقم الطلب')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
ADAM.DataBase.ProductionHeaderOrder hdr = mdb.ProductionHeaderOrders.Single(a => a.ProductionNo == long.Parse(txtOrderNo.Text));
txtDate.Text = hdr.ProductionDate.ToString("yyyy-MM-dd");
gvProducionOrder.DataBind();
}
protected void btnShowData_Click(object sender, ImageClickEventArgs e)
{
if (Session["UserID"] == null)
{
Response.Redirect("~/BasicData/webLogIn.aspx");
}
int userid = int.Parse(Session["UserID"].ToString());
int operationid = 3;
csGetPermission Per = new csGetPermission();
if (!Per.getPermission(userid, pageid, operationid))
{
Response.Redirect("~/BasicData/webHomePage.aspx");
}
if (string.IsNullOrEmpty(txtOrderNo.Text))
{
Response.Write("<script>alert('من فضلك تأكد من ادخال رقم الطلب')</script>");
return;
}
ADAM.DataBase.ADAMConnectionString mdb = new DataBase.ADAMConnectionString();
var Row = from a in mdb.ProductionHeaderOrders where a.ProductionNo == long.Parse(txtOrderNo.Text) select a;
if (Row.Count() > 0)
{
ADAM.DataBase.ProductionHeaderOrder headerdr = mdb.ProductionHeaderOrders.Single(a => a.ProductionNo == long.Parse(txtOrderNo.Text));
hfHeaderId.Value = headerdr.Id.ToString();
txtDate.Text = headerdr.ProductionDate.ToString("yyyy-MM-dd");
for (int GRow = 0; GRow < gvProductionOrderData.Rows.Count; GRow++)
{
TextBox txtQty = gvProductionOrderData.Rows[GRow].FindControl("txtQty") as TextBox;
long ItemContentHeaderId = long.Parse(gvProductionOrderData.DataKeys[GRow].Value.ToString());
var dRows = from a in mdb.ProductionDetailsOrders
where a.ContentHeaderId == ItemContentHeaderId &&
a.ProductionHeaderOrderId == long.Parse(hfHeaderId.Value)
select a;
if (dRows.Count() > 0)
{
ADAM.DataBase.ProductionDetailsOrder ddr = mdb.ProductionDetailsOrders.Single(a => a.ContentHeaderId == ItemContentHeaderId &&
a.ProductionHeaderOrderId == long.Parse(hfHeaderId.Value));
txtQty.Text = ddr.Qty.ToString();
}
}
}
else
{
Response.Write("<script>alert('من فضلك تأكد من رقم الطلب')</script>");
return;
}
}
