/// <summary>
/// 资金收支计划汇总表
/// </summary>
private void Bindzjszjhhzb()
{
string strsql = "select * from tunnel_newstype where IsDel=0 and parentid=23";
DataSet das = Tunnel.Data.DbHelperSQL.Query(strsql);
if (das.Tables[0].Rows.Count > 0)
{
Repeater12.DataSource = das;
Repeater12.DataBind();
Repeater12.Visible = true;
string strsql2 = "select top " + gettop(8 - das.Tables[0].Rows.Count) + " * from tunnel_index where typeid=23 and del=0 and IsDel=0 order by setdate desc ";
DataSet das2 = Tunnel.Data.DbHelperSQL.Query(strsql2);
Repeater5.DataSource = das2;
Repeater5.DataBind();
}
else
{
string strsql2 = "select top 8 * from tunnel_index where typeid=23 and del=0 and IsDel=0 order by setdate desc";
DataSet das2 = Tunnel.Data.DbHelperSQL.Query(strsql2);
Repeater5.DataSource = das2;
Repeater5.DataBind();
Repeater5.Visible = true;
Repeater12.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database ChapelDB = new Call_Database();
Repeater1.DataSource = ChapelDB.dbChapelBuilding;
Repeater1.DataBind();
Repeater2.DataSource = ChapelDB.dbHarmonyWall;
Repeater2.DataBind();
Repeater3.DataSource = ChapelDB.dbHopeWall;
Repeater3.DataBind();
Repeater4.DataSource = ChapelDB.dbFaithWall;
Repeater4.DataBind();
Repeater5.DataSource = ChapelDB.dbGraceWall;
Repeater5.DataBind();
Repeater6.DataSource = ChapelDB.dbPeaceWall;
Repeater6.DataBind();
Repeater7.DataSource = ChapelDB.dbChairsBenches;
Repeater7.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//DataSet is an in-memory cache of data retrieved from a data source
//step 1: create Dataset with a GET method
DataSet datathriller = GetDataThriller();
DataSet datafiction = GetDataFiction();
DataSet datapaperbacks = GetDataPaperbacks();
DataSet datayoungreaders = GetDataYoungReaders();
DataSet datateens = GetDataTeens();
//DataSource is used to pull the data from the database and populate them
//step 8: pull data using DataSource
Repeater1.DataSource = datathriller;
Repeater2.DataSource = datafiction;
Repeater3.DataSource = datapaperbacks;
Repeater4.DataSource = datayoungreaders;
Repeater5.DataSource = datateens;
//step 9: bind the data to the repeater
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
}
protected void bindscore()
{
DataTable dt = b_Ask.Sel("Score<>0", "", null);
Repeater5.DataSource = dt;
Repeater5.DataBind();
}
protected void OnDelete(object sender, EventArgs e)
{
//Find the reference of the Repeater Item.
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int ID = int.Parse((item.FindControl("lblID") as Label).Text);
var checkHomework = (from c in db.Homeworks where c.ID.Equals(ID) select c).FirstOrDefault();
db.Homeworks.DeleteOnSubmit(checkHomework);
db.SubmitChanges();
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
Repeater6.DataBind();
Repeater7.DataBind();
Repeater8.DataBind();
Repeater8.DataBind();
Repeater9.DataBind();
Repeater10.DataBind();
Repeater11.DataBind();
Repeater12.DataBind();
Repeater13.DataBind();
Repeater14.DataBind();
Repeater15.DataBind();
}
protected void OnUpdate(object sender, EventArgs e)
{
//Find the reference of the Repeater Item.
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int ID = int.Parse((item.FindControl("lblID") as Label).Text);
string subject = (item.FindControl("txtSubj") as TextBox).Text.Trim();
string homework = (item.FindControl("txtHomework") as TextBox).Text.Trim();
var checkHomework = (from c in db.Homeworks where c.ID.Equals(ID) select c).FirstOrDefault();
checkHomework.Subject = subject;
checkHomework.Homework1 = homework;
db.SubmitChanges();
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
Repeater6.DataBind();
Repeater7.DataBind();
Repeater8.DataBind();
Repeater8.DataBind();
Repeater9.DataBind();
Repeater10.DataBind();
Repeater11.DataBind();
Repeater12.DataBind();
Repeater13.DataBind();
Repeater14.DataBind();
Repeater15.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSetTableAdapters.TBLHAKKIMDATableAdapter dt = new DataSetTableAdapters.TBLHAKKIMDATableAdapter();
Repeater1.DataSource = dt.HakkimdaListele();
Repeater1.DataBind();
DataSetTableAdapters.TBLDENEYIMTableAdapter dtDeneyim = new DataSetTableAdapters.TBLDENEYIMTableAdapter();
Repeater2.DataSource = dtDeneyim.DeneyimListesi();
Repeater2.DataBind();
DataSetTableAdapters.TBLEGITIMTableAdapter dtEgitim = new DataSetTableAdapters.TBLEGITIMTableAdapter();
Repeater3.DataSource = dtEgitim.EgitimListesi();
Repeater3.DataBind();
DataSetTableAdapters.TBLHOBILERTableAdapter dtHobiler = new DataSetTableAdapters.TBLHOBILERTableAdapter();
Repeater5.DataSource = dtHobiler.HobilerListele();
Repeater5.DataBind();
DataSetTableAdapters.TBLODULLERTableAdapter dtOdul = new DataSetTableAdapters.TBLODULLERTableAdapter();
Repeater6.DataSource = dtOdul.OdulListesi();
Repeater6.DataBind();
DataSetTableAdapters.TBLYETENEKLERTableAdapter dtYetenek = new DataSetTableAdapters.TBLYETENEKLERTableAdapter();
Repeater4.DataSource = dtYetenek.YetenekListesi();
Repeater4.DataBind();
DataSetTableAdapters.TBLHAKKIMDATableAdapter dtFotograf = new DataSetTableAdapters.TBLHAKKIMDATableAdapter();
Repeater8.DataSource = dtFotograf.HakkimdaListele();
Repeater8.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1TableAdapters.HAKKIMDATableAdapter dt = new DataSet1TableAdapters.HAKKIMDATableAdapter();
Repeater1.DataSource = dt.HakkımdaListele();
Repeater1.DataBind();
DataSet1TableAdapters.DENEYIMTableAdapter dt1 = new DataSet1TableAdapters.DENEYIMTableAdapter();
Repeater2.DataSource = dt1.DeneyimListele();
Repeater2.DataBind();
DataSet1TableAdapters.EGITIMTableAdapter dt2 = new DataSet1TableAdapters.EGITIMTableAdapter();
Repeater3.DataSource = dt2.EgitimListesi();
Repeater3.DataBind();
DataSet1TableAdapters.YETENEKLERTableAdapter dt3 = new DataSet1TableAdapters.YETENEKLERTableAdapter();
Repeater4.DataSource = dt3.YetenekListele();
Repeater4.DataBind();
DataSet1TableAdapters.HOBILERTableAdapter dt4 = new DataSet1TableAdapters.HOBILERTableAdapter();
Repeater5.DataSource = dt4.HobiListesi();
Repeater5.DataBind();
DataSet1TableAdapters.KONFERANSTableAdapter dt5 = new DataSet1TableAdapters.KONFERANSTableAdapter();
Repeater6.DataSource = dt5.KonferansListele();
Repeater6.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1TableAdapters.TBLHAKKIMDATableAdapter dt = new DataSet1TableAdapters.TBLHAKKIMDATableAdapter();
Repeater1.DataSource = dt.HakkımdaListele();
Repeater1.DataBind();
DataSet1TableAdapters.TBLDENEYIMTableAdapter dt2 = new DataSet1TableAdapters.TBLDENEYIMTableAdapter();
Repeater2.DataSource = dt2.DeneyimListesi();
Repeater2.DataBind();
DataSet1TableAdapters.TBLEGITIMTableAdapter dt3 = new DataSet1TableAdapters.TBLEGITIMTableAdapter();
Repeater3.DataSource = dt3.EgitimListesi();
Repeater3.DataBind();
DataSet1TableAdapters.TBLYETENEKLERTableAdapter dt4 = new DataSet1TableAdapters.TBLYETENEKLERTableAdapter();
Repeater4.DataSource = dt4.YetenekListesi();
Repeater4.DataBind();
DataSet1TableAdapters.TBLHOBILERTableAdapter dt5 = new DataSet1TableAdapters.TBLHOBILERTableAdapter();
Repeater5.DataSource = dt5.HobiListesi();
Repeater5.DataBind();
DataSet1TableAdapters.TBLKULUPLERTableAdapter dt6 = new DataSet1TableAdapters.TBLKULUPLERTableAdapter();
Repeater6.DataSource = dt6.KuluplerListesi();
Repeater6.DataBind();
DataSet1TableAdapters.TBLHAKKIMDATableAdapter dt7 = new DataSet1TableAdapters.TBLHAKKIMDATableAdapter();
Repeater7.DataSource = dt7.HakkımdaListele();
Repeater7.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1TableAdapters.HakkimdaTableAdapter dt = new DataSet1TableAdapters.HakkimdaTableAdapter();
Repeater1.DataSource = dt.HakkimdaListele();
Repeater1.DataBind();
DataSet1TableAdapters.DeneyimlerTableAdapter dt2 = new DataSet1TableAdapters.DeneyimlerTableAdapter();
Repeater2.DataSource = dt2.DeneyimListesi();
Repeater2.DataBind();
DataSet1TableAdapters.EgitimTableAdapter dt3 = new DataSet1TableAdapters.EgitimTableAdapter();
Repeater3.DataSource = dt3.EgitimListele();
Repeater3.DataBind();
DataSet1TableAdapters.OdullerimTableAdapter dt4 = new DataSet1TableAdapters.OdullerimTableAdapter();
Repeater4.DataSource = dt4.OdullerimListele();
Repeater4.DataBind();
DataSet1TableAdapters.HobilerimTableAdapter dt5 = new DataSet1TableAdapters.HobilerimTableAdapter();
Repeater5.DataSource = dt5.HobilerListele();
Repeater5.DataBind();
DataSet1TableAdapters.YeteneklerimTableAdapter dt6 = new DataSet1TableAdapters.YeteneklerimTableAdapter();
Repeater6.DataSource = dt6.YeteneklerimDoldur();
Repeater6.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
//last week
SqlDataSource2.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource3.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource4.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource5.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource6.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
//this week
SqlDataSource7.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource8.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource9.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource10.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource11.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
//next week
SqlDataSource12.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource13.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource14.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource15.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
SqlDataSource16.SelectParameters["UserClass"].DefaultValue = RadioButtonList1.SelectedValue;
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
Repeater6.DataBind();
Repeater7.DataBind();
Repeater8.DataBind();
Repeater8.DataBind();
Repeater9.DataBind();
Repeater10.DataBind();
Repeater11.DataBind();
Repeater12.DataBind();
Repeater13.DataBind();
Repeater14.DataBind();
Repeater15.DataBind();
}
///<summary>
/// 帮定分页数据
///</summary>
///
void BindData(string key = null)
{
IEnumerable <书名表> ListSource = new List <书名表>();
ListSource = Tygdb.书名表.Where(p => p.包含有效章节 != null && p.包含有效章节 > 0).OrderByDescending(p => p.最后更新时间);
//ShowNews.DataSource = ListSource;
//ShowNews.DataBind();
//每一个分类取最新的一条记录
var docs = Tygdb.ExecuteStoreQuery <NewDocItem>(@"
select d.ID,d.本记录GUID,d.GUID,d.书名 into #doc from (
select top 100 [GUID] from 书名表 where 包含有效章节 > 0 order by 最后更新时间 desc
) as
doctype
left join
(
SELECT * from 文章表
)
d
on d.[GUID]=doctype.[GUID]
select * from (select *,row=row_number()over(partition by [GUID] order by ID desc) from #doc)t where row=1 and t.id>0
drop table #doc ");
decimal[] ids = docs.Select(p => p.ID).ToArray();
//使用了in
var topDocs = Tygdb.文章表.Where(p => ids.Contains(p.ID)).OrderByDescending(p => p.ID).ToList().Where(
//确保章节是有效的
p => string.Join("", System.Text.RegularExpressions.Regex.Matches(p.内容, @"[\u4e00-\u9fa5\d\w１２３４５６７８９～！!·＃￥％……—＊（）——＋／”》“‘’，；。、？，：…《]+[\u4e00-\u9fa5１２３４５６７８９～！!·＃￥％……—＊（!）——＋／”》“‘，’\r\n；。、？，：…《]", System.Text.RegularExpressions.RegexOptions.Multiline)
.Cast <System.Text.RegularExpressions.Match>().Select(x => x.Value).ToArray()
).Length > 200
);
topDocs = topDocs.ToList().Where(p => System.IO.File.Exists(AppDomain.CurrentDomain.BaseDirectory + p.GetHTMLFilePath())).ToList();
Docs1.DataSource = topDocs.Take(6);
Docs1.DataBind();
Repeater1.DataSource = topDocs.Skip(6 * 1).Take(6);
Repeater1.DataBind();
Repeater2.DataSource = topDocs.Skip(6 * 2).Take(6);
Repeater2.DataBind();
Repeater3.DataSource = topDocs.Skip(6 * 3).Take(6);
Repeater3.DataBind();
Repeater4.DataSource = topDocs.Skip(6 * 4).Take(6);
Repeater4.DataBind();
Repeater5.DataSource = topDocs.Skip(6 * 5).Take(6);
Repeater5.DataBind();
BindTopBook();
}
public void hotoffers()
{
DataTable dt = ad.gettop6hotoffers();
if (dt.Rows.Count != 0)
{
Repeater5.DataSource = dt;
Repeater5.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Tunnel.BLL.Tunnel_Remind tr = new Tunnel.BLL.Tunnel_Remind();
Repeater5.DataSource = tr.GetList("m_type<>2 and m_type<>3 and m_touser=" + ul.LoginID);
Repeater5.DataBind();
Label1.Text = Repeater5.Items.Count.ToString();
}
}
public void FetchingDeletedRequestDetails()
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@userid", SqlDbType.Int);
param[0].Value = Session["id"];
ds = objdf.FillDsParam("usp_FetchDeletedDetails", param);
Repeater5.DataSource = ds;
Repeater5.DataBind();
Count_5();
}
private void upcome()
{
co.connect();
string sql = "Select top 5 MovieName,id from Newmovie order by newid()";
da = new SqlDataAdapter(sql, co.con);
ds = new DataSet();
da.Fill(ds);
Repeater5.DataSource = ds.Tables[0].DefaultView;
Repeater5.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Permissions.ComRedirect(Page, Permissions.redirUrl);
Response.Cache.SetExpires(DateTime.Now);
Permissions.CheckManagePermission(6313);
if (!IsPostBack && Request.QueryString["action"] == null)
{
Repeater1.DataSource = WTreeBLL.GetWLTField("1", "0");
Repeater1.DataBind();
Repeater4.DataSource = WTreeBLL.GetWLTField("1", "1");
Repeater4.DataBind();
Repeater2.DataSource = WTreeBLL.GetWLTField("2", "0");
Repeater2.DataBind();
Repeater5.DataSource = WTreeBLL.GetWLTField("2", "1");
Repeater5.DataBind();
Repeater3.DataSource = WTreeBLL.GetWLTField("3", "0");
Repeater3.DataBind();
Repeater6.DataSource = WTreeBLL.GetWLTField("3", "1");
Repeater6.DataBind();
}
if (Request.QueryString["action"] == "save")
{
string f = Request.QueryString["field"];
string v = Request.QueryString["visible"];
string id = Request.QueryString["id"];
//if (id == "1")
//{
// if (f.IndexOf("|") == -1)
// {
// Response.Write(GetTran("007953", "修改失败,必须要有“|”符号！"));
// Response.End();
// return;
// }
//}
int hs = WTreeBLL.UpdWLTField(f, v, id);
if (hs == 2)
{
Response.Write(GetTran("000222", "修改成功！"));
}
else
{
Response.Write(GetTran("000225", "修改失败！"));
}
Response.End();
}
}
public void filllikethis(int id)
{
DataTable dt = ad.filllikethis(id);
if (dt.Rows.Count == 0)
{
}
else
{
Repeater5.DataSource = dt;
Repeater5.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Button1.Click += new EventHandler(Button1_Click);
if (IsPostBack)
{
return;
}
//设置左边菜单
var mst = this.Master as Member_Manage_MasterPage;
mst.SetMenuTitle("公司资料", "详细资料");
var ud = Session["UserData"] as UserData;
var bl = new DS_CompanyInfo_Br();
var md = bl.GetSingleByMemberID(ud.Member.ID);
ViewState["LegRep"] = md.LegalRepresentative;
ViewState["Bank"] = md.Bank;
ViewState["Account"] = md.Account;
ViewState["StorageArea"] = md.StorageArea;
ViewState["Employees"] = md.Employees;
ViewState["StudyEmployees"] = md.StudyEmployees;
ViewState["BrandName"] = md.BrandName;
ViewState["Monthly"] = md.Monthly;
ViewState["unit"] = md.MonthlyUnit;
ViewState["AnnualTurnover"] = md.AnnualTurnover;
ViewState["AnnualImports"] = md.AnnualImports;
ViewState["AnnualExport"] = md.AnnualExport;
ViewState["MSCer"] = string.IsNullOrEmpty(md.MSCer)?"":md.MSCer.TrimEnd(',');
ViewState["qc"] = md.QualityControl;
ViewState["mainmarket"] = md.MainMarket;
ViewState["MajorCustomers"] = md.MajorCustomers;
ViewState["oem"] = md.OEM;
ViewState["ComImg"] = md.ComImg;
//员工人数
var embl = new DS_Employees_Br();
Repeater1.DataSource = Repeater2.DataSource = embl.Query("", "px");
Repeater1.DataBind();
Repeater2.DataBind();
//营业额
var tubl = new DS_Turnover_Br();
Repeater3.DataSource = Repeater4.DataSource = Repeater5.DataSource = tubl.Query("", "px");
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["KullaniciAd"] == null)
{
Response.Redirect("LoginPanel.aspx");
}
else
{
Response.Write("Hoşgeldiniz...." + Session["KullaniciAd"].ToString());
}
DataSet1TableAdapters.TBLHakkimdaTableAdapter dr =
new DataSet1TableAdapters.TBLHakkimdaTableAdapter();
Repeater1.DataSource = dr.HakkimdaListele();
Repeater1.DataBind();
DataSet1TableAdapters.TBLDeneyimTableAdapter dr1 =
new DataSet1TableAdapters.TBLDeneyimTableAdapter();
Repeater2.DataSource = dr1.DeneyimListesi();
Repeater2.DataBind();
DataSet1TableAdapters.TBLEgitimHTableAdapter dr2 =
new DataSet1TableAdapters.TBLEgitimHTableAdapter();
Repeater3.DataSource = dr2.EgitimBilgi();
Repeater3.DataBind();
DataSet1TableAdapters.TBLHobiTableAdapter dr3 =
new DataSet1TableAdapters.TBLHobiTableAdapter();
Repeater4.DataSource = dr3.hobiBilgi();
Repeater4.DataBind();
DataSet1TableAdapters.TBLSertifikaTableAdapter dr4 =
new DataSet1TableAdapters.TBLSertifikaTableAdapter();
Repeater5.DataSource = dr4.SertifikaBilgi();
Repeater5.DataBind();
DataSet1TableAdapters.TBLYeteneklerTableAdapter dr5 =
new DataSet1TableAdapters.TBLYeteneklerTableAdapter();
Repeater6.DataSource = dr5.YetenekBilgi();
Repeater6.DataBind();
DataSet1TableAdapters.TBLHakkimdaTableAdapter dr7 =
new DataSet1TableAdapters.TBLHakkimdaTableAdapter();
Repeater7.DataSource = dr7.HakkimdaListele();
Repeater7.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Database db = new Database();
Lang lan = new Lang();
string showcaseSql = "select * from Showcase where lang=@lang order by showorder";
string aboutHomeSql = "select * from Pages where PageKey=@homeAbout and lang=@lang";
string partnerSql = "select * from Partners where lang=@lang Order By ShowOrder";
string PublicationsSql = "select top(2) * from Publications where lang=@lang Order By id desc";
string newsSql = "select top(2) * from News where lang=@lang Order By id desc";
string publicResearchSql = "select top(5) * from Library where lang=@lang Order By Id Desc";
db.AddParameter("@lang", lan.getCurrentLang());
db.AddParameter("@homeAbout", "HomeAbout");
DataSet ds = db.ExecuteDataSet(showcaseSql + ";" + aboutHomeSql + ";" + partnerSql + ";" + PublicationsSql + ";" + newsSql + ";" + publicResearchSql);
Repeater1.DataSource = ds.Tables[0];
if (ds.Tables[0].Rows.Count < 1)
{
myCarousel.Visible = false;
}
else
{
myCarousel.Visible = true;
}
Repeater1.DataBind();
Repeater2.DataSource = ds.Tables[1];
Repeater2.DataBind();
Repeater3.DataSource = ds.Tables[2];
Repeater3.DataBind();
Repeater4.DataSource = ds.Tables[3];
Repeater4.DataBind();
Repeater5.DataSource = ds.Tables[4];
Repeater5.DataBind();
Repeater6.DataSource = ds.Tables[5];
Repeater6.DataBind();
LoadPoll();
}
}
private void loadTrendingWeek()
{
using (SqlConnection conn = new SqlConnection(sCnStr))
{
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = "SP_doGetTrendingNewsWeek";
SqlDataAdapter da = new SqlDataAdapter(comm);
DataTable dt = new DataTable();
da.Fill(dt);
Repeater5.DataSource = dt;
Repeater5.DataBind();
}
}
public void loaddata()
{
SiteGroupCms.Dal.AdminDal admindal = new Dal.AdminDal();
Repeater1.DataSource = admindal.GetpersonDT("job like '%总顾问%'", " sort asc, id asc");
Repeater1.DataBind();
Repeater2.DataSource = admindal.GetpersonDT("job like '%主管%'", "sort asc, id asc");
Repeater2.DataBind();
Repeater3.DataSource = admindal.Getdepartdt("商务组", "sort asc, id asc");
Repeater3.DataBind();
Repeater4.DataSource = admindal.Getdepartdt("美工组", "sort asc, id asc");
Repeater4.DataBind();
Repeater5.DataSource = admindal.Getdepartdt("程序组", "sort asc, id asc");
Repeater5.DataBind();
Repeater6.DataSource = admindal.Getdepartdt("往期成员", "sort asc, id asc");
Repeater6.DataBind();
}
protected void btnAddHomework5_Click(object sender, EventArgs e)
{
Homework homework = new Homework();
homework.Class = Convert.ToInt32(RadioButtonList1.SelectedValue);
homework.Subject = txtAddSubj5.Text;
homework.Homework1 = txtAddHomework5.Text;
string[] test = date5.Text.Split('/');
string ss = test[1] + "/" + test[0];
homework.Date = Convert.ToDateTime(ss);
db.Homeworks.InsertOnSubmit(homework);
db.SubmitChanges();
txtAddSubj5.Text = "";
txtAddHomework5.Text = "";
Repeater5.DataBind();
}
/// <summary>
/// АѓЖЈЪ§Он
/// </summary>
protected void bind()
{
Repeater1.DataSource = new SP.BLL.equip().GetList(15, "", " atime desc");
Repeater1.DataBind();
Repeater2.DataSource = new SP.BLL.news().GetList(10, "", " atime desc ");
Repeater2.DataBind();
Repeater3.DataSource = new SP.BLL.plans().GetList(6, "", " atime desc ");
Repeater3.DataBind();
Repeater4.DataSource = new SP.BLL.selection().GetList(10, "", " atime desc ");
Repeater4.DataBind();
Repeater5.DataSource = new SP.BLL.plansType().GetList(5, "", " tid");
Repeater5.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Repeater1.DataSource = db.TBLHAKKINDA.ToList();
Repeater1.DataBind();
Repeater2.DataSource = db.TBLHAKKINDA.ToList();
Repeater2.DataBind();
Repeater3.DataSource = db.TBLHAKKINDA.ToList();
Repeater3.DataBind();
Repeater4.DataSource = db.TBLADRES.ToList();
Repeater4.DataBind();
Repeater5.DataSource = db.TBLADRES.ToList();
Repeater5.DataBind();
Repeater6.DataSource = db.TBLYETENEKLER.ToList();
Repeater6.DataBind();
Timer1.Enabled = true;
Timer1.Interval = 1000;
Timer1.Tick += new EventHandler <EventArgs>(Timer1_Tick);
}
protected void info_show()
{
#region 条件
BsonDocument where = new BsonDocument();
where.Add("RequestIdentity", infoid);
#endregion
#region 排序
string[] orderby = { "Time" };
#endregion
#region 字段
BsonDocument fields = new BsonDocument();
#endregion
//查询数据库
List <ClientExceptionInfo> list1 = MongoDBUtil.GetPaged <ClientExceptionInfo>(dbName, "ClientExceptionInfo", where, orderby, fields, 1, 20);
Repeater1.DataSource = list1;
Repeater1.DataBind();
List <ClientInvokeInfo> list2 = MongoDBUtil.GetPaged <ClientInvokeInfo>(dbName, "ClientInvokeInfo", where, orderby, fields, 1, 20);
Repeater2.DataSource = list2;
Repeater2.DataBind();
List <ClientMessageInfo> list3 = MongoDBUtil.GetPaged <ClientMessageInfo>(dbName, "ClientMessageInfo", where, orderby, fields, 1, 20);
Repeater3.DataSource = list3;
Repeater3.DataBind();
List <ServerExceptionInfo> list4 = MongoDBUtil.GetPaged <ServerExceptionInfo>(dbName, "ServerExceptionInfo", where, orderby, fields, 1, 20);
Repeater4.DataSource = list4;
Repeater4.DataBind();
List <ServerInvokeInfo> list5 = MongoDBUtil.GetPaged <ServerInvokeInfo>(dbName, "ServerInvokeInfo", where, orderby, fields, 1, 20);
Repeater5.DataSource = list5;
Repeater5.DataBind();
List <ServerMessageInfo> list6 = MongoDBUtil.GetPaged <ServerMessageInfo>(dbName, "ServerMessageInfo", where, orderby, fields, 1, 20);
Repeater6.DataSource = list6;
Repeater6.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Repeater1.DataSource = db.TBL_anasayfaVERILER.ToList();
Repeater1.DataBind();
Repeater2.DataSource = db.TBL_anasayfaVERILER.ToList();
Repeater2.DataBind();
Repeater3.DataSource = db.TBL_anasayfaVERILER.ToList();
Repeater3.DataBind();
Repeater4.DataSource = db.TBL_anasayfaVERILER.ToList();
Repeater4.DataBind();
Repeater5.DataSource = db.TBL_anasayfaVERILER.ToList();
Repeater5.DataBind();
Repeater6.DataSource = db.TBL_anasayfaVERILER.ToList();
Repeater6.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
db = new TezDBEntities();
var Ogrdb1 = db.Tez.Where(t => t.Hoca_ID == AppKontrol.id && t.Tez_Alan > 0 && t.durum == true).ToList(); //alınan
var Ogrdb2 = db.Tez.Where(t => t.Hoca_ID == AppKontrol.id && t.durum == true).ToList(); //tum
var Ogrdb3 = db.Tez.Where(t => t.Hoca_ID == AppKontrol.id && t.Tez_Alan == 0 && t.durum == true).ToList(); //alınmayan
var Ogrdb4 = db.Tez.Where(t => t.Hoca_ID == AppKontrol.id && t.durum == false).ToList(); //biten
if (!IsPostBack)
{
Repeater1.DataSource = Ogrdb1;
Repeater1.DataBind();
Repeater3.DataSource = Ogrdb2;
Repeater3.DataBind();
Repeater4.DataSource = Ogrdb3;
Repeater4.DataBind();
Repeater5.DataSource = Ogrdb4;
Repeater5.DataBind();
}
}
private void fill_latest_items()
{
try
{
var id = (from a in linq_obj.product_masters
orderby a.intGlCode descending
select new
{
code = a.intGlCode,
p_img = "./upload/" + a.main_images,
p_name = a.product_name,
p_price = a.actual_price
}).Take(6).ToList();
Repeater5.DataSource = id;
Repeater5.DataBind();
}
catch (Exception ex)
{
}
}
