protected string tag_init() { DateTime dtDate = new DateTime(DateTime.Now.Year, 1, 1); string custCompId = ddlCustComp.SelectedValue.ToString(); DataTable custCompDt = Session["ddlCustCompDtS"] as DataTable; DataRow custCompdr = custCompDt.Rows.Find(custCompId); string custCompTag = custCompdr["custCompTag"].ToString(); //string custManId = ddlCustMan.SelectedValue.ToString(); ProjectTagProcess ptp = Session["ProjectTagProcess"] as ProjectTagProcess; string custCompProCount = ptp.compProjectCount(custCompId); string splitTemp = "-"; string newTag = custCompTag + dtDate.Year.ToString() + splitTemp + custCompProCount; return(newTag); }
protected void btnOk_Click(object sender, EventArgs e) { if (inputCheck()) { string usrId = Session["usrId"].ToString(); string projSynopsis = txtSynopsis.Text.ToString(); string custManId = ddlCustMan.SelectedValue.ToString(); string projectTag = tag_init(); #region dataset DataSet dataSet = new DataSet(); DataRow projRow = null; DataColumn colUsrId = new DataColumn("usrId", System.Type.GetType("System.String")); DataColumn colSynopsis = new DataColumn("projectSynopsis", System.Type.GetType("System.String")); DataColumn colManId = new DataColumn("custManId", System.Type.GetType("System.String")); DataColumn colProjTag = new DataColumn("projectTag", System.Type.GetType("System.String")); DataTable projTable = new DataTable("tbl_projectTagInfo"); projTable.Columns.Add(colUsrId); projTable.Columns.Add(colSynopsis); projTable.Columns.Add(colManId); projTable.Columns.Add(colProjTag); projRow = projTable.NewRow(); projRow["usrId"] = usrId; projRow["projectSynopsis"] = projSynopsis; projRow["custManId"] = custManId; projRow["projectTag"] = projectTag; projTable.Rows.Add(projRow); dataSet.Tables.Add(projTable); #endregion ProjectTagProcess ptp = Session["ProjectTagProcess"] as ProjectTagProcess; ptp.MyDst = dataSet; ptp.Add(); Response.Redirect("~/Main/projectTagInfoManager/projectSearch.aspx"); } }
protected void outBorrowInit() { DataSet MyDst = new DataSet(); custCompProcess ddlCustCompView = new custCompProcess(MyDst); custManProcess ddlCustManView = new custManProcess(MyDst); ddlCustManView.CustCompId = "-1".ToString(); ProjectTagProcess ptView = new ProjectTagProcess(MyDst); ddlCustCompView.RealCompView(); ddlCustManView.RealCustManView(); DataTable ddlCustCompTable = ddlCustCompView.MyDst.Tables["tbl_customer_company"]; DataTable ddlCustManTable = ddlCustManView.MyDst.Tables["tbl_customer_manager"]; DataColumn[] custCompKey = new DataColumn[1]; custCompKey[0] = ddlCustCompTable.Columns["custCompyId"]; ddlCustCompTable.PrimaryKey = custCompKey; DataColumn[] custManpKey = new DataColumn[1]; custManpKey[0] = ddlCustManTable.Columns["custManId"]; ddlCustManTable.PrimaryKey = custManpKey; Session["custCompProcess"] = ddlCustCompView; Session["ddlCustCompDtS"] = ddlCustCompTable; Session["custManProcess"] = ddlCustManView; Session["ddlCustManDtS"] = ddlCustManTable; Session["ProjectTagProcess"] = ptView; DataRow dr = ddlCustCompTable.NewRow(); dr["custCompyId"] = -1; dr["custCompName"] = string.Empty; dr["endTime"] = "9999-12-31"; ddlCustCompTable.Rows.Add(dr); ddlCustComp.DataValueField = "custCompyId"; ddlCustComp.DataTextField = "custCompName"; ddlCustComp.DataSource = ddlCustCompTable; ddlCustComp.DataBind(); ddlCustComp.SelectedValue = "-1"; }
protected void Page_Load(object sender, EventArgs e) { if (!(null == Session["totleAuthority"])) { AuthAttributes usrAuthAttr = (AuthAttributes)Session["totleAuthority"]; bool flag = usrAuthAttr.HasOneFlag(AuthAttributes.projectTagApply); if (!flag) { Response.Redirect("~/Main/NoAuthority.aspx"); } } else { string url = Request.FilePath; Session["backUrl"] = url; Response.Redirect("~/Account/Login.aspx"); } if (!IsPostBack) { DataSet custCompDst = new DataSet(); DataSet custManDst = new DataSet(); DataSet projTagDst = new DataSet(); custCompProcess ddlCustCompView = new custCompProcess(custCompDst); custManProcess ddlCustManView = new custManProcess(custManDst); ddlCustManView.CustCompId = "-1".ToString(); ProjectTagProcess ptView = new ProjectTagProcess(projTagDst); ddlCustCompView.RealCompView(); ddlCustManView.RealCustManView(); DataTable ddlCustCompTable = ddlCustCompView.MyDst.Tables["tbl_customer_company"]; DataTable ddlCustManTable = ddlCustManView.MyDst.Tables["tbl_customer_manager"]; DataColumn[] custCompKey = new DataColumn[1]; custCompKey[0] = ddlCustCompTable.Columns["custCompyId"]; ddlCustCompTable.PrimaryKey = custCompKey; DataColumn[] custManpKey = new DataColumn[1]; custManpKey[0] = ddlCustManTable.Columns["custManId"]; ddlCustManTable.PrimaryKey = custManpKey; Session["custCompProcess"] = ddlCustCompView; Session["ddlCustCompDtS"] = ddlCustCompTable; Session["custManProcess"] = ddlCustManView; Session["ddlCustManDtS"] = ddlCustManTable; Session["ProjectTagProcess"] = ptView; DataRow dr = ddlCustCompTable.NewRow(); dr["custCompyId"] = -1; dr["custCompName"] = string.Empty; dr["endTime"] = "9999-12-31"; ddlCustCompTable.Rows.Add(dr); //ddlCustCompTable.AcceptChanges(); ddlCustComp.DataValueField = "custCompyId"; ddlCustComp.DataTextField = "custCompName"; ddlCustComp.DataSource = ddlCustCompTable; ddlCustComp.DataBind(); ddlCustComp.SelectedValue = "-1"; } }
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 ddlCustComp DataSet dst = new DataSet(); custCompProcess ddlCustCompView = new custCompProcess(dst); ddlCustCompView.RealCompView(); DataTable ddlCustCompTable = ddlCustCompView.MyDst.Tables["tbl_customer_company"].DefaultView.ToTable(); //DataColumn[] projectKey = new DataColumn[1]; //projectKey[0] = ddlProjectTable.Columns["projectTagId"]; //ddlProjectTable.PrimaryKey = projectKey; DataRow dr = ddlCustCompTable.NewRow(); dr["custCompyId"] = -1; dr["custCompName"] = string.Empty; dr["endTime"] = "9999-12-31"; ddlCustCompTable.Rows.Add(dr); Session["ddlProjectDtS"] = ddlCustCompTable; ddlCustComp.DataValueField = "custCompyId"; ddlCustComp.DataTextField = "custCompName"; ddlCustComp.DataSource = Session["ddlProjectDtS"]; ddlCustComp.DataBind(); #endregion #region mainContractTable DataTable mainContractTable = null; if (null == Session["mainContractTable"]) { DataRow mainContractRow = null; DataColumn colProjectTagId = new DataColumn("projectTagId", System.Type.GetType("System.String")); DataColumn colCustCompId = new DataColumn("custCompyId", System.Type.GetType("System.String")); DataColumn colMainContractTag = new DataColumn("mainContractTag", 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")); mainContractTable = new DataTable("tbl_mainContract"); mainContractTable.Columns.Add(colProjectTagId); mainContractTable.Columns.Add(colCustCompId); mainContractTable.Columns.Add(colMainContractTag); mainContractTable.Columns.Add(colCash); mainContractTable.Columns.Add(colDateLine); mainContractTable.Columns.Add(colPaymentMode); mainContractRow = mainContractTable.NewRow(); mainContractRow["projectTagId"] = -1; mainContractRow["custCompyId"] = -1; mainContractRow["mainContractTag"] = string.Empty; mainContractRow["cash"] = string.Empty; mainContractRow["dateLine"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"); mainContractRow["paymentMode"] = string.Empty; mainContractTable.Rows.Add(mainContractRow); Session["mainContractTable"] = mainContractTable; } else { mainContractTable = Session["mainContractTable"] as DataTable; } ddlCustComp.SelectedValue = mainContractTable.Rows[0]["custCompyId"].ToString(); txtMainContractTag.Text = mainContractTable.Rows[0]["mainContractTag"].ToString(); txtMoney.Text = mainContractTable.Rows[0]["cash"].ToString(); btnDate.Text = mainContractTable.Rows[0]["dateLine"].ToString(); txtPayment.Text = mainContractTable.Rows[0]["paymentMode"].ToString(); #endregion #region mainProductGV if (null == Session["mainProductSelDs"]) { } else { DataTable dt = Session["mainProductSelDs"] as DataTable; string strFilter = " checkOrNot = " + "'" + bool.TrueString + "'"; dt.DefaultView.RowFilter = strFilter; mainProductGV.DataSource = dt; mainProductGV.DataBind(); } #endregion #region ddlProjectTable string usrId = Session["usrId"] as string; ProjectTagProcess ddlProjectView = new ProjectTagProcess(dst); ddlProjectView.RealProjTagView(usrId); DataTable ddlProjectTable = ddlProjectView.MyDst.Tables["projectTag_view"].DefaultView.ToTable(); DataColumn[] projectKey = new DataColumn[1]; projectKey[0] = ddlProjectTable.Columns["projectTagId"]; ddlProjectTable.PrimaryKey = projectKey; Session["ddlProjectDtS"] = ddlProjectTable; dr = ddlProjectTable.NewRow(); dr["projectTagId"] = -1; dr["projectTag"] = string.Empty; dr["endTime"] = "9999-12-31"; dr["applymentUsrId"] = usrId; dr["custCompyId"] = -1; ddlProjectTable.Rows.Add(dr); ddlProjectTag.DataValueField = "projectTagId"; ddlProjectTag.DataTextField = "projectTag"; ddlProjectTag.DataSource = ddlProjectTable; ddlProjectTag.DataBind(); ddlProjectTag.SelectedValue = mainContractTable.Rows[0]["projectTagId"].ToString();; #endregion } }