protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e)
{
int projectid = Convert.ToInt32(ddlProject.SelectedValue);
MainProjectCreateInfo project = new MainProjectCreateInfo(projectid);
lblProjectNum.Text = project.SheetNum.ToString();
}
protected void PageInit()
{
int opid = Convert.ToInt32(Request["OfferPriceId"].ToString());
OfferPriceInfo op = new OfferPriceInfo(opid);
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(op.MainProjectCreateId));
lblProject.Text = project.ProjectName;
lblProjectNum.Text = project.SheetNum;
EmployeeInfo em = new EmployeeInfo(Convert.ToInt32(op.EmployeeId));
lblEmployee.Text = em.EmployeeName.ToString();
lblFillTableDate.Text = op.FillTableDate.ToString();
lblSheetNum.Text = op.SheetNum.ToString();
txtSectionView.ReadOnly = true;
txtManagerView.Text = op.MangerView.ToString();
txtSectionView.Text = op.SectionView.ToString();
rblType.SelectedValue = op.OfferPriceTypeId.ToString();
txtProjectDes.Text = op.ProjectDes.ToString();
if (op.OfferFileId.ToString() == "")
{
btnDownLoad.Enabled = false;
}
if (op.MoneySum != null)
{
lblMoneySum.Text = op.MoneySum.ToString();
}
if (op.BigMoney != null)
{
lblBigMoney.Text = op.BigMoney.ToString();
}
}
protected void PageInit()
{
int wkid = Convert.ToInt32(Request["SpecialExpId"].ToString());
SpecialExpInfo sp = new SpecialExpInfo(wkid);
lblApplyDate.Text = sp.ApplyDate.ToString();
lblApplyPeople.Text = sp.ApplyPeople.ToString();
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(sp.MainProjectCreateId));
lblMoneyNum.Text = project.PreMoney.ToString();
lblProject.Text = project.ProjectName.ToString();
txtReason.Text = sp.ApplyReason.ToString();
if (sp.ProjectStepId.ToString() != "")
{
ProjectStepInfo step = new ProjectStepInfo(Convert.ToInt32(sp.ProjectStepId));
lblStep.Text = step.ProjectStepName.ToString();
}
lblApplyMoney.Text = sp.ApplyMoney.ToString();
lblSheetNum.Text = sp.SheetNum.ToString();
if (sp.SignName == 1)
{
imgMarket.Visible = true;
}
else if (sp.SignName == 2)
{
imgMarket.Visible = true;
imgManager.Visible = true;
}
}
protected void SpecialBind()
{
int wkid = Convert.ToInt32(Request["SpecialExpId"].ToString());
SpecialExpInfo sp = new SpecialExpInfo(wkid);
lblApplyDate.Text = sp.ApplyDate.ToString();
lblApplyPeople.Text = sp.ApplyPeople.ToString();
lblApplyMoney.Text = sp.ApplyMoney.ToString();
lblSheetNum.Text = sp.SheetNum.ToString();
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(sp.MainProjectCreateId));
lblMoneyNum.Text = project.PreMoney.ToString();
lblProject.Text = project.ProjectName.ToString();
lblReason.Text = sp.ApplyReason.ToString();
if (sp.ProjectStepId.ToString() != "")
{
ProjectStepInfo step = new ProjectStepInfo(Convert.ToInt32(sp.ProjectStepId));
lblStep.Text = step.ProjectStepName.ToString();
}
}
protected void PageInit()
{
txtManagerView.ReadOnly = true;
int opid = Convert.ToInt32(Request["OfferPriceId"].ToString());
OfferPriceInfo op = new OfferPriceInfo(opid);
ddlProject.SelectedValue = op.MainProjectCreateId.ToString();
ddlEmployee.SelectedValue = op.EmployeeId.ToString();
txtFillTableDate.Text = op.FillTableDate.ToString();
txtManagerView.Text = op.MangerView.ToString();
txtSectionView.Text = op.SectionView.ToString();
txtSheetNum.Text = op.SheetNum.ToString();
txtProjectDes.Text = op.ProjectDes.ToString();
rblType.SelectedValue = op.OfferPriceTypeId.ToString();
lblMoneySum.Text = op.ProductMoneySum.ToString();
if (op.MoneySum != null)
{
txtMoneySum.Text = op.MoneySum.ToString();
}
if (op.BigMoney != null)
{
txtBigMoney.Text = op.BigMoney.ToString();
}
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(op.MainProjectCreateId));
lblProjectNum.Text = project.SheetNum.ToString();
if (op.OfferFileId != null)
{
OfferFileInfo of = new OfferFileInfo(Convert.ToInt32(op.OfferFileId));
lblUrl.Text = of.PhyFileName.ToString();
}
}
protected void gvProject_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int projectid = Convert.ToInt32(gvProject.DataKeys[e.RowIndex].Value);
TextBox txtProjectName = gvProject.Rows[e.RowIndex].FindControl("txtProjectName") as TextBox;
TextBox txtPreMoney = gvProject.Rows[e.RowIndex].FindControl("txtPreMoney") as TextBox;
TextBox txtPreProfit = gvProject.Rows[e.RowIndex].FindControl("txtPreProfit") as TextBox;
DropDownList ddlProjectLevel = gvProject.Rows[e.RowIndex].FindControl("ddlProjectLevel") as DropDownList;
DropDownList ddlProjectType = gvProject.Rows[e.RowIndex].FindControl("ddlProjectType") as DropDownList;
DropDownList ddlClient = gvProject.Rows[e.RowIndex].FindControl("ddlClient") as DropDownList;
try
{
MainProjectCreateInfo project = new MainProjectCreateInfo(projectid);
project.ProjectName = txtProjectName.Text.ToString();
project.PreMoney = txtPreMoney.Text.ToString();
project.PreProfit = txtPreProfit.Text.ToString();
project.ProjectLevelId = Convert.ToInt32(ddlProjectLevel.SelectedValue);
project.ProjectTypeId = Convert.ToInt32(ddlProjectType.SelectedValue);
project.ClientId = Convert.ToInt32(ddlClient.SelectedValue);
project.Save();
gvProject.EditIndex = -1;
gvDataBind();
}
catch (Exception Ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('更新失败：" + Ex.Message + "');", true);
}
}
protected void gvProject_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int projectId = Convert.ToInt32(gvProject.DataKeys[e.RowIndex].Value);
MainProjectCreateInfo.DelProject(projectId);
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 ddlProject_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlProject.SelectedItem.Text == "请选择项目名称")
{
lblMoneyNum.Text = "";
}
else
{
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(ddlProject.SelectedValue));
lblMoneyNum.Text = project.PreMoney.ToString();
}
}
protected void ddlProjectBind()
{
DataTable dt = MainProjectCreateInfo.getProjectList();
ddlProject.DataSource = dt;
ddlProject.DataTextField = "ProjectName";
ddlProject.DataValueField = "MainProjectCreateId";
DataRow row = dt.NewRow();
row["ProjectName"] = "请选择项目名称";
dt.Rows.InsertAt(row, 0);
ddlProject.DataBind();
}
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);
}
}
}
protected void gvDataBind()
{
DataTable dt = MainProjectCreateInfo.getProjectList();
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, gvProject, AspNetPager1);
gvProject.Rows[0].Visible = false;
}
else
{
UI.BindCtrl(dt.DefaultView, gvProject, AspNetPager1);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (IsPageValid())
{
try
{
MainProjectCreateInfo project = new MainProjectCreateInfo();
project.PreMoney = txtPreMoney.Text.ToString();
project.PreProfit = txtPreProfit.Text.ToString();
project.ProjectLevelId = Convert.ToInt32(ddlProjectLevel.SelectedValue);
project.ProjectTypeId = Convert.ToInt32(ddlProjectType.SelectedValue);
project.ClientId = Convert.ToInt32(ddlClient.SelectedValue);
project.ProjectName = txtProjectName.Text.ToString();
project.SheetNum = txtSheetNum.Text.ToString();
project.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 PageInit()
{
EmployeeInfo em = (EmployeeInfo)Session["Employee"];
lblApplyPeople.Text = em.EmployeeName;
int id = Convert.ToInt32(Request["SpecialExpId"].ToString());
SpecialExpInfo sp = new SpecialExpInfo(id);
txtApplyMoney.Text = sp.ApplyMoney.ToString();
txtApplyDate.Text = sp.ApplyDate.ToString();
txtReason.Text = sp.ApplyReason.ToString();
if (sp.MainProjectCreateId.ToString() != "")
{
ddlProject.SelectedValue = sp.MainProjectCreateId.ToString();
}
if (sp.ProjectStepId.ToString() != "")
{
ddlProjectStep.SelectedValue = sp.ProjectStepId.ToString();
}
MainProjectCreateInfo project = new MainProjectCreateInfo(Convert.ToInt32(sp.MainProjectCreateId));
lblMoneyNum.Text = project.PreMoney.ToString();
txtSheetNum.Text = sp.SheetNum.ToString();
string strRoleName = Session["RoleName"].ToString();
PositionInfo position = new PositionInfo(Convert.ToInt32(em.PositionId));
if (strRoleName == "员工" || position.PositionName == "综合主管")
{
btnSign.Enabled = false;
btnSign.Visible = false;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string ProjectName = txtProjectName.Text.ToString();
if (ProjectName != "" && ddlProjectLevel.SelectedValue == "")
{
DataTable dt = MainProjectCreateInfo.getNameOfProject(ProjectName);
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, gvProject, AspNetPager1);
gvProject.Rows[0].Visible = false;
}
else
{
UI.BindCtrl(view, gvProject, AspNetPager1);
}
}
else if (ddlProjectLevel.SelectedValue != "" && ProjectName == "")
{
DataTable dt = MainProjectCreateInfo.getLevelOfProject(ddlProjectLevel.SelectedItem.Text);
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, gvProject, AspNetPager1);
gvProject.Rows[0].Visible = false;
}
else
{
UI.BindCtrl(view, gvProject, AspNetPager1);
}
}
else if (ddlProjectLevel.SelectedValue != "" && ProjectName != "")
{
DataTable dt = MainProjectCreateInfo.getBothOfProject(ProjectName, ddlProjectLevel.SelectedItem.Text);
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, gvProject, AspNetPager1);
gvProject.Rows[0].Visible = false;
}
else
{
UI.BindCtrl(view, gvProject, AspNetPager1);
}
}
else
{
gvDataBind();
}
}