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(); } }