private IQueryable getCarrer(string type, int id)
{
IQueryable q;
ResumeInfoDataContext db = new ResumeInfoDataContext();
if (type.Equals("1") || type.Equals("2"))
{
q = from m in db.Career
where (m.cid == id)
select new { dname = m.Department.dname, m.cmail, m.ctransfer, m.cname, m.cpot, m.ccontent, m.cquality };
}
else if (type.Equals("3") || type.Equals("4"))
{
q = from m in db.Career
where (m.cid == id)
select new { m.cname, m.cpot, m.ceducation, m.cnumber };
}
else
{
q = null;
}
return(q);
}
private void FillNewForm()
{
ResumeInfoDataContext db = new ResumeInfoDataContext();
WebHelper.FillEnuList(Sex.List, db, typeof(enuSex), true, "");
WebHelper.FillEnuList(zzmm.List, db, typeof(enuZzmm), true, "");
WebHelper.FillEnuList(hyzk.List, db, typeof(enuHyzk), true, "");
WebHelper.FillEnuList(qwxc.List, db, typeof(enuQwyx), true, "");
WebHelper.FillEnuList(zc.List, db, typeof(enuZc), true, "");
WebHelper.FillEnuList(jyjd.List, db, typeof(enuJyjd), true, "");
WebHelper.FillEnuList(zg.List, db, typeof(enuZg), true, "");
WebHelper.FillEnuList(cszy.List, db, typeof(enuZy), true, "");
WebHelper.FillEnuList(gzdd1.List, db, typeof(enuGzdd), true, "");
WebHelper.FillEnuList(gzdd2.List, db, typeof(enuGzdd), true, "");
WebHelper.FillEnuList(gzdd3.List, db, typeof(enuGzdd), true, "");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
WebHelper.IsSessionValid(Session, Response);
if (Request.QueryString["es"] != null)
{
pantip.Visible = false;
}
int id = 0;
if (Request.QueryString["id"] != null)
{
if (int.Parse(Session["UserType"].ToString()) > 1)
{
Response.Redirect("~/NoUser.htm");
}
id = int.Parse(Request.QueryString["id"]);
}
else
{
id = int.Parse(Session["UserID"].ToString());
}
ViewState["userid"] = id;
imgPhoto.ImageUrl = "ShowPhoto.aspx?id=" + id;
ResumeInfoDataContext db = new ResumeInfoDataContext();
FillForm(db, id);
gvJybj.FillGrid(JybjQuery(db, id));
gvZyzg.FillGrid(ZyzgQuery(db, id));
gvGzsx.FillGrid(GzsxQuery(db, id));
gvGzsxnr.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
gvGzsxnr.Attributes.Add("style", "word-break:break-all;word-wrap:break-word");
gvGzsxnr.FillGrid(GzsxnrQuery(db, id));
gvJtshgx.FillGrid(JtshgxQuery(db, id));
gvFileInfo.FillGrid(FileInfoQuery(db, id));
}
}
private int getJobCountOnCondition(string major, string pot)
{
ResumeInfoDataContext db = new ResumeInfoDataContext();
if (major.Equals("") && pot.Equals(""))
{
if (Request["type"] == "4")
{
return((from m in db.Career
where m.ctype == int.Parse((Request["type"])) && m.cvalid == true && m.cdisplay == true
select new { m.cid, m.cname, m.cpot }).Count());
}
return((from m in db.Career
where m.ctype == int.Parse((Request["type"])) && m.cvalid == true
select new { m.cid, m.cname, m.cpot }).Count());
}
else if (major.Equals("") && !pot.Equals(""))
{
if (Request["type"] == "4")
{
return((from m in db.Career
where m.ctype == int.Parse((Request["type"])) && m.cvalid == true && m.cpot.Contains(pot) && m.cdisplay == true
select new { m.cid, m.cname, m.cpot }).Count());
}
return((from m in db.Career
where m.ctype == int.Parse((Request["type"])) && m.cvalid == true && m.cpot.Contains(pot)
select new { m.cid, m.cname, m.cpot }).Count());
}
else if (!major.Equals("") && pot.Equals(""))
{
if ((Request["type"] == "1") || (Request["type"] == "2"))
{
return((from m in db.Career
where m.ctype == int.Parse((Request["type"])) && m.cvalid == true && m.cquality.Contains(major)
select new { m.cid, m.cname, m.cpot }).Count());
}
else if (Request["type"] == "4")
{
return((from m in db.Career
where m.ctype == int.Parse((Request["type"])) && m.cvalid == true && m.ceducation.Contains(major) && m.cdisplay == true
select new { m.cid, m.cname, m.cpot }).Count());
}
else
{
return((from m in db.Career
where m.ctype == int.Parse((Request["type"])) && m.cvalid == true && m.ceducation.Contains(major)
select new { m.cid, m.cname, m.cpot }).Count());
}
}
else
{
if ((Request["type"] == "1") || (Request["type"] == "2"))
{
return((from m in db.Career
where m.ctype == int.Parse((Request["type"])) && m.cvalid == true && m.cquality.Contains(major) && m.cpot.Contains(pot)
select new { m.cid, m.cname, m.cpot }).Count());
}
else if (Request["type"] == "3")
{
return((from m in db.Career
where m.ctype == int.Parse((Request["type"])) && m.cvalid == true && m.ceducation.Contains(major) && m.cpot.Contains(pot) && m.cdisplay == true
select new { m.cid, m.cname, m.cpot }).Count());
}
else
{
return((from m in db.Career
where m.ctype == int.Parse((Request["type"])) && m.cvalid == true && m.ceducation.Contains(major) && m.cpot.Contains(pot)
select new { m.cid, m.cname, m.cpot }).Count());
}
}
}
public static void ExportDoc(int id)
{
string rootpath = @"E:\project\ResumeInfo\ResumeInfo.Web\";
string filename = rootpath + "Pages\\ResumeRpt.doc";
License license = new License();
license.SetLicense(rootpath + "bin\\Aspose.Word.lic");
Document doc = new Document(filename);
string[] fieldNames = doc.MailMerge.GetFieldNames();
Dictionary <string, object> fvlist = new Dictionary <string, object>();
ResumeInfoDataContext db = new ResumeInfoDataContext();
var baseinfo = db.BaseInfo.Select(b => new {
b.UserID,
b.PName,
b.PID,
Sex = b.enuSex.Label,
csrq = WebHelper.ShortDateTime(b.csrq),
zzmm = b.enuZzmm.Label,
b.jg,
b.csd,
b.hkszd,
b.mz,
hyzk = b.enuHyzk.Label,
b.jkzk,
b.grtc,
b.sj,
b.yxdh,
b.lxdz,
b.email,
qwyx = b.enuQwyx.Label,
b.tz,
b.sg,
b.dywy,
b.dewy,
b.jsj,
zc = b.enuZc.Label,
jypx = b.jypx.Replace("<br>", "\r\n"),
xsky = b.xsky.Replace("<br>", "\r\n"),
stqk = b.stqk.Replace("<br>", "\r\n"),
jcqk = b.jcqk.Replace("<br>", "\r\n"),
b.gzdd1,
b.cszy,
ModifyTime = GetModifyTime(b.ModifyTime)
}).Single(b => b.UserID == id);
foreach (string s in fieldNames)
{
if (!s.StartsWith("l_"))
{
fvlist.Add(s, DataBinder.Eval(baseinfo, s));
}
}
doc.MailMerge.Execute(fvlist.Keys.ToArray(), fvlist.Values.ToArray());
fvlist.Clear();
var Jtshgx = db.Jiatshgx.Select(o => new
{
o.UserID,
o.cw,
o.xm,
o.nl,
zzmm = o.enuZzmm.Label,
o.gzdw,
o.bmzw
}).Where(o => o.UserID == id).Take(3);
int index = 0;
string[] arrf = new string[] { "l_cw", "l_xm", "l_nl", "l_zzmm", "l_gzdw", "l_bmzw" };
foreach (var o in Jtshgx)
{
foreach (string f in arrf)
{
fvlist.Add(f + index, DataBinder.Eval(o, f.Substring(2)));
}
index++;
}
doc.MailMerge.Execute(fvlist.Keys.ToArray(), fvlist.Values.ToArray());
ClearRest(3, index, arrf, fvlist, doc);
var zyzg = db.Zhiyzg.Select(o => new
{
o.UserID,
zg = o.enuZg.Label,
hdsj = WebHelper.ShortDateTime(o.hdsj),
o.zcd
}).Where(o => o.UserID == id).Take(3);
index = 0;
arrf = new string[] { "l_zg", "l_hdsj", "l_zcd" };
foreach (var o in zyzg)
{
foreach (string f in arrf)
{
fvlist.Add(f + index, DataBinder.Eval(o, f.Substring(2)));
}
index++;
}
doc.MailMerge.Execute(fvlist.Keys.ToArray(), fvlist.Values.ToArray());
ClearRest(3, index, arrf, fvlist, doc);
var gzsx = db.Gongzsx.Select(o => new
{
o.UserID,
qzsj = Getqzsj(o.kssj, o.jssj),
o.dw,
o.cszy,
o.bmjzw,
o.zmr,
lb = o.enuGzsxlb.Label
}).Where(o => o.UserID == id).Take(4);
index = 0;
arrf = new string[] { "l_lb", "l_qzsj", "l_dw", "l_cszy", "l_bmjzw", "l_zmr" };
foreach (var o in gzsx)
{
foreach (string f in arrf)
{
fvlist.Add(f + index, DataBinder.Eval(o, f.Substring(2)));
}
index++;
}
doc.MailMerge.Execute(fvlist.Keys.ToArray(), fvlist.Values.ToArray());
ClearRest(4, index, arrf, fvlist, doc);
var jybj = db.Jiaoybj.Select(o => new
{
o.UserID,
jqzsj = Getqzsj(o.kssj, o.jssj),
o.byyx,
o.sxzy,
o.ds,
o.jyjd
}).Where(o => o.UserID == id);
arrf = new string[] { "l_jqzsj", "l_byyx", "l_sxzy", "l_ds" };
SetJybj(1, 0, jybj, arrf, fvlist, doc);
SetJybj(2, 1, jybj, arrf, fvlist, doc);
SetJybj(3, 2, jybj, arrf, fvlist, doc);
SetJybj(4, 3, jybj, arrf, fvlist, doc);
SetJybj(5, 4, jybj, arrf, fvlist, doc);
string picname = WebHelper.GetPhotoUpDir() + id + ".jpg";
if (File.Exists(picname))
{
DocumentBuilder builder = new DocumentBuilder(doc);
builder.MoveToBookmark("pic");
builder.InsertImage(picname, 70, 90);
}
string pname = GetDocName(baseinfo.PName, id) + ".doc";
doc.Save(@"E:\project\ResumeInfo\简历导出\" + pname, SaveFormat.Doc);
}
private void FillNewForm()
{
ResumeInfoDataContext db = new ResumeInfoDataContext();
WebHelper.FillEnuList(jyjd, db, typeof(enuJyjd), false, "");
}
private void FillNewForm()
{
ResumeInfoDataContext db = new ResumeInfoDataContext();
WebHelper.FillEnuList(zzmm, db, typeof(enuZzmm), true, "");
}
private IQueryable GetRawQuery()
{
IQueryable <int> Query = null;
ResumeInfoDataContext db = new ResumeInfoDataContext();
//sb = WebHelper.SetSqlLog(db);
Dictionary <Type, string> querylist = (Dictionary <Type, string>)ViewState["Query"];
foreach (Type tp in querylist.Keys)
{
if (Query == null)
{
if (tp == typeof(Jiaoybj))
{
IQueryable p = from m in db.Jiaoybj
group new { m.UserID, m.byyx, m.sxzy, m.jyjd } by m.UserID into g
orderby g.FirstOrDefault().jyjd
select new
{
UserID = g.FirstOrDefault().UserID,
byyx = g.FirstOrDefault().byyx,
sxzy = g.FirstOrDefault().sxzy,
jyjd = g.FirstOrDefault().jyjd
}
;
Query = (IQueryable <int>)p.Where(querylist[tp]).Select("UserID");
}
else
{
Query = (IQueryable <int>)db.GetTable(tp).Where(querylist[tp]).Select("UserID");
}
}
else
{
if (tp == typeof(Jiaoybj))
{
IQueryable p = from m in db.Jiaoybj
group new { m.UserID, m.byyx, m.sxzy, m.jyjd } by m.UserID into g
orderby g.FirstOrDefault().jyjd
select new
{
UserID = g.FirstOrDefault().UserID,
byyx = g.FirstOrDefault().byyx,
sxzy = g.FirstOrDefault().sxzy,
jyjd = g.FirstOrDefault().jyjd
}
;
Query = Query.Intersect((IQueryable <int>)p.Where(querylist[tp]).Select("UserID"));
}
else
{
Query = Query.Intersect((IQueryable <int>)db.GetTable(tp).Where(querylist[tp]).Select("UserID"));
}
}
}
var q = from b in db.BaseInfo
where b.ModifyTime.HasValue && (!b.zfflag.Value || !b.zfflag.HasValue)
select new {
b.UserID,
b.PName,
b.PID,
b.sj,
b.ModifyTime,
SexLabel = b.enuSex.Label,
byyx = b.Jiaoybj.Where(o => o.UserID == b.UserID).OrderByDescending(o => o.enuJyjd.DisOrder).First().byyx,
xl = b.Jiaoybj.Where(o => o.UserID == b.UserID).OrderByDescending(o => o.enuJyjd.DisOrder).First().enuJyjd.Label,
zy = b.Jiaoybj.Where(o => o.UserID == b.UserID).OrderByDescending(o => o.enuJyjd.DisOrder).First().sxzy,
b.csd,
ztLabel = b.enuZt.Label,
ypzly = b.enuLaiy.Label,
};
if (Query != null)
{
q = q.Where(o => Query.Contains(o.UserID));
}
return(q);
}
