protected void btnOk_Click(object sender, EventArgs e) { if (inputCheck()) { DataTable subContractTable = getInput(); DataTable dt = Session["subProductSelDs"] as DataTable; foreach (GridViewRow gvr in subProductGV.Rows) { int index = gvr.DataItemIndex; TextBox txb = gvr.FindControl("txtProductNum") as TextBox; if (txb != null) { dt.DefaultView[index]["productNum"] = txb.Text; } } DataTable contractProductTable = dt.DefaultView.ToTable("tbl_subContrctProduct"); DataColumn colSubContractId = new DataColumn("subContractId", System.Type.GetType("System.Int32")); contractProductTable.Columns.Add(colSubContractId); #region dataset DataSet dataSet = new DataSet(); dataSet.Tables.Add(subContractTable); dataSet.Tables.Add(contractProductTable); #endregion subContractProcess scp = new subContractProcess(dataSet); scp.MyDst = dataSet; scp.Add(); string subContractId = scp.StrRtn; foreach (DataRow dr in contractProductTable.Rows) { dr["subContractId"] = subContractId; } SubContractProductProcess scpp = new SubContractProductProcess(dataSet); scpp.Add(); Session.Remove("subContractTable"); Session.Remove("subProductSelDs"); Session.Remove("ddlProjectDtS"); Response.Redirect("~/Main/DefaultMainSite.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (!(null == Session["totleAuthority"])) { AuthAttributes usrAuthAttr = (AuthAttributes)Session["totleAuthority"]; bool flag = usrAuthAttr.HasOneFlag(AuthAttributes.newContract); if (!flag) { Response.Redirect("~/Main/NoAuthority.aspx"); } } else { string url = Request.FilePath; Session["backUrl"] = url; Response.Redirect("~/Account/Login.aspx"); } if (null == Session["selMainContractDr"]) { Response.Redirect("~/Main/contractManager/subContractEdit.aspx"); } if (!IsPostBack) { #region selMainContract DataRow sessionDr = Session["selMainContractDr"] as DataRow; lblMainContractTag.Text = sessionDr["mainContractTag"].ToString(); lblProjectTag.Text = sessionDr["projectTag"].ToString(); lblCust.Text = sessionDr["custCompName"].ToString(); lblMainContractMoney.Text = sessionDr["cash"].ToString(); lblMainContractDateLine.Text = sessionDr["dateLine"].ToString(); lblMainContractPayment.Text = sessionDr["paymentMode"].ToString(); DataTable dtMainContractProduct = (Session["mainContractProductDtSources"] as DataTable).DefaultView.ToTable(); string mainContractId = sessionDr["mainContractId"].ToString(); string strFilter = " mainContractId = " + "'" + mainContractId + "'"; dtMainContractProduct.DefaultView.RowFilter = strFilter; contractProductLsB.Rows = dtMainContractProduct.DefaultView.Count; contractProductLsB.DataSource = dtMainContractProduct; contractProductLsB.DataTextField = "productAndNum".ToString(); contractProductLsB.DataValueField = "mainContractProductId".ToString(); contractProductLsB.DataBind(); #endregion #region dllProductTable DataSet scpDst = new DataSet(); SubContractProductProcess scpView = new SubContractProductProcess(scpDst); scpView.RealSubContractProductView(); DataTable dllProductTable = scpView.MyDst.Tables["view_subContractProduct"].DefaultView.ToTable(); DataColumn colproductAndNum = new DataColumn("productAndNum", System.Type.GetType("System.String")); dllProductTable.Columns.Add(colproductAndNum); string strSplit = " , ".ToString(); foreach (DataRow dr in dllProductTable.Rows) { dr["productAndNum"] = dr["productName"].ToString() + strSplit + dr["productNum"].ToString(); } Session["dllProductTable"] = dllProductTable; #endregion #region subContractGV DataSet vscsDst = new DataSet(); subContractProcess vscsView = new subContractProcess(vscsDst); vscsView.RealSubContractSupplierView(); DataTable taskTable = vscsView.MyDst.Tables["view_subContract_supplier"].DefaultView.ToTable(); taskTable.DefaultView.RowFilter = strFilter; Session["subContractProcess"] = vscsView; Session["dtSources"] = taskTable; subContractGV.DataSource = Session["dtSources"]; subContractGV.DataBind(); #endregion } }