protected void Btn_Search_Click(object sender, EventArgs e) { Lts_Inherited = new Lts_InheritedDataContext(); List <Sp_DeadSearchResult> Lst_Deads = Lts_Inherited.Sp_DeadSearch(Txt_searchFName.Text.Trim() != "" ? Txt_searchFName.Text.Trim() : "0", Txt_searchLname.Text.Trim() != "" ? Txt_searchLname.Text.Trim() : "0", Txt_searchNationalcode.Text.Trim() != "" ? Txt_searchNationalcode.Text.Trim() : "0", Txt_searchClasse.Text.Trim() != "" ? Txt_searchClasse.Text.Trim() : "0", Txt_Hozeh.Text.Trim() != "" ? Txt_Hozeh.Text.Trim() : "0").ToList(); //List<Tb_File> Lst_Files=Lts_Inherited.Tb_Files.Where(n=> // (n.xHozeh==Txt_Hozeh.Text.Trim() ||Txt_Hozeh.Text.Trim()=="")&& // (n.xClass==Txt_searchClasse.Text.Trim() || Txt_searchClasse.Text.Trim() == "")).ToList(); //List<Tb_Dead> Lst_Deads = Lst_Files.Where(n => // (n.Tb_Dead.xDedFName.Contains(Txt_searchFName.Text.Trim()) || Txt_searchFName.Text.Trim() == "") && // (n.Tb_Dead.xDedLName.Contains(Txt_searchLname.Text.Trim()) || Txt_searchLname.Text.Trim() == "") && // (n.Tb_Dead.xDedNationalCode == Txt_searchNationalcode.Text.Trim() || Txt_searchNationalcode.Text.Trim() == "") && // n.Tb_Dead.xDedIsDeleted_ == false).Select(n=>n.Tb_Dead).ToList(); Gvw_Dead.DataSource = null; Gvw_Dead.DataSource = Lst_Deads; Gvw_Dead.DataBind(); Gvw_Dead.Visible = true; Lbl_Records.Text = Lst_Deads.Count.ToString(); Lbl_Records.Visible = true; Lbl_Rec.Visible = true; }
public void GetDead(int DeadId) { List <Tb_Dead> Lst_Deads = Lts_Inherited.Tb_Deads.Where(n => n.xDedId_pk == DeadId).ToList(); Gvw_Dead.DataSource = null; Gvw_Dead.DataSource = Lst_Deads; Gvw_Dead.DataBind(); Lbl_Records.Text = Lst_Deads.Count.ToString(); Lbl_Records.Visible = true; Lbl_Rec.Visible = true; Gvw_Dead.Visible = true; }