private void GVLoad(string Rid)
{
var data = dc.ViewParresultdetail.Where(p => p.Rid == decimal.Parse(Rid));
JeomStore.DataSource = data;
JeomStore.DataBind();
}
private void LoadData(decimal id)
{
if (dfBeginDate.SelectedDate > dfEndDate.SelectedDate)
{
Ext.Msg.Alert("提示", "日期选择有误!").Show();
return;
}
var data = from r in dc.SqsResult
from k in dc.SqsDomain
from d in dc.Department
from d2 in dc.Department
where r.Did == k.Did && r.Checkdept == d.Deptnumber && r.Checkfordept == d2.Deptnumber &&
r.Did == id &&
r.Checkdate >= dfBeginDate.SelectedDate && r.Checkdate <= dfEndDate.SelectedDate
select new
{
k.Dname,
r.Checkdate,
CheckDeptName = d.Deptname,
CheckForDeptName = d2.Deptname,
Placename = r.Placeid,
r.Rid,
r.Rstatus,
r.Total
};
JeomStore.DataSource = data;
JeomStore.DataBind();
}
private void JeomSet(int id)
{
if (id > -1)
{
var data = (from j in dc.ParJeomcriterion
where j.Itemid == id && j.Status == "1"
orderby j.Sort
select new
{
Jcid = "j" + j.Jcid,
j.Jccontent,
j.Indate,
j.Maxscore,
j.Minscore,
Kind = "基本内容"
}).Concat(
from a in dc.ParAddjeomcriterion
where a.Pkindid == decimal.Parse(hdnKindid.Value.ToString()) && a.Status == "1"
orderby a.Sort
select new
{
Jcid = "a" + a.Ajcid,
Jccontent = a.Ajccontent,
a.Indate,
a.Maxscore,
a.Minscore,
Kind = "附加内容"
}
);
JeomStore.DataSource = data;
JeomStore.DataBind();
}
else
{
var data = from a in dc.ParAddjeomcriterion
where a.Pkindid == decimal.Parse(hdnKindid.Value.ToString()) && a.Status == "1"
orderby a.Sort
select new
{
Jcid = "a" + a.Ajcid,
Jccontent = a.Ajccontent,
a.Indate,
a.Maxscore,
a.Minscore,
Kind = "附加内容"
};
JeomStore.DataSource = data;
JeomStore.DataBind();
}
}
private void GVLoad(string Rid, decimal kind)
{
var n = from e in dc.SqsEssentialcondition
join r in dc.SqsEssentialconditiondetail.Where(p => p.Rid == decimal.Parse(Rid)) on e.Ecid equals r.Ecid into gg
from g in gg.DefaultIfEmpty()
where e.Did == kind
select new
{
e.Ecid,
e.Content,
isCheck = g.Ecid != null
};
ESSENTIALCONDITIONStore.DataSource = n;
ESSENTIALCONDITIONStore.DataBind();
var d = from a in dc.SqsDemotion
join r in dc.SqsDemotiondetail.Where(p => p.Rid == decimal.Parse(Rid)) on a.Deid equals r.Deid into gg
from g in gg.DefaultIfEmpty()
where a.Did == kind
select new
{
a.Deid,
a.Content,
isCheck = g.Deid != null
};
DEMOTIONStore.DataSource = d;
DEMOTIONStore.DataBind();
var data = from j in dc.SqsJeomcriterion
join i in dc.SqsKind on j.Pkindid equals i.Pkindid
join r in dc.SqsResultDetail.Where(p => p.Rid == decimal.Parse(Rid)) on j.Jcid equals r.Jcid into gg
from g in gg.DefaultIfEmpty()
where i.Did == kind
orderby j.Sort
select new
{
j.Jcid,
j.Jccontent,
j.Score,
Means = j.Means,
Jeom = g == null?j.Score:g.Jeom,
Remark = g == null?"":g.Remark,
Kind = i.Pkindname
};
JeomStore.DataSource = data;
JeomStore.DataBind();
}
private void LoadData(decimal id)
{
if (dfBeginDate.SelectedDate > dfEndDate.SelectedDate)
{
Ext.Msg.Alert("提示", "日期选择有误!").Show();
return;
}
var data = from r in dc.ParResult
from k in dc.ParKind
from d in dc.Department
from d2 in dc.Department
join e in dc.Person on r.Bkhperson equals e.Personnumber into gg
from g in gg.DefaultIfEmpty()
join f in dc.Person on r.Khperson equals f.Personnumber into kk
from kkk in kk.DefaultIfEmpty()
where r.Pkindid == k.Pkindid && r.Checkdept == d.Deptnumber && r.Checkfordept == d2.Deptnumber &&
r.Pkindid == id &&
r.Checkdate >= dfBeginDate.SelectedDate && r.Checkdate <= dfEndDate.SelectedDate
select new
{
k.Pkindname,
r.Checkdate,
CheckDeptName = d.Deptname,
CheckForDeptName = d2.Deptname,
r.Bkhperson,
r.Rid,
r.Rstatus,
r.Khperson,
r.Total,
r.Placeid,
Personname = g.Name != null ? g.Name : "无",
KHname = kkk.Name != null ? kkk.Name : "无"
};
if (cbbPerson.SelectedIndex > -1)
{
data = data.Where(p => p.Khperson == cbbPerson.SelectedItem.Value);
}
if (cbbplace.SelectedIndex > -1)
{
data = data.Where(p => p.Placeid == cbbplace.SelectedItem.Value);
}
JeomStore.DataSource = data;
JeomStore.DataBind();
}
private void GVLoad(decimal kindid)
{
var n = from a in dc.SqsEssentialcondition
where a.Did == kindid
select new
{
a.Ecid,
a.Content,
isCheck = false
};
ESSENTIALCONDITIONStore.DataSource = n;
ESSENTIALCONDITIONStore.DataBind();
var d = from a in dc.SqsDemotion
where a.Did == kindid
select new
{
a.Deid,
a.Content,
isCheck = false
};
DEMOTIONStore.DataSource = d;
DEMOTIONStore.DataBind();
var data = from j in dc.SqsJeomcriterion
from i in dc.SqsKind
where j.Pkindid == i.Pkindid && i.Did == kindid && j.Status == "1"
orderby j.Sort
select new
{
j.Jcid,
Jccontent = j.Jccontent,
j.Score,
Means = j.Means,
Jeom = j.Score,
Remark = "",
Kind = i.Pkindname
};
JeomStore.DataSource = data;
JeomStore.DataBind();
}
private void GVLoad(decimal kindid)
{
var data = (from j in dc.ParJeomcriterion
from i in dc.ParItem
where j.Itemid == i.Itemid && j.Status == "1" && i.Pkindid == kindid
orderby i.Sort, j.Sort
select new
{
Rdid = -1,
Jcid = "j" + j.Jcid,
j.Jccontent,
j.Minscore,
j.Maxscore,
Jeom = "",
Remark = "",
Kind = i.Itemname
}).Concat(
from a in dc.ParAddjeomcriterion
where a.Pkindid == kindid && a.Status == "1"
orderby a.Sort
select new
{
Rdid = -1,
Jcid = "a" + a.Ajcid,
Jccontent = a.Ajccontent,
a.Minscore,
a.Maxscore,
Jeom = "",
Remark = "",
Kind = "附加内容"
}
);
JeomStore.DataSource = data;
JeomStore.DataBind();
}
private void JeomSet(int id, int did)
{
if (id > -1)
{
var data = from j in dc.SqsJeomcriterion
where j.Pkindid == id && j.Status == "1"
orderby j.Sort
select new
{
Jcid = "j" + j.Jcid,
j.Jccontent,
j.Indate,
Score = " " + j.Score,
j.Means,
Kind = "基本内容"
};
// .Concat(
//from a in dc.SqsEssentialcondition
//where a.Did == decimal.Parse(hdnKindid.Value.ToString()) && a.Status == "1"
//select new
//{
// Jcid = "n" + a.Ecid,
// Jccontent = a.Content,
// a.Indate,
// Score="不达标",
// Means = "不达标扣10分，得分不得超过不达标标准分",
// Kind = "否决条件"
//}
// ).Concat(
//from a in dc.SqsDemotion
//where a.Did == decimal.Parse(hdnKindid.Value.ToString()) && a.Status == "1"
//select new
//{
// Jcid = "d" + a.Deid,
// Jccontent = a.Content,
// a.Indate,
// Score = "降一级",
// Means = "降一级扣5分，得分不得超过下一级的最高分",
// Kind = "降级条件"
//}
// );
JeomStore.DataSource = data;
JeomStore.DataBind();
}
else
{
var data = (
from a in dc.SqsEssentialcondition
where a.Did == did && a.Status == "1"
select new
{
Jcid = "n" + a.Ecid,
Jccontent = a.Content,
a.Indate,
Score = "不达标",
Means = "不达标扣10分，得分不得超过不达标标准分",
Kind = "否决条件"
}
).Concat(
from a in dc.SqsDemotion
where a.Did == did && a.Status == "1"
select new
{
Jcid = "d" + a.Deid,
Jccontent = a.Content,
a.Indate,
Score = "降一级",
Means = "降一级扣5分，得分不得超过下一级的最高分",
Kind = "降级条件"
}
);
JeomStore.DataSource = data;
JeomStore.DataBind();
}
}
