/// <summary>
/// 页面加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (ActionValidator("Contract"))
{
var query = DbHelperSql.Query("select DISTINCT EnterpriseName from Eenterprises where Audit='已通过'");
DropDownList_qy.DataSource = query;
DropDownList_qy.DataTextField = "EnterpriseName";
DropDownList_qy.DataValueField = "EnterpriseName";
DropDownList_qy.DataBind();
if (!string.IsNullOrEmpty(Request.QueryString["ContractName"]))
{
var entity = DbHelperSql.Query("select * from Contract where ContractName='" + Request.QueryString["ContractName"] + "'");
txtTrueName.Text = entity.Tables[0].Rows[0]["ContractName"].ToString();
time.Text = entity.Tables[0].Rows[0]["CInformation"].ToString(); //签订时间
time2.Text = entity.Tables[0].Rows[0]["LastTime"].ToString(); //到期时间
TextBox_JE.Text = entity.Tables[0].Rows[0]["Money"].ToString(); //金额
txtj.Text = entity.Tables[0].Rows[0]["ConsigneeA"].ToString();
txty.Text = entity.Tables[0].Rows[0]["ConsigneeB"].ToString();
txtb.Text = entity.Tables[0].Rows[0]["Note"].ToString();
DropDownList_qy.SelectedValue = entity.Tables[0].Rows[0]["EnterpriseName"].ToString();
}
}
else
{
AlertAndParentSkip("没有权限", "ContractList");
}
}
}
/// <summary>
/// 页面加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (ActionValidator("EmployeeAdd"))
{
//绑定企业下拉列表框
var query = DbHelperSql.Query("select DISTINCT EnterpriseName from Eenterprises where Audit='已通过'");
DropDownList_qy.DataSource = query;
DropDownList_qy.DataTextField = "EnterpriseName";
DropDownList_qy.DataValueField = "EnterpriseName";
DropDownList_qy.DataBind();
//判断是否为修改操作
if (!string.IsNullOrEmpty(Request.QueryString["EID"]))
{
var model = _employeeBLL.GetModel(int.Parse(Request.QueryString["EID"]));
DropDownList_qy.SelectedValue = model.EnterpriseName;
DropDownListXM.SelectedValue = model.ProjectName;
TextBoxName.Text = model.EmployeeName;
person_time.Text = model.EmployeeTime;
txty.Text = model.Note;
}
}
else
{
AlertAndParentSkip("没有权限", "EmployeeList");
}
}
}
/// <summary>
/// 页面加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
if (!ActionValidator("ProjectAdd"))
{
return;
}
//帮定已经通过的企业到下拉列表控件
var query = DbHelperSql.Query("select DISTINCT EnterpriseName from Eenterprises where Audit='已通过'");
DropDownList_qy.DataSource = query;
DropDownList_qy.DataTextField = "EnterpriseName";
DropDownList_qy.DataValueField = "EnterpriseName";
DropDownList_qy.DataBind();
//判断是否为修改操作
if (string.IsNullOrEmpty(Request.QueryString["ProjectID"]))
{
return;
}
DataSet dsProject = DbHelperSql.Query("select * from Project where ProjectID='" + Request.QueryString["ProjectID"] + "'");
if (dsProject.Tables[0].Rows.Count > 0)
{
txtTrueName.Text = dsProject.Tables[0].Rows[0]["ProjectName"].ToString();
person.Text = dsProject.Tables[0].Rows[0]["PersonInCharge"].ToString();
txty.Text = dsProject.Tables[0].Rows[0]["Note"].ToString();
DropDownList_qy.SelectedValue = dsProject.Tables[0].Rows[0]["EnterpriseName"].ToString();
}
else
{
AlertAndParentReoload("该数据不存在，请检查后重试！");
}
}
/// <summary>
/// 页面加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
if (ActionValidator("FinancialAdd"))
{
var query = DbHelperSql.Query("select DISTINCT EnterpriseName from Eenterprises where Audit='已通过'");
DropDownList_qy.DataSource = query;
DropDownList_qy.DataTextField = "EnterpriseName";
DropDownList_qy.DataValueField = "EnterpriseName";
DropDownList_qy.DataBind();
var entity = DbHelperSql.Query("select DISTINCT ProjectName from Project ");
DropDownListXM.DataSource = entity;
DropDownListXM.DataTextField = "ProjectName";
DropDownListXM.DataValueField = "ProjectName";
DropDownListXM.DataBind();
if (!string.IsNullOrEmpty(Request.QueryString["FID"]))
{
var data = DbHelperSql.Query("select * from Financial where FID='" + Request.QueryString["FID"] + "'");
txtTrueMoney.Text = data.Tables[0].Rows[0]["PayMoney"].ToString();
FZperson.Text = data.Tables[0].Rows[0]["Person"].ToString();
DropDownList2.SelectedValue = data.Tables[0].Rows[0]["IsPay"].ToString();
time.Text = data.Tables[0].Rows[0]["SuccessfulTime"].ToString();
note.Text = data.Tables[0].Rows[0]["Note"].ToString();
//项目
DropDownListXM.SelectedValue = data.Tables[0].Rows[0]["ProjectName"].ToString();
//企业
DropDownList_qy.SelectedValue = data.Tables[0].Rows[0]["EnterpriseName"].ToString();
}
}
else
{
AlertAndParentSkip("没有权限", "FinancialList");
}
}
