Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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");
            }
        }
Ejemplo n.º 3
0
        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";
        }
Ejemplo n.º 4
0
        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";
            }
        }
Ejemplo n.º 5
0
        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
            }
        }