protected void btn_Save_Click(object sender, EventArgs e)
{
int id = WS.RequestInt("id");
//int userid = WS.RequestInt("uid");
DataEntities ent = new DataEntities();
JobCompany com = new JobCompany();
if (id > 0)
{
com = (from l in ent.JobCompany where l.ID == id select l).FirstOrDefault();
}
com.CompanyName = txt_CompanyName.Text;
com.CompanyType = ddl_CompanyType.SelectedValue.ToInt32();
com.EmployeeCount = ddl_EmployeeCount.SelectedValue.ToInt32();
com.Industry = txt_Industry.Text;
com.Intro = txt_Intro.Text;
com.UserID = ddl_User.SelectedValue.ToInt32();
com.DayClick = txt_DayClick.Text.ToInt32(0);
com.IsSetTop = chk_Settop.Checked;
com.SetTopTime = DateTime.Now;
com.MailAddress = txt_MailAddress.Text;
if (id > 0 && com != null)
{
}
else
{
ent.AddToJobCompany(com);
}
ent.SaveChanges();
ent.Dispose();
Js.AlertAndChangUrl("保存成功！","List.aspx");
}
protected void LoadInfo()
{
long id = WS.RequestLong("id");
if (id < 0)
{
return;
}
DataEntities ent = new DataEntities();
Comapny = (from l in ent.JobCompany where l.ID == id select l).FirstOrDefault();
CompanyName = Comapny.CompanyName;
Industry = Comapny.Industry;
CompanyType = JobAction.GetCompanyTypeName(Comapny.CompanyType.ToInt32());
EmployeeCount = JobAction.GetEmployeeCountName(Comapny.EmployeeCount.ToInt32());
Intro = Comapny.Intro;
Comapny.DayClick += 1;
ent.SaveChanges();
var db_list = from p in ent.JobPost
from c in ent.JobCompany
from pro in ent.Province
from ct in ent.City
where p.CompanyID == c.ID
&& p.Province == pro.ID
&& p.City == ct.id
select new
{
p.City,
p.CompanyID,
p.Edu,
p.PostTime,
p.EmployNumber,
p.Expressions,
p.ID,
p.Intro,
p.Province,
p.Salary,
p.Title,
c.CompanyName,
c.Industry,
c.EmployeeCount,
ProvinceName = pro.province1,
CityName = ct.city1
};
db_list = from l in db_list where l.CompanyID == id select l;
pager.RecordCount = db_list.Count();
int page = WS.RequestInt("page", 1);
db_list = db_list.OrderByDescending(p => p.ID).Skip((page - 1) * pager.PageSize).Take(pager.PageSize);
pager.UrlRewritePattern = "Company.aspx?id="+ WS.RequestString("id") +"&page={0}";
// pager.CurrentPageIndex = page;
if (db_list.Count() == 0)
{
return;
}
var list = from l in db_list.ToList()
from e in JobAction.EmployeeCount
from ed in JobAction.Edu
from ex in JobAction.Expressions
from sa in JobAction.SalaryDegree
where l.EmployeeCount == e.Key
&& l.Edu == ed.Key
&& l.Expressions == ex.Key
&& l.Salary == sa.Key
select new
{
l.City,
l.CompanyID,
Edu = ed.Value,
l.PostTime,
l.EmployNumber,
Expressions = ex.Value,
l.ID,
l.Intro,
l.Province,
Salary = sa.Value,
l.Title,
l.CompanyName,
l.Industry,
EmployeeCount = e.Value
};
rp_list.DataSource = list;
rp_list.DataBind();
ent.Dispose();
}
