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; } }