예제 #1
0
        private void BindGrid()
        {
            PmsRequirementBiz pmsRequirementBiz = new PmsRequirementBiz();
            PmsRequirement    pmsRequirement    = new PmsRequirement();

            pmsRequirement.RequirementPeriod  = DropDownListWeekPeriod.SelectedValue;
            GridViewRequirement.EmptyDataText = "No Data.";
            IList <PmsRequirement> pmsRequirementList = pmsRequirementBiz.GetPmsRequirementByWeekPeriod(pmsRequirement);

            GridViewRequirement.DataSource = pmsRequirementList;
            GridViewRequirement.DataBind();
        }
예제 #2
0
        private void SaveExcelDataSet(DataSet dsExcel)
        {
            IList <PmsRequirement> listPmsRequirement = GetPmsRequirementList(dsExcel);

            IList <PmsHeadCount> listPmsHeadCount = GetPmsHeadCountList(dsExcel);                            //取得HeadCount数据,Department

            IList <PmsHeadCountByContent> listPmsHeadCountByContent = GetPmsHeadCountByContentList(dsExcel); //取得HeadCount数据,Content

            if (listPmsRequirement != null && listPmsHeadCount != null && listPmsHeadCountByContent != null)
            {
                PmsRequirementBiz pmsRequirementBiz = new PmsRequirementBiz();
                pmsRequirementBiz.InsertPmsRequirement(listPmsRequirement, listPmsHeadCount, listPmsHeadCountByContent);
            }
        }
예제 #3
0
        protected void GridViewRequirement_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            int    currentRowIndex = int.Parse(e.CommandArgument.ToString());
            string commandName     = e.CommandName;

            switch (commandName)
            {
            case "Edit":
                GridViewRequirement.EditIndex = currentRowIndex;
                BindGrid();
                break;

            case "Update":
                TextBox textBoxCRId = (TextBox)GridViewRequirement.Rows[currentRowIndex].FindControl("textBoxCRId");
                string  crId        = Server.HtmlDecode(textBoxCRId.Text).Trim();
                if (!CheckUpdate(crId))
                {
                    return;
                }
                DropDownList      dropDownListStatus = (DropDownList)GridViewRequirement.Rows[currentRowIndex].FindControl("DropDownListStatus");
                string            status             = Server.HtmlDecode(dropDownListStatus.SelectedValue).Trim();
                int               serial             = int.Parse(GridViewRequirement.DataKeys[currentRowIndex]["Serial"].ToString());
                PmsRequirementBiz pmsRequirementBiz  = new PmsRequirementBiz();
                PmsRequirement    pmsRequirement     = new PmsRequirement();
                pmsRequirement.Serial       = serial;
                pmsRequirement.CrId         = crId;
                pmsRequirement.Status       = status;
                pmsRequirement.Maintaindate = System.DateTime.Now;
                pmsRequirement.Maintainuser = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", ".");
                if (!pmsRequirementBiz.UpdatePmsRequirement(pmsRequirement))
                {
                    Msgbox("Update failed!");
                    return;
                }
                GridViewRequirement.EditIndex = -1;
                BindGrid();
                break;

            case "Cancel":
                GridViewRequirement.EditIndex = -1;
                BindGrid();
                break;

            default:
                break;
            }
        }
예제 #4
0
        protected void GridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            try
            {
                int rowIndex = e.RowIndex;
                int serial   = int.Parse(GridViewRequirement.DataKeys[rowIndex]["Serial"].ToString());

                PmsRequirementBiz pmsRequirementBiz = new PmsRequirementBiz();
                PmsRequirement    pmsRequirement    = new PmsRequirement();
                pmsRequirement.Vid          = "PZ";
                pmsRequirement.Serial       = serial;
                pmsRequirement.Maintaindate = System.DateTime.Now;
                pmsRequirement.Maintainuser = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", ".");
                pmsRequirementBiz.DeletePmsRequirement(pmsRequirement);

                BindGrid();
            }
            catch
            {
                Msgbox("Delete failure!");
            }
        }
예제 #5
0
        private void BindGrid()
        {
            PmsRequirementBiz pmsRequirementBiz = new PmsRequirementBiz();
            PmsRequirement    pmsRequirement    = new PmsRequirement();

            pmsRequirement.YearAndMonth      = Month;
            pmsRequirement.RequirementPeriod = Week;
            pmsRequirement.UserDept          = UserDept;
            pmsRequirement.Status            = Status;

            GridViewRequirement.EmptyDataText = "No Data.";
            IList <PmsRequirement> pmsRequirementList = pmsRequirementBiz.GetPmsRequirement(pmsRequirement);

            if (pmsRequirementList != null)
            {
                foreach (var requirement in pmsRequirementList)
                {
                    requirement.Status = Status;
                }
            }
            GridViewRequirement.DataSource = pmsRequirementList;
            GridViewRequirement.DataBind();
        }