protected void Page_Load(object sender, EventArgs e) { if (!(null == Session["totleAuthority"])) { AuthAttributes usrAuthAttr = (AuthAttributes)Session["totleAuthority"]; bool flag = usrAuthAttr.HasOneFlag(AuthAttributes.custManager); if (!flag) { Response.Redirect("~/Main/NoAuthority.aspx"); } } else { string url = Request.FilePath; Session["backUrl"] = url; Response.Redirect("~/Account/Login.aspx"); } if (!IsPostBack) { DataSet MyDst = new DataSet(); SupplierProcess myView = new SupplierProcess(MyDst); myView.RealSupplierView(); DataTable taskTable = myView.MyDst.Tables["tbl_supplier_company"]; Session["SupplierProcess"] = myView; Session["dtSources"] = taskTable; supplierGV.DataSource = Session["dtSources"]; supplierGV.DataBind(); } }
protected void btnOk_Click(object sender, EventArgs e) { if (inputCheck()) { string sn = txtSupplierName.Text.ToString().Trim(); string sa = txtSupplierAddr.Text.ToString().Trim(); #region dataset DataSet dataSet = new DataSet(); DataRow supplierRow = null; DataColumn colSupplierName = new DataColumn("supplierName", System.Type.GetType("System.String")); DataColumn colSupplierAddr = new DataColumn("supplierAddress", System.Type.GetType("System.String")); DataTable supplierTable = new DataTable("tbl_supplier_company"); supplierTable.Columns.Add(colSupplierName); supplierTable.Columns.Add(colSupplierAddr); supplierRow = supplierTable.NewRow(); supplierRow["supplierName"] = sn; supplierRow["supplierAddress"] = sa; supplierTable.Rows.Add(supplierRow); dataSet.Tables.Add(supplierTable); #endregion DataSet dsCheck = new DataSet(); SupplierProcess sp = new SupplierProcess(dsCheck); sp.RealSupplierView(); int rowRtn = -1; sp.DoCheckSupplierName(sn); rowRtn = sp.IntRtn; if (0 == rowRtn) { sp.MyDst = dataSet; sp.Add(); Response.Redirect("~/Main/custInfoManager/supplierManager/supplierEdit.aspx"); } else { lblSupplierName.Text = "公司名已存在!"; } } }
protected void btnAcceptDel_Click(object sender, EventArgs e) { int dataIndex = supplierGV.SelectedRow.DataItemIndex; DataTable dt = (DataTable)Session["dtSources"]; string depId = dt.DefaultView[dataIndex].Row["supplierId"].ToString(); Button btn = null; btn = (supplierGV.SelectedRow.FindControl("btnUpdate") as Button); btn.Visible = false; btn = (supplierGV.SelectedRow.FindControl("btnCancle") as Button); btn.Visible = false; btn = (supplierGV.SelectedRow.FindControl("btnSupplierManEdit") as Button); btn.Visible = false; btn = (supplierGV.SelectedRow.FindControl("btnDel") as Button); btn.Visible = false; btn = sender as Button; btn.Visible = false; btn = btnDelCancel; btn.Visible = false; SupplierProcess sp = Session["SupplierProcess"] as SupplierProcess; sp.SupplierDel(depId); sp.RealSupplierView(); DataTable taskTable = sp.MyDst.Tables["tbl_supplier_company"]; Session["dtSources"] = sp.MyDst.Tables["tbl_supplier_company"] as DataTable; supplierGV.DataSource = Session["dtSources"]; supplierGV.SelectedIndex = -1; supplierGV.EditIndex = -1; supplierGV.DataBind(); supplierGV.Enabled = true; btnAdd.Visible = true; }
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 (!IsPostBack) { #region subContractTable DataTable subContractTable = null; if (null == Session["subContractTable"]) { DataRow subContractRow = null; DataColumn colMainContractId = new DataColumn("mainContractId", System.Type.GetType("System.String")); DataColumn colSupplierIdName = new DataColumn("supplierId", System.Type.GetType("System.String")); DataColumn colSubContractTag = new DataColumn("subContractTag", System.Type.GetType("System.String")); DataColumn colCash = new DataColumn("cash", System.Type.GetType("System.String")); DataColumn colDateLine = new DataColumn("dateLine", System.Type.GetType("System.String")); DataColumn colPaymentMode = new DataColumn("paymentMode", System.Type.GetType("System.String")); subContractTable = new DataTable("tbl_subContract"); subContractTable.Columns.Add(colMainContractId); subContractTable.Columns.Add(colSupplierIdName); subContractTable.Columns.Add(colSubContractTag); subContractTable.Columns.Add(colCash); subContractTable.Columns.Add(colDateLine); subContractTable.Columns.Add(colPaymentMode); DataRow sessionDr = Session["selMainContractDr"] as DataRow; string mainContractId = sessionDr["mainContractId"].ToString(); subContractRow = subContractTable.NewRow(); subContractRow["mainContractId"] = mainContractId; subContractRow["supplierId"] = -1; subContractRow["subContractTag"] = string.Empty; subContractRow["cash"] = string.Empty; subContractRow["dateLine"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"); subContractRow["paymentMode"] = string.Empty; subContractTable.Rows.Add(subContractRow); Session["subContractTable"] = subContractTable; } else { subContractTable = Session["subContractTable"] as DataTable; } txtSubContractTag.Text = subContractTable.Rows[0]["subContractTag"].ToString(); txtMoney.Text = subContractTable.Rows[0]["cash"].ToString(); btnDate.Text = subContractTable.Rows[0]["dateLine"].ToString(); txtPayment.Text = subContractTable.Rows[0]["paymentMode"].ToString(); #endregion #region subProductGV if (null == Session["subProductSelDs"]) { } else { DataTable dt = Session["subProductSelDs"] as DataTable; string strFilter = " checkOrNot = " + "'" + bool.TrueString + "'"; dt.DefaultView.RowFilter = strFilter; subProductGV.DataSource = dt; subProductGV.DataBind(); } #endregion #region ddlSupplierTable DataSet projectDst = new DataSet(); SupplierProcess ddlSupplierView = new SupplierProcess(projectDst); ddlSupplierView.RealSupplierView(); DataTable ddlSupplierTable = ddlSupplierView.MyDst.Tables["tbl_supplier_company"]; //DataColumn[] projectKey = new DataColumn[1]; //projectKey[0] = ddlProjectTable.Columns["projectTagId"]; //ddlProjectTable.PrimaryKey = projectKey; Session["ddlProjectDtS"] = ddlSupplierTable; DataRow dr = ddlSupplierTable.NewRow(); dr["supplierId"] = -1; dr["supplierName"] = string.Empty; dr["endTime"] = "9999-12-31"; ddlSupplierTable.Rows.Add(dr); ddlSupplier.DataValueField = "supplierId"; ddlSupplier.DataTextField = "supplierName"; ddlSupplier.DataSource = ddlSupplierTable; ddlSupplier.DataBind(); ddlSupplier.SelectedValue = subContractTable.Rows[0]["supplierId"].ToString();; #endregion } }
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 (!IsPostBack) { int subContractId = int.Parse(Session["seldSubContractId"] as string); Xm_db xmDataCont = Xm_db.GetInstance(); var subContractEdit = (from subContract in xmDataCont.Tbl_subContract where subContract.MainContractId == subContractId && subContract.EndTime > DateTime.Now select subContract).First(); txtSubContractTag.Text = subContractEdit.SubContractTag; txtMoney.Text = subContractEdit.Cash.ToString(); btnDate.Text = subContractEdit.DateLine.ToString(); txtPayment.Text = subContractEdit.PaymentMode; #region subProductGV var subProductSelDs = from subContrctProduct in subContractEdit.Tbl_subContrctProduct join product in xmDataCont.Tbl_product on subContrctProduct.ProductId equals product.ProductId select new { product.ProductName, subContrctProduct.ProductNum }; DataTable dt = subProductSelDs.ToDataTable(); if (dt.Rows.Count > 0) { subProductGV.DataSource = dt; subProductGV.DataBind(); } #endregion #region ddlSupplierTable DataSet projectDst = new DataSet(); SupplierProcess ddlSupplierView = new SupplierProcess(projectDst); ddlSupplierView.RealSupplierView(); DataTable ddlSupplierTable = ddlSupplierView.MyDst.Tables["tbl_supplier_company"]; Session["ddlProjectDtS"] = ddlSupplierTable; DataRow dr = ddlSupplierTable.NewRow(); dr["supplierId"] = -1; dr["supplierName"] = string.Empty; dr["endTime"] = "9999-12-31"; ddlSupplierTable.Rows.Add(dr); ddlSupplier.DataValueField = "supplierId"; ddlSupplier.DataTextField = "supplierName"; ddlSupplier.DataSource = ddlSupplierTable; ddlSupplier.DataBind(); ddlSupplier.SelectedValue = subContractEdit.SupplierId.ToString(); #endregion } }
protected void btnUpdate_Click(object sender, EventArgs e) { int index = supplierGV.SelectedIndex; int dataIndex = supplierGV.Rows[index].DataItemIndex; DataTable dt = (DataTable)Session["dtSources"]; GridViewRow row = supplierGV.Rows[index]; TextBox tbSupplierName = row.Cells[1].Controls[0] as TextBox; string newSupplierName = tbSupplierName.Text.ToString().Trim(); TextBox tbSupplierAddr = row.Cells[2].Controls[0] as TextBox; string newSupplierAddr = tbSupplierAddr.Text.ToString().Trim(); DataTable dtCheckTemp = (Session["dtSources"] as DataTable).DefaultView.ToTable(); string supplierIdTemp = dt.DefaultView[dataIndex].Row["supplierId"].ToString(); string strFilter = " supplierId <> " + "'" + supplierIdTemp + "'"; dtCheckTemp.DefaultView.RowFilter = strFilter; DataTable dtCheck = dtCheckTemp.DefaultView.ToTable(); string strNameCheck = newSupplierName; string strAddrCheck = newSupplierAddr; newSupplierName = input_check("custCompName", strNameCheck, dtCheck); newSupplierAddr = input_check("custCompAddress", strAddrCheck, dtCheck); if (newSupplierName.Equals(strNameCheck) && newSupplierAddr.Equals(strAddrCheck)) { int supplierId = int.Parse(dt.DefaultView[dataIndex].Row["supplierId"].ToString()); SupplierProcess sp = Session["SupplierProcess"] as SupplierProcess; sp.SupplierUpdate(supplierId, newSupplierName, newSupplierAddr); sp.RealSupplierView(); DataTable taskTable = sp.MyDst.Tables["tbl_supplier_company"]; Session["dtSources"] = sp.MyDst.Tables["tbl_supplier_company"] as DataTable; //Button btn = null; //btn = (custCompGV.Rows[index].FindControl("btnDel") as Button); //btn.Visible = false; //btn = (custCompGV.Rows[index].FindControl("btnCancle") as Button); //btn.Visible = false; //btn = sender as Button; //btn.Visible = false; Button btn = null; btn = sender as Button; btn.Visible = false; btn = (supplierGV.SelectedRow.FindControl("btnCancle") as Button); btn.Visible = false; btn = (supplierGV.SelectedRow.FindControl("btnSupplierManEdit") as Button); btn.Visible = false; btn = (supplierGV.SelectedRow.FindControl("btnDel") as Button); btn.Visible = false; btn = btnDelCancel; btn.Visible = false; btn = btnAcceptDel; btn.Visible = false; supplierGV.SelectedIndex = -1; supplierGV.EditIndex = -1; supplierGV.DataSource = Session["dtSources"];//["dtSources"] as DataTable; supplierGV.DataBind(); btnAdd.Visible = true; } else { tbSupplierName.Text = newSupplierName; tbSupplierAddr.Text = newSupplierAddr; supplierGV.SelectedIndex = index; supplierGV.EditIndex = index; } }
protected void Page_Load(object sender, EventArgs e) { if (!(null == Session["totleAuthority"])) { AuthAttributes usrAuthAttr = (AuthAttributes)Session["totleAuthority"]; bool flag = usrAuthAttr.HasOneFlag(AuthAttributes.stockManager); if (!flag) { Response.Redirect("~/Main/NoAuthority.aspx"); } } else { string url = Request.FilePath; Session["backUrl"] = url; Response.Redirect("~/Account/Login.aspx"); } if (!IsPostBack) { DataSet MyDst = new DataSet(); #region ddlProduct ProductProcess productView = new ProductProcess(MyDst); productView.RealProductView(); DataTable ddlProductTable = productView.MyDst.Tables["tbl_product"].DefaultView.ToTable(); DataRow ddlProductDr = ddlProductTable.NewRow(); ddlProductDr["productName"] = string.Empty; ddlProductDr["productId"] = -1; ddlProductTable.Rows.Add(ddlProductDr); ddlProduct.DataSource = ddlProductTable; ddlProduct.DataTextField = "productName"; ddlProduct.DataValueField = "productId"; ddlProduct.DataBind(); ddlProduct.SelectedValue = "-1"; #endregion #region ddlEngineer UsrAuthProcess usrAuthView = new UsrAuthProcess(MyDst); usrAuthView.View(); DataTable ddlEngineerTable = usrAuthView.MyDst.Tables["view_usr_autority"].DefaultView.ToTable(); string authorityName = "货物检验"; DataRow ddlEngigeerDr = ddlEngineerTable.NewRow(); ddlEngigeerDr["realName"] = string.Empty; ddlEngigeerDr["usrId"] = -1; ddlEngigeerDr["authorityName"] = authorityName; ddlEngineerTable.Rows.Add(ddlEngigeerDr); string strFilter = " authorityName = " + "'" + authorityName + "'"; ddlEngineerTable.DefaultView.RowFilter = strFilter; ddlEngineer.DataSource = ddlEngineerTable; ddlEngineer.DataTextField = "realName"; ddlEngineer.DataValueField = "usrId"; ddlEngineer.DataBind(); ddlEngineer.SelectedValue = "-1"; #endregion #region ddlSupplier SupplierProcess supplierView = new SupplierProcess(MyDst); supplierView.RealSupplierView(); DataTable ddlSupplierTable = supplierView.MyDst.Tables["tbl_supplier_company"].DefaultView.ToTable(); DataRow ddlSupplierDr = ddlSupplierTable.NewRow(); ddlSupplierDr["supplierName"] = string.Empty; ddlSupplierDr["supplierId"] = -1; ddlSupplierTable.Rows.Add(ddlSupplierDr); ddlSupplier.DataSource = ddlSupplierTable; ddlSupplier.DataTextField = "supplierName"; ddlSupplier.DataValueField = "supplierId"; ddlSupplier.DataBind(); ddlSupplier.SelectedValue = "-1"; #endregion } }