protected void btnSave_Click(object sender, EventArgs e) { if (rblOver.SelectedIndex == -1) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('请选择修正或通过!');</script>"); } else { try { int cid = Convert.ToInt32(Request["ProjectCreateId"].ToString()); ProjectCreateInfo pc = new ProjectCreateInfo(cid); pc.TechView = txtTechView.Text.ToString(); pc.MarketView = txtMarketView.Text.ToString(); if (rblOver.Items[0].Selected) { pc.State = 2; pc.Save(); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('您让申请人修正!');</script>"); } else if (rblOver.Items[1].Selected) { pc.State = 6; pc.Save(); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('审批通过!');</script>"); } } catch (Exception Ex) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('保存失败:" + Ex.Message + "');", true); } } }
protected void gvSale_RowDeleting(object sender, GridViewDeleteEventArgs e) { int cid = Convert.ToInt32(gvSale.DataKeys[e.RowIndex].Value); ProjectCreateInfo.DelProjectApply(cid); gvDataBind(); }
protected void ProjectCreateBind() { int wkid = Convert.ToInt32(Request["ProjectCreateId"].ToString()); ProjectCreateInfo pc = new ProjectCreateInfo(wkid); ddlClient.SelectedValue = pc.ClientId.ToString(); ddlYewu.SelectedValue = pc.YeWuId.ToString(); ddlProjectType.SelectedValue = pc.ProjectTypeId.ToString(); ddlProjectLevel.SelectedValue = pc.ProjectLevelId.ToString(); lblApplyName.Text = pc.ApplyName.ToString(); lblApplyDepart.Text = pc.DepartName.ToString(); lblProjectNum.Text = pc.SheetNum.ToString(); txtProjectName.Text = pc.ProjectName.ToString(); txtPreMoney.Text = pc.PreMoney.ToString(); txtPreProfit.Text = pc.PreProfit.ToString(); txtSheetNum.Text = pc.SheetNum.ToString(); txtApplyDate.Text = pc.ApplyDate.ToString(); txtBusinessDes.Text = pc.BusinessDescribe.ToString(); txtCallBidPhaseExp.Text = pc.CallbidPhaseExp.ToString(); txtCarryPhaseExp.Text = pc.CarryPhaseExp.ToString(); txtClientDes.Text = pc.ClientDescribe.ToString(); txtCompitDes.Text = pc.CompitDescribe.ToString(); txtCratePhaseExp.Text = pc.CreatePhaseExp.ToString(); txtManagerView.Text = pc.ManagerView.ToString(); txtMarketView.Text = pc.MarketView.ToString(); txtMemo.Text = pc.Memo.ToString(); txtNeedDes.Text = pc.NeedDescribe.ToString(); txtProposePhaseExp.Text = pc.ProposePhaseExp.ToString(); txtRiskDes.Text = pc.RiskDescribe.ToString(); txtStrategyDes.Text = pc.StrategyDesribe.ToString(); txtTalkPhaseExp.Text = pc.TalkPhaseExp.ToString(); txtTechDes.Text = pc.TechDescribe.ToString(); txtTechView.Text = pc.TechView.ToString(); }
protected void ddlDataBind() { DataTable dt = ProjectCreateInfo.getProjectLevel(); ddlProjectLevel.DataSource = dt; ddlProjectLevel.DataTextField = "ProjectLevelName"; ddlProjectLevel.DataValueField = "ProjectLevelId"; DataRow row = dt.NewRow(); row["ProjectLevelName"] = "请选择项目级别"; dt.Rows.InsertAt(row, 0); ddlProjectLevel.DataBind(); DataTable dt1 = ProjectCreateInfo.getProjectType(); ddlProjectType.DataSource = dt1; ddlProjectType.DataTextField = "ProjectTypeName"; ddlProjectType.DataValueField = "ProjectTypeId"; DataRow row1 = dt1.NewRow(); row1["ProjectTypeName"] = "请选择项目类别"; dt1.Rows.InsertAt(row1, 0); ddlProjectType.DataBind(); DataTable dt2 = ClientInfo.getClientList(); ddlClient.DataSource = dt2; ddlClient.DataTextField = "ClientName"; ddlClient.DataValueField = "ClientId"; DataRow row2 = dt2.NewRow(); row2["ClientName"] = "请选择客户名称"; dt2.Rows.InsertAt(row2, 0); ddlClient.DataBind(); }
protected void btnSubmit_Click(object sender, EventArgs e) { int fid = Convert.ToInt32(((Button)sender).CommandArgument.ToString()); ProjectCreateInfo pc = new ProjectCreateInfo(fid); pc.ApplyTime = DateTime.Now.ToString(); pc.State = 1; pc.Save(); gvDataBind(); }
protected void gvProject_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { //鼠标移动到每项时颜色交替效果 e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#c1ebff'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e"); //设置悬浮鼠标指针形状为"小手" e.Row.Attributes["style"] = "Cursor:hand"; if (!Convert.IsDBNull(gvProject.DataKeys[e.Row.RowIndex].Value)) { int projectid = Convert.ToInt32(gvProject.DataKeys[e.Row.RowIndex].Value); MainProjectCreateInfo project = new MainProjectCreateInfo(projectid); DropDownList ddlProjectLevel = e.Row.FindControl("ddlProjectLevel") as DropDownList; if (ddlProjectLevel != null) { DataTable dt = ProjectCreateInfo.getProjectLevel(); ddlProjectLevel.DataSource = dt; ddlProjectLevel.DataTextField = "ProjectLevelName"; ddlProjectLevel.DataValueField = "ProjectLevelId"; ddlProjectLevel.DataBind(); ddlProjectLevel.SelectedValue = project.ProjectLevelId.ToString(); } DropDownList ddlProjectType = e.Row.FindControl("ddlProjectType") as DropDownList; if (ddlProjectType != null) { DataTable dt = ProjectCreateInfo.getProjectType(); ddlProjectType.DataSource = dt; ddlProjectType.DataTextField = "ProjectTypeName"; ddlProjectType.DataValueField = "ProjectTypeId"; ddlProjectType.DataBind(); ddlProjectType.SelectedValue = project.ProjectTypeId.ToString(); } DropDownList ddlClient = e.Row.FindControl("ddlClient") as DropDownList; if (ddlClient != null) { DataTable dt = ClientInfo.getClientList(); ddlClient.DataSource = dt; ddlClient.DataTextField = "ClientName"; ddlClient.DataValueField = "ClientValue"; ddlClient.DataBind(); ddlClient.SelectedValue = project.ClientId.ToString(); } } } }
protected void SheetNum() { string strtoday = DateTime.Now.ToString("yyyyMMdd").Substring(2); if (ProjectCreateInfo.IsSheetNumOfPC(strtoday)) { txtSheetNum.Text = ProjectCreateInfo.SheetNumOfPC("LX", strtoday); } else { txtSheetNum.Text = "LX" + strtoday + "001"; } }
protected void ddlDataBind() { DataTable dt = ProjectCreateInfo.getProjectLevel(); ddlProjectLevel.DataSource = dt; ddlProjectLevel.DataTextField = "ProjectLevelName"; ddlProjectLevel.DataValueField = "ProjectLevelId"; DataRow row = dt.NewRow(); row["ProjectLevelName"] = "请选择项目级别"; dt.Rows.InsertAt(row, 0); ddlProjectLevel.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { if (IsPageValid()) { try { ProjectCreateInfo pc = new ProjectCreateInfo(); pc.ApplyName = Session["EmployeeName"].ToString(); pc.DepartName = Session["DepartName"].ToString(); pc.State = 0; pc.ApplyDate = txtApplyDate.Text.ToString(); pc.ApplyTime = ""; pc.ClientDescribe = txtClientDes.Text.ToString(); pc.CompitDescribe = txtCompitDes.Text.ToString(); pc.BusinessDescribe = txtBusinessDes.Text.ToString(); pc.NeedDescribe = txtNeedDes.Text.ToString(); pc.RiskDescribe = txtRiskDes.Text.ToString(); pc.StrategyDesribe = txtStrategyDes.Text.ToString(); pc.TechDescribe = txtTechDes.Text.ToString(); pc.CallbidPhaseExp = txtCallBidPhaseExp.Text.ToString(); pc.CarryPhaseExp = txtCarryPhaseExp.Text.ToString(); pc.CreatePhaseExp = txtCratePhaseExp.Text.ToString(); pc.ProposePhaseExp = txtProposePhaseExp.Text.ToString(); pc.TalkPhaseExp = txtTalkPhaseExp.Text.ToString(); pc.ClientId = Convert.ToInt32(ddlClient.SelectedValue); pc.MarketView = txtMarketView.Text.ToString(); pc.Memo = txtMemo.Text.ToString(); pc.PreMoney = txtPreMoney.Text.ToString(); pc.PreProfit = txtPreProfit.Text.ToString(); pc.ProjectLevelId = Convert.ToInt32(ddlProjectLevel.SelectedValue); pc.ProjectName = txtProjectName.Text.ToString(); pc.ProjectTypeId = Convert.ToInt32(ddlProjectType.SelectedValue); pc.SheetNum = lblProjectNum.Text.ToString(); pc.TechView = txtTechView.Text.ToString(); pc.Today = DateTime.Now.ToString("yyyyMMdd").Substring(2); pc.YeWuId = Convert.ToInt32(ddlYewu.SelectedValue); pc.Save(); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('添加成功!');</script>"); } catch (Exception Ex) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('添加失败:" + Ex.Message + "');", true); } } }
protected void gvDataBind() { DataTable dt = ProjectCreateInfo.getProjectApply(Session["EmployeeName"].ToString()); DataView view = dt.DefaultView; string sort = (string)ViewState["SortExpression"] + " " + (string)ViewState["SortDir"]; view.Sort = sort; if (dt.Rows.Count == 0) { dt.Rows.Add(dt.NewRow()); UI.BindCtrl(dt.DefaultView, gvSale, AspNetPager1); gvSale.Rows[0].Visible = false; } else { UI.BindCtrl(dt.DefaultView, gvSale, AspNetPager1); } }
protected void btnSubmit_Click(object sender, EventArgs e) { string strDepart = Session["DepartName"].ToString(); int fid = Convert.ToInt32(((Button)sender).CommandArgument.ToString()); ProjectCreateInfo pc = new ProjectCreateInfo(fid); pc.ApplyTime = DateTime.Now.ToString(); if (strDepart == "技术部") { pc.State = 3; } else { pc.State = 6; } pc.Save(); gvDataBind(); }
protected void btnSearch_Click(object sender, EventArgs e) { DataTable dt = ProjectCreateInfo.getProjectApplyOfClient(ddlClient.SelectedItem.Text, Session["EmployeeName"].ToString()); DataView view = dt.DefaultView; string sort = (string)ViewState["SortExpression"] + " " + (string)ViewState["SortDir"]; view.Sort = sort; if (dt.Rows.Count == 0) { dt.Rows.Add(dt.NewRow()); UI.BindCtrl(view, gvSale, AspNetPager1); gvSale.Rows[0].Visible = false; } else { UI.BindCtrl(view, gvSale, AspNetPager1); } }
protected void btnSave_Click(object sender, EventArgs e) { if (rblOver.SelectedIndex == -1) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('请选择修正或通过!');</script>"); } else { try { int cid = Convert.ToInt32(Request["ProjectCreateId"].ToString()); ProjectCreateInfo pc = new ProjectCreateInfo(cid); pc.ManagerView = txtManagerView.Text.ToString(); if (rblOver.Items[0].Selected) { pc.State = 5; pc.Save(); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('您让申请人修正!');</script>"); } else if (rblOver.Items[1].Selected) { pc.State = 4; pc.Save(); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('审批通过!');</script>"); MainProjectCreateInfo p = new MainProjectCreateInfo(); p.ClientId = Convert.ToInt32(pc.ClientId); p.PreMoney = pc.PreMoney.ToString(); p.PreProfit = pc.PreProfit.ToString(); p.ProjectLevelId = Convert.ToInt32(pc.ProjectLevelId); p.ProjectName = pc.ProjectName.ToString(); p.ProjectTypeId = Convert.ToInt32(pc.ProjectTypeId); p.SheetNum = pc.SheetNum.ToString(); p.YeWuId = Convert.ToInt32(pc.YeWuId); p.Save(); } } catch (Exception Ex) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('保存失败:" + Ex.Message + "');", true); } } }
private void PageBind() { int pid = Convert.ToInt32(Request["ProjectCreateId"].ToString()); ProjectCreateInfo pc = new ProjectCreateInfo(pid); ClientInfo client = new ClientInfo(Convert.ToInt32(pc.ClientId)); ProjectTypeInfo type = new ProjectTypeInfo(Convert.ToInt32(pc.ProjectTypeId)); ProjectLevelInfo level = new ProjectLevelInfo(Convert.ToInt32(pc.ProjectLevelId)); YeWuInfo yw = new YeWuInfo(Convert.ToInt32(pc.YeWuId)); lblClientName.Text = client.ClientName.ToString(); lblProjectType.Text = type.ProjectTypeName.ToString(); lblProjectLevel.Text = level.ProjectLevelName.ToString(); lblYewu.Text = yw.YeWuName.ToString(); lblSheetNums.Text = pc.SheetNum.ToString(); lblProjectFullName.Text = pc.ProjectName.ToString(); lblProjectNum.Text = pc.SheetNum.ToString(); lblPredictMoney.Text = pc.PreMoney.ToString(); lblPredictProfit.Text = pc.PreProfit.ToString(); lblApplyDate.Text = pc.ApplyDate.ToString(); lblApplyName.Text = pc.ApplyName.ToString(); lblApplyDepart.Text = pc.DepartName.ToString(); txtBusinessDes.Text = pc.BusinessDescribe.ToString(); lblCallBidPhaseExp.Text = pc.CallbidPhaseExp.ToString(); lblCarryPhaseExp.Text = pc.CarryPhaseExp.ToString(); txtClientDes.Text = pc.ClientDescribe.ToString(); txtCompitDes.Text = pc.CompitDescribe.ToString(); lblCratePhaseExp.Text = pc.CreatePhaseExp.ToString(); txtManagerView.Text = pc.ManagerView.ToString(); txtMemo.Text = pc.Memo.ToString(); txtNeedDes.Text = pc.NeedDescribe.ToString(); lblProjectFullName.Text = pc.ProjectName; lblProposePhaseExp.Text = pc.ProposePhaseExp.ToString(); txtRiskDes.Text = pc.RiskDescribe.ToString(); txtStrategyDes.Text = pc.StrategyDesribe.ToString(); lblTalkPhaseExp.Text = pc.TalkPhaseExp.ToString(); txtTechDes.Text = pc.TechDescribe.ToString(); txtTechView.Text = pc.TechView.ToString(); txtMarketView.Text = pc.MarketView.ToString(); }
protected void gvSale_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { //鼠标移动到每项时颜色交替效果 e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#c1ebff'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e"); //设置悬浮鼠标指针形状为"小手" e.Row.Attributes["style"] = "Cursor:hand"; if (!Convert.IsDBNull(gvSale.DataKeys[e.Row.RowIndex].Value)) { int cid = Convert.ToInt32(gvSale.DataKeys[e.Row.RowIndex].Value); ProjectCreateInfo pc = new ProjectCreateInfo(cid); if (pc.State != 1) { Button btnSubmit = e.Row.FindControl("btnSubmit") as Button; btnSubmit.Enabled = false; } Label lblState = e.Row.FindControl("lblState") as Label; switch (pc.State) { case 0: lblState.Text = "未提交"; break; case 1: lblState.Text = "待部门领导审批"; break; case 2: lblState.Text = "部门:修正"; break; case 3: lblState.Text = "待总经理审批"; break; case 4: lblState.Text = "通过"; break; case 5: lblState.Text = "总经理:修正"; break; case 6: lblState.Text = "待技术部审批"; break; case 7: lblState.Text = "技术部修正"; break; default: lblState.Text = "其他状态"; break; } } } }