/*绑定主表信息*/
protected void BindMainInfo()
{
/*接受参数*/
string OrderNo = Request.QueryString["no"].ToString();
/*读取数据*/
DataTable dt = HRProxyBus.GetRepOrder(OrderNo);
/*绑定RPT*/
if (dt != null)
{
/*加载主报表*/
rd.Load(Server.MapPath(@"~/PrinttingModel/HumanManager/HRProxy.rpt"));
crViewer.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.HRProxy"));
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//绑定数据
rd.SetDataSource(dt);
rd.Refresh();
this.crViewer.ReportSource = rd;
rd.SetParameterValue("Today", "制表人：" + userInfo.EmployeeName);
}
}
protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
//获取数据
HRProxyModel searchModel = new HRProxyModel();
//设置查询条件
//企业编号
searchModel.ProxyCompanyCD = txtProxyNo.Value.Trim();
//企业名称
searchModel.ProxyCompanyName = txtProxyName.Value.Trim();
//重要程度
searchModel.Important = ddlImportant.SelectedItem.Value;
//合作关系
searchModel.Cooperation = ddlCooperation.SelectedItem.Value;
//启用状态
searchModel.UsedStatus = ddlUsedStatus.SelectedItem.Value;
DataTable dt = HRProxyBus.SearchProxyInfo(searchModel);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "企业编号", "企业名称", "联系人", "固定电话", "移动电话", "网络通讯", "重要程度", "合作关系", "启用状态" },
new string[] { "ProxyCompanyCD", "ProxyCompanyName", "ContactName", "ContactTel", "ContactMobile", "ContactWeb", "Important", "Cooperation", "UsedStatus" },
"人才代理列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
/// <summary>
/// 设置人才代理信息
/// </summary>
/// <param name="proxyID">人才代理公司ID</param>
private void InitProxyInfo(string proxyID)
{
//查询人才代理信息
DataTable dtProxy = HRProxyBus.GetProxyInfoWithID(proxyID);
//数据存在时
if (dtProxy != null && dtProxy.Rows.Count > 0)
{
/* 代理公司信息设置 */
//设置人才代理编号
divProxyCompanyNo.InnerText = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "ProxyCompanyCD");
//企业名称
txtProxyCompanyName.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "ProxyCompanyName");
//企业性质
txtNature.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Nature");
//地址
txtAddress.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Address");
//企业法人
txtCorporate.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Corporate");
//合作关系
ddlCooperation.SelectedValue = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Cooperation");
//电话
txtTel.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Telephone");
//传真
txtFax.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Fax");
//邮箱
txtMail.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Email");
//网址
txtWebsite.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Website");
//重要程度
ddlImportant.SelectedValue = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Important");
//启用状态
ddlUsedStatus.SelectedValue = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "UsedStatus");
//string usedStatus = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "UsedStatus");
////启用时
//if (ConstUtil.USED_STATUS_ON.Equals(usedStatus))
//{
// chkUsedStatus.Checked = true;
//}
//else
//{
// chkUsedStatus.Checked = false;
//}
//收费标准
txtStandard.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Standard");
/* 代理公司联系人信息 */
//姓名
txtContactName.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "ContactName");
//固定电话
txtContactTel.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "ContactTel");
//移动电话
txtContactMobile.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "ContactMobile");
//网络通讯
txtContactWeb.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "ContactWeb");
//工号
txtContactCardNo.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "ContactCardNo");
//公司职务
txtContactPosition.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "ContactPosition");
//备注
txtContactRemark.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "ContactRemark");
/* 附加信息 */
txtAdditional.Text = GetSafeData.ValidateDataRow_String(dtProxy.Rows[0], "Remark");
}
}
