/// <summary>
/// 产值销售汇总表
/// </summary>
private void Bindscxshzb()
{
string strsql = "select * from tunnel_newstype where IsDel=0 and parentid=24";
DataSet das = Tunnel.Data.DbHelperSQL.Query(strsql);
if (das.Tables[0].Rows.Count > 0)
{
Repeater13.DataSource = das;
Repeater13.DataBind();
Repeater13.Visible = true;
string strsql2 = "select top " + gettop(8 - das.Tables[0].Rows.Count) + " * from tunnel_index where typeid=24 and del=0 and IsDel=0 order by setdate desc ";
DataSet das2 = Tunnel.Data.DbHelperSQL.Query(strsql2);
Repeater6.DataSource = das2;
Repeater6.DataBind();
}
else
{
string strsql2 = "select top 8 * from tunnel_index where typeid=24 and del=0 and IsDel=0 order by setdate desc";
DataSet das2 = Tunnel.Data.DbHelperSQL.Query(strsql2);
Repeater6.DataSource = das2;
Repeater6.DataBind();
Repeater6.Visible = true;
Repeater13.Visible = false;
}
}
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)
{
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.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 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)
{
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 bindlatest()
{
DataTable dtss = b_Ask.Sel("Status=2", "AddTime desc", null);
Repeater6.DataSource = dtss;
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 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 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();
}
public void exclusive()
{
DataTable dt = ad.gettop6exclusive();
if (dt.Rows.Count != 0)
{
Repeater6.DataSource = dt;
Repeater6.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();
}
}
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();
}
}
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();
}
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 RadioButtonList3_SelectedIndexChanged(object sender, EventArgs e)
{
string database = Session["DatabaseName"].ToString();
string SQLSelect = "Select * from EBudget_WBS where EWID=" + ViewState["EWID"].ToString();
if (RadioButtonList3.SelectedValue == "2")
{
string ResourceCode = WebModel.SItemName(database, SQLSelect, "ResourceCode");
SqlDataSource8.SelectCommand = "Select * from EBudget_WBS where ResourceCode='" + ResourceCode + "'";
}
else if (RadioButtonList3.SelectedValue == "1")
{
SqlDataSource8.SelectCommand = "";
Repeater6.DataBind();
}
}
protected void BindNewConsult()
{
int total = 0;
DataTable dt = new DataTable();
if (HttpRuntime.Cache[AppConst.AllNewConsult] == null)
{
dt = QA_QuestionBll.GetInstance().GetList(6, 1, "", 17, "replytimedown", ref total);
HttpRuntime.Cache.Insert(AppConst.AllNewConsult, dt,
null, DateTime.Now.AddMinutes(0), TimeSpan.Zero,
System.Web.Caching.CacheItemPriority.High, null);
}
dt = HttpRuntime.Cache[AppConst.AllNewConsult] as DataTable;
Repeater6.DataSource = dt;
Repeater6.DataBind();
}
protected void btnAddHomework6_Click(object sender, EventArgs e)
{
Homework homework = new Homework();
homework.Class = Convert.ToInt32(RadioButtonList1.SelectedValue);
homework.Subject = txtAddSubj6.Text;
homework.Homework1 = txtAddHomework6.Text;
string[] test = date6.Text.Split('/');
string ss = test[1] + "/" + test[0];
homework.Date = Convert.ToDateTime(ss);
db.Homeworks.InsertOnSubmit(homework);
db.SubmitChanges();
txtAddSubj6.Text = "";
txtAddHomework6.Text = "";
Repeater6.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)
{
DataSet1TableAdapters.TBLHAKKIMDATableAdapter dt = new DataSet1TableAdapters.TBLHAKKIMDATableAdapter();
Repeater1.DataSource = dt.HakkimdaListele();
Repeater1.DataBind();
DataSet1TableAdapters.TBLDENEYIMTableAdapter dt2 = new DataSet1TableAdapters.TBLDENEYIMTableAdapter();
Repeater2.DataSource = dt2.DeneyimListele();
Repeater2.DataBind();
DataSet1TableAdapters.TBLEGITIMTableAdapter dt3 = new DataSet1TableAdapters.TBLEGITIMTableAdapter();
Repeater3.DataSource = dt3.EgitimListele();
Repeater3.DataBind();
DataSet1TableAdapters.TBLHOBILERTableAdapter dt4 = new DataSet1TableAdapters.TBLHOBILERTableAdapter();
Repeater4.DataSource = dt4.HobiListele();
Repeater4.DataBind();
DataSet1TableAdapters.TBLSERTIFIKALARTableAdapter dt5 = new DataSet1TableAdapters.TBLSERTIFIKALARTableAdapter();
Repeater5.DataSource = dt5.SertifikalarListele();
Repeater5.DataBind();
DataSet1TableAdapters.TBLYETENEKLERTableAdapter dt6 = new DataSet1TableAdapters.TBLYETENEKLERTableAdapter();
Repeater6.DataSource = dt6.YeteneklerListele();
Repeater6.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(10).ToList();
Repeater6.DataSource = id;
Repeater6.DataBind();
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
Repeater1.DataSource = db.TBLHAKKIMDA.ToList();
Repeater1.DataBind();
Repeater2.DataSource = db.TBLHAKKIMDA.ToList();
Repeater2.DataBind();
Repeater3.DataSource = db.TBLYETENEKLER.ToList();
Repeater3.DataBind();
Repeater4.DataSource = db.TBLHAKKIMDA.ToList();
Repeater4.DataBind();
Repeater5.DataSource = db.TBLHAKKIMDA.ToList();
Repeater5.DataBind();
Repeater6.DataSource = db.TBLHAKKIMDA.ToList();
Repeater6.DataBind();
Repeater7.DataSource = db.TBLHAKKIMDA.ToList();
Repeater7.DataBind();
Repeater8.DataSource = db.TBLHAKKIMDA.ToList();
Repeater8.DataBind();
Repeater9.DataSource = db.TBLHAKKIMDA.ToList();
Repeater9.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//Hakkımızda Kısmını Listeleme
DataSet1TableAdapters.Tbl_HakkimdaTableAdapter db = new DataSet1TableAdapters.Tbl_HakkimdaTableAdapter();
Repeater1.DataSource = db.HakkimdaListele();
Repeater1.DataBind();
//Deneyimlerim Kısmını Listeleme
DataSet1TableAdapters.Tbl_DeneyimTableAdapter db2 = new DataSet1TableAdapters.Tbl_DeneyimTableAdapter();
Repeater2.DataSource = db2.DeneyimListesi();
Repeater2.DataBind();
//Eğitim Kismını Listeleme
DataSet1TableAdapters.Tbl_EgitimTableAdapter db3 = new DataSet1TableAdapters.Tbl_EgitimTableAdapter();
Repeater3.DataSource = db3.EgitimListesi();
Repeater3.DataBind();
//Hobi Kısmını Listeleme
DataSet1TableAdapters.Tbl_HobilerTableAdapter db4 = new DataSet1TableAdapters.Tbl_HobilerTableAdapter();
Repeater4.DataSource = db4.HobiListesi();
Repeater4.DataBind();
//Konferans Kısmını Listeleme
DataSet1TableAdapters.Tbl_KonferanslarTableAdapter db5 = new DataSet1TableAdapters.Tbl_KonferanslarTableAdapter();
Repeater5.DataSource = db5.KonferansListesi();
Repeater5.DataBind();
//Yetenek Kısmını Listeleme
DataSet1TableAdapters.Tbl_YeteneklerTableAdapter db6 = new DataSet1TableAdapters.Tbl_YeteneklerTableAdapter();
Repeater6.DataSource = db6.YetenekListesi();
Repeater6.DataBind();
// Resim Ekleme
DataSet1TableAdapters.Tbl_HakkimdaTableAdapter dt7 = new DataSet1TableAdapters.Tbl_HakkimdaTableAdapter();
Repeater7.DataSource = dt7.HakkimdaListele();
Repeater7.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//Hakkımda
DataSet1TableAdapters.tblHakkimdaTableAdapter dt = new DataSet1TableAdapters.tblHakkimdaTableAdapter();
Repeater1.DataSource = dt.hakkimdaListele();
Repeater1.DataBind();
//Deneyim
DataSet1TableAdapters.tblDeneyimTableAdapter dt2 = new DataSet1TableAdapters.tblDeneyimTableAdapter();
Repeater2.DataSource = dt2.DeneyimListele();
Repeater2.DataBind();
//Eğitim
DataSet1TableAdapters.tblEgitmTableAdapter dt3 = new DataSet1TableAdapters.tblEgitmTableAdapter();
Repeater3.DataSource = dt3.EgitimListele();
Repeater3.DataBind();
//Yetenek
DataSet1TableAdapters.tblYetenekTableAdapter dt4 = new DataSet1TableAdapters.tblYetenekTableAdapter();
Repeater4.DataSource = dt4.YetenekListesi();
Repeater4.DataBind();
//Hobi
DataSet1TableAdapters.tblHobiTableAdapter dt5 = new DataSet1TableAdapters.tblHobiTableAdapter();
Repeater5.DataSource = dt5.HobiListesi();
Repeater5.DataBind();
//Sertifika
DataSet1TableAdapters.tblSertifikalarTableAdapter dt6 = new DataSet1TableAdapters.tblSertifikalarTableAdapter();
Repeater6.DataSource = dt6.SertifikaListesi();
Repeater6.DataBind();
//Fotoğraf
DataSet1TableAdapters.tblAdminTableAdapter dt7 = new DataSet1TableAdapters.tblAdminTableAdapter();
Repeater7.DataSource = dt7.KullaniciListesi();
Repeater7.DataBind();
}
private void LoadSource()
{
int count = 0;
DataSet ds1 = m_IndexBLL.GetList("[typeId]=19 and del=0 and IsDel=0 ORDER BY [setDate] DESC");
DataTable dt1 = ds1.Tables[0].Clone();
for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
{
if (count >= 8)
{
break;
}
if (m_UserLogin.LoginID.ToString().Trim() == ds1.Tables[0].Rows[i]["userId"].ToString().Trim())
{
dt1.Rows.Add(ds1.Tables[0].Rows[i].ItemArray);
count++;
continue;
}
if (null != ds1.Tables[0].Rows[i]["readUser"] && ds1.Tables[0].Rows[i]["readUser"] != DBNull.Value)
{
string[] str = ds1.Tables[0].Rows[i]["readUser"].ToString().Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int j = 0; j < str.Length; j++)
{
if (m_UserLogin.LoginID.ToString().Trim() == str[j])
{
dt1.Rows.Add(ds1.Tables[0].Rows[i].ItemArray);
count++;
break;
}
}
}
}
Repeater1.DataSource = dt1;
Repeater1.DataBind();
count = 0;
DataSet ds2 = m_IndexBLL.GetList("[typeId]=20 and del=0 and IsDel=0 ORDER BY [setDate] DESC");
DataTable dt2 = ds2.Tables[0].Clone();
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
if (count >= 8)
{
break;
}
if (m_UserLogin.LoginID.ToString().Trim() == ds2.Tables[0].Rows[i]["userId"].ToString().Trim())
{
dt2.Rows.Add(ds2.Tables[0].Rows[i].ItemArray);
count++;
continue;
}
if (null != ds2.Tables[0].Rows[i]["readUser"] && ds2.Tables[0].Rows[i]["readUser"] != DBNull.Value)
{
string[] str = ds2.Tables[0].Rows[i]["readUser"].ToString().Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int j = 0; j < str.Length; j++)
{
if (m_UserLogin.LoginID.ToString().Trim() == str[j])
{
dt2.Rows.Add(ds2.Tables[0].Rows[i].ItemArray);
count++;
break;
}
}
}
}
Repeater2.DataSource = dt2;
Repeater2.DataBind();
count = 0;
DataSet ds3 = m_IndexBLL.GetList("[typeId]=21 and del=0 and bum_ba=0 ORDER BY [setDate] DESC");
DataTable dt3 = ds3.Tables[0].Clone();
for (int i = 0; i < ds3.Tables[0].Rows.Count; i++)
{
if (count >= 8)
{
break;
}
if (m_UserLogin.LoginID.ToString().Trim() == ds3.Tables[0].Rows[i]["userId"].ToString().Trim())
{
dt3.Rows.Add(ds3.Tables[0].Rows[i].ItemArray);
count++;
continue;
}
if (null != ds3.Tables[0].Rows[i]["readUser"] && ds3.Tables[0].Rows[i]["readUser"] != DBNull.Value)
{
string[] str = ds3.Tables[0].Rows[i]["readUser"].ToString().Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int j = 0; j < str.Length; j++)
{
if (m_UserLogin.LoginID.ToString().Trim() == str[j])
{
dt3.Rows.Add(ds3.Tables[0].Rows[i].ItemArray);
count++;
break;
}
}
}
}
Repeater3.DataSource = dt3;
Repeater3.DataBind();
count = 0;
DataSet ds4 = m_IndexBLL.GetList("[typeId]=22 and del=0 and IsDel=0 ORDER BY [setDate] DESC");
DataTable dt4 = ds4.Tables[0].Clone();
for (int i = 0; i < ds4.Tables[0].Rows.Count; i++)
{
if (count >= 8)
{
break;
}
if (m_UserLogin.LoginID.ToString().Trim() == ds4.Tables[0].Rows[i]["userId"].ToString().Trim())
{
dt4.Rows.Add(ds4.Tables[0].Rows[i].ItemArray);
count++;
continue;
}
if (null != ds4.Tables[0].Rows[i]["readUser"] && ds4.Tables[0].Rows[i]["readUser"] != DBNull.Value)
{
string[] str = ds4.Tables[0].Rows[i]["readUser"].ToString().Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int j = 0; j < str.Length; j++)
{
if (m_UserLogin.LoginID.ToString().Trim() == str[j])
{
dt4.Rows.Add(ds4.Tables[0].Rows[i].ItemArray);
count++;
break;
}
}
}
}
Repeater4.DataSource = dt4;
Repeater4.DataBind();
count = 0;
DataSet ds5 = m_IndexBLL.GetList("[typeId]=23 and del=0 and IsDel=0 ORDER BY [setDate] DESC");
DataTable dt5 = ds5.Tables[0].Clone();
for (int i = 0; i < ds5.Tables[0].Rows.Count; i++)
{
if (count >= 8)
{
break;
}
if (m_UserLogin.LoginID.ToString().Trim() == ds5.Tables[0].Rows[i]["userId"].ToString().Trim())
{
dt5.Rows.Add(ds5.Tables[0].Rows[i].ItemArray);
count++;
continue;
}
if (null != ds5.Tables[0].Rows[i]["readUser"] && ds5.Tables[0].Rows[i]["readUser"] != DBNull.Value)
{
string[] str = ds5.Tables[0].Rows[i]["readUser"].ToString().Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int j = 0; j < str.Length; j++)
{
if (m_UserLogin.LoginID.ToString().Trim() == str[j])
{
dt5.Rows.Add(ds5.Tables[0].Rows[i].ItemArray);
count++;
break;
}
}
}
}
Repeater5.DataSource = dt5;
Repeater5.DataBind();
count = 0;
DataSet ds6 = m_IndexBLL.GetList("[typeId]=24 and del=0 and IsDel=0 ORDER BY [setDate] DESC");
DataTable dt6 = ds6.Tables[0].Clone();
for (int i = 0; i < ds6.Tables[0].Rows.Count; i++)
{
if (count >= 8)
{
break;
}
if (m_UserLogin.LoginID.ToString().Trim() == ds6.Tables[0].Rows[i]["userId"].ToString().Trim())
{
dt6.Rows.Add(ds6.Tables[0].Rows[i].ItemArray);
count++;
continue;
}
if (null != ds6.Tables[0].Rows[i]["readUser"] && ds6.Tables[0].Rows[i]["readUser"] != DBNull.Value)
{
string[] str = ds6.Tables[0].Rows[i]["readUser"].ToString().Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int j = 0; j < str.Length; j++)
{
if (m_UserLogin.LoginID.ToString().Trim() == str[j])
{
dt6.Rows.Add(ds6.Tables[0].Rows[i].ItemArray);
count++;
break;
}
}
}
}
Repeater6.DataSource = dt6;
Repeater6.DataBind();
count = 0;
DataSet ds7 = m_IndexBLL.GetList("[typeId]=25 and del=0 and IsDel=0 ORDER BY [setDate] DESC");
DataTable dt7 = ds7.Tables[0].Clone();
for (int i = 0; i < ds6.Tables[0].Rows.Count; i++)
{
if (count >= 8)
{
break;
}
if (m_UserLogin.LoginID.ToString().Trim() == ds7.Tables[0].Rows[i]["userId"].ToString().Trim())
{
dt7.Rows.Add(ds7.Tables[0].Rows[i].ItemArray);
count++;
continue;
}
if (null != ds7.Tables[0].Rows[i]["readUser"] && ds7.Tables[0].Rows[i]["readUser"] != DBNull.Value)
{
string[] str = ds7.Tables[0].Rows[i]["readUser"].ToString().Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int j = 0; j < str.Length; j++)
{
if (m_UserLogin.LoginID.ToString().Trim() == str[j])
{
dt7.Rows.Add(ds7.Tables[0].Rows[i].ItemArray);
count++;
break;
}
}
}
}
Repeater7.DataSource = dt7;
Repeater7.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (SqlConnection conn = new DB().GetConnection())
{
// 焦点图
string sql = "select * from Focuses where Valid=1 order by orders desc";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
Repeater1.DataSource = rd;
Repeater1.DataBind();
rd.Close();
// GridView1 教师通知
cmd.CommandText = "select top 5 ID,Title,CDT from Articles where SubID = 6 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc";
rd = cmd.ExecuteReader();
Repeater4.DataSource = rd;
Repeater4.DataBind();
rd.Close();
//cmd.CommandText = "select top 5 ID,Title,CDT from Articles where SubID = 6 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc";
//rd = cmd.ExecuteReader();
//GridView1.DataSource = rd;
//GridView1.DataBind();
//rd.Close();
// GridView2 学生通知
cmd.CommandText = "select top 5 ID,Title,CDT from Articles where SubID = 7 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc";
rd = cmd.ExecuteReader();
Repeater3.DataSource = rd;
Repeater3.DataBind();
rd.Close();
//cmd.CommandText = "select top 5 ID,Title,CDT from Articles where SubID = 7 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc";
//rd = cmd.ExecuteReader();
//GridView2.DataSource = rd;
//GridView2.DataBind();
//rd.Close();
// GridView3 学院动态
//cmd.CommandText = "select top 5 ID,Title,CDT from Articles where SubID = 5 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc";
//rd = cmd.ExecuteReader();
//GridView3.DataSource = rd;
//GridView3.DataBind();
//rd.Close();
// GridView3 学院动态
cmd.CommandText = "select top 2 ID,Title,CDT from Articles where SubID = 5 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc";
rd = cmd.ExecuteReader();
Repeater5.DataSource = rd;
Repeater5.DataBind();
rd.Close();
//// GridView4 作品展示
//cmd.CommandText = "select top 4 ID,Title,Abs,Author,CoverPhotoURL,CDT,Catalog from Shows where Status =1 Order by Orders Desc,CDT Desc,ID Desc";
//rd = cmd.ExecuteReader();
//GridView4.DataSource = rd;
//GridView4.DataBind();
//rd.Close();
// GridView4 作品展示
//cmd.CommandText = "select top 4 ID,Title,Abs,Author,CoverPhotoURL,CDT,Catalog from Shows where Status =1 Order by Orders Desc,CDT Desc,ID Desc";
//rd = cmd.ExecuteReader();
//Repeater2.DataSource = rd;
//Repeater2.DataBind();
//rd.Close();
// GridView5 活动剪影
//cmd.CommandText = "select top 5 ID,Title,CDT from Articles where SubID = 39 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc";
//rd = cmd.ExecuteReader();
//GridView5.DataSource = rd;
//GridView5.DataBind();
//rd.Close();
// GridView5 活动剪影
cmd.CommandText = "select top 4 ID,Title,CDT from Articles where SubID = 39 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc";
rd = cmd.ExecuteReader();
Repeater6.DataSource = rd;
Repeater6.DataBind();
rd.Close();
conn.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
string strVideo = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database FoundersDB = new Call_Database();
Repeater1.DataSource = FoundersDB.dbFounders;
Repeater1.DataBind();
Call_Database VideoDB = new Call_Database();
strVideo = VideoDB.VideoLOAD();
urIframe.Attributes.Add("src", strVideo.ToString());
Call_Database CornerstoneDB = new Call_Database();
Repeater2.DataSource = CornerstoneDB.dbCornerstone;
Repeater2.DataBind();
Call_Database ScholarshipsDB = new Call_Database();
Repeater3.DataSource = ScholarshipsDB.dbScholarships;
Repeater3.DataBind();
Call_Database RoundtableDB = new Call_Database();
Repeater4.DataSource = RoundtableDB.dbRoundtable;
Repeater4.DataBind();
Call_Database PresidentsTabDB = new Call_Database();
Repeater5.DataSource = PresidentsTabDB.dbPresidentsTab;
Repeater5.DataBind();
Call_Database QuadrangleTabDB = new Call_Database();
Repeater6.DataSource = QuadrangleTabDB.dbQuadrangleTab;
Repeater6.DataBind();
Call_Database BlueGoldTabDB = new Call_Database();
Repeater7.DataSource = BlueGoldTabDB.dbBlueGoldTab;
Repeater7.DataBind();
Call_Database CenturyTabDB = new Call_Database();
Repeater8.DataSource = CenturyTabDB.dbCenturyTab;
Repeater8.DataBind();
Call_Database OtherDonorsTabDB = new Call_Database();
Repeater9.DataSource = OtherDonorsTabDB.dbOtherDonorsTab;
Repeater9.DataBind();
}
protected void FillInvoicesList(DataTable dt_invoices)
{
Invoice[] invoices = new Invoice[dt_invoices.Rows.Count];
int[] invoiceIDs = new int[dt_invoices.Rows.Count];
int countShowing = 0;
dt_invoices.Columns.Add("message_reversed_wiped", typeof(string));
dt_invoices.Columns.Add("td_name", typeof(string)); // for use of td 'name' tag to hide all reversed or hide all rejected
dt_invoices.Columns.Add("style_display", typeof(string)); // to set initially reversed and/or rejected as hidden
dt_invoices.Columns.Add("inv_debtor", typeof(string));
dt_invoices.Columns.Add("inv_total_due", typeof(decimal));
for (int i = 0; i < dt_invoices.Rows.Count; i++)
{
Invoice invoice = InvoiceDB.LoadAll(dt_invoices.Rows[i]);
invoiceIDs[i] = invoice.InvoiceID;
invoices[i] = invoice;
if (invoice.ReversedBy != null)
{
dt_invoices.Rows[i]["message_reversed_wiped"] = "Reversed";
dt_invoices.Rows[i]["td_name"] = "td_reversed";
dt_invoices.Rows[i]["style_display"] = "none";
}
else if (invoice.PayerOrganisation != null && (invoice.PayerOrganisation.OrganisationID == -1 || invoice.PayerOrganisation.OrganisationID == -2) && invoice.Total > 0 && invoice.CreditNotesTotal >= invoice.Total)
{
dt_invoices.Rows[i]["message_reversed_wiped"] = "Rejected";
dt_invoices.Rows[i]["td_name"] = "td_rejected";
dt_invoices.Rows[i]["style_display"] = "none";
}
else
{
countShowing++;
}
if (invoice.PayerOrganisation != null)
{
dt_invoices.Rows[i]["inv_debtor"] = invoice.PayerOrganisation.Name;
}
else if (invoice.PayerPatient != null)
{
dt_invoices.Rows[i]["inv_debtor"] = invoice.PayerPatient.Person.FullnameWithoutMiddlename;
}
else
{
dt_invoices.Rows[i]["inv_debtor"] = invoice.Booking != null &&
invoice.Booking.Patient != null &&
invoice.Booking.Patient.Person != null ? invoice.Booking.Patient.Person.FullnameWithoutMiddlename : string.Empty; // empty for invoices without bookings
}
dt_invoices.Rows[i]["inv_total_due"] = invoice.TotalDue.ToString();
}
// single db call to get invoicelines into hashtable lookup by invoice
Hashtable invoiceLinesHash = InvoiceLineDB.GetBulkInvoiceLinesByInvoiceID(invoices);
dt_invoices.Columns.Add("inv_lines_text", typeof(string));
for (int i = 0; i < dt_invoices.Rows.Count; i++)
{
Invoice invoice = InvoiceDB.LoadAll(dt_invoices.Rows[i]);
InvoiceLine[] invLines = (InvoiceLine[])invoiceLinesHash[invoice.InvoiceID];
bool showAreaTreated = invoice.PayerOrganisation != null && (invoice.PayerOrganisation.OrganisationID == -2 || invoice.PayerOrganisation.OrganisationType.OrganisationTypeID == 150);
bool showServiceReference = invoice.PayerOrganisation != null && invoice.PayerOrganisation.OrganisationType.OrganisationTypeID == 150;
string output = "<ul style=\"padding-left:14px;\">";
foreach (InvoiceLine invLine in invLines)
{
string extras = string.Empty;
if (showAreaTreated || showServiceReference)
{
string linkAreaTreated = "<a title=\"Edit\" onclick=\"javascript:window.showModalDialog('Invoice_UpdateAreaTreatedV2.aspx?inv_line=" + invLine.InvoiceLineID + "', '', 'dialogWidth:600px;dialogHeight:275px;center:yes;resizable:no; scroll:no');window.location.href=window.location.href;return false;\" href=\"#\">Edit</a>";
string linkServiceReference = "<a title=\"Edit\" onclick=\"javascript:window.showModalDialog('Invoice_UpdateServiceReferenceV2.aspx?inv_line=" + invLine.InvoiceLineID + "', '', 'dialogWidth:600px;dialogHeight:275px;center:yes;resizable:no; scroll:no');window.location.href=window.location.href;return false;\" href=\"#\">Edit</a>";
extras += "<table>";
if (showAreaTreated)
{
extras += "<tr><td>Area Treated</td><td style=\"min-width:10px;\"></td><td>" + (invLine.AreaTreated.Length == 0 ? "[EMPTY]" : invLine.AreaTreated) + "</td><td style=\"min-width:10px;\"></td><td>" + linkAreaTreated + "</td></tr>";
}
if (showServiceReference)
{
extras += "<tr><td>Service Reference</td><td style=\"min-width:10px;\"></td><td>" + (invLine.ServiceReference.Length == 0 ? "[EMPTY]" : invLine.ServiceReference) + "</td><td style=\"min-width:10px;\"></td><td>" + linkServiceReference + "</td></tr>";
}
extras += "</table>";
}
string itemDescr = string.Empty;
if (invLine.Offering != null)
{
itemDescr = invLine.Offering.Name;
}
if (invLine.Credit != null)
{
itemDescr = "Voucher: <i>" + invLine.Credit.VoucherDescr + "</i>";
}
output += "<li>" + itemDescr + " x " + ((invLine.Quantity % 1) == 0 ? Convert.ToInt32(invLine.Quantity) : invLine.Quantity) + " = " + invLine.Price + (invLine.Tax == 0 ? "" : " (<i>Inc GST</i>)") + (invLine.Patient.Person == null ? "" : " [" + invLine.Patient.Person.FullnameWithoutMiddlename + "]") + extras + "</li>";
}
output += "</ul>";
dt_invoices.Rows[i]["inv_lines_text"] = output;
if (countShowing == 0)
{
dt_invoices.Rows[i]["style_display"] = "";
}
}
//get approximate page width...
// 194 = row titles
// average row = 340 px (about 220-440)
// add 70px for good measure
int pageWidth = 194 + 365 * (countShowing == 0 ? 1 : countShowing) + 120;
Page.ClientScript.RegisterStartupScript(this.GetType(), "resize_window", "<script language=javascript>window.resizeTo( (" + pageWidth + "+ window.outerWidth - window.innerWidth) < screen.width ? (" + pageWidth + " + window.outerWidth - window.innerWidth) : screen.width , window.outerHeight);</script>");
if (dt_invoices.Rows.Count <= 1)
{
divToggleShowReversedRejected.Visible = false;
}
else if (countShowing == 0)
{
chkShowReversed.Checked = true;
chkShowRejected.Checked = true;
}
// now databind
Repeater1.DataSource = dt_invoices; Repeater1.DataBind();
Repeater2.DataSource = dt_invoices; Repeater2.DataBind();
Repeater3.DataSource = dt_invoices; Repeater3.DataBind();
Repeater4.DataSource = dt_invoices; Repeater4.DataBind();
Repeater5.DataSource = dt_invoices; Repeater5.DataBind();
Repeater6.DataSource = dt_invoices; Repeater6.DataBind();
Repeater7.DataSource = dt_invoices; Repeater7.DataBind();
Repeater8.DataSource = dt_invoices; Repeater8.DataBind();
Repeater9.DataSource = dt_invoices; Repeater9.DataBind();
Repeater10.DataSource = dt_invoices; Repeater10.DataBind();
Repeater11.DataSource = dt_invoices; Repeater11.DataBind();
Repeater12.DataSource = dt_invoices; Repeater12.DataBind();
Repeater13.DataSource = dt_invoices; Repeater13.DataBind();
Repeater14.DataSource = dt_invoices; Repeater14.DataBind();
Repeater15.DataSource = dt_invoices; Repeater15.DataBind();
Repeater16.DataSource = dt_invoices; Repeater16.DataBind();
Repeater17.DataSource = dt_invoices; Repeater17.DataBind();
Repeater18.DataSource = dt_invoices; Repeater18.DataBind();
Repeater19.DataSource = dt_invoices; Repeater19.DataBind();
// non booking invoices (ie standard invoices) will not have a booking
Booking booking = invoices[0].Booking;
if (booking != null)
{
string patientText = string.Empty;
if (booking != null && booking.Patient != null)
{
patientText = booking.Patient.Person.FullnameWithoutMiddlename;
}
else if (invoices[0].PayerPatient != null)
{
patientText = invoices[0].PayerPatient.Person.FullnameWithoutMiddlename;
}
else
{
patientText = "< No patient >";
}
// show booking info
lblBooking_Org.Text = booking.Organisation.Name;
lblBooking_Provider.Text = booking.Provider.Person.FullnameWithoutMiddlename;
lblBooking_Patient.Text = patientText; // booking.Patient.Person.FullnameWithoutMiddlename;
lblBooking_Offering.Text = booking.Offering == null ? "< No service >" : booking.Offering.Name;
lblBooking_BookingStatus.Text = booking.BookingStatus.Descr;
lblBooking_Time.Text = booking.DateStart.Date.ToString("dd MMM yyyy") + " - " + booking.DateStart.ToString("h:mm") + (booking.DateStart.Hour < 12 ? "am" : "pm") + "-" + booking.DateEnd.ToString("h:mm") + (booking.DateEnd.Hour < 12 ? "am" : "pm");
lblBooking_PatientMissedAppt.Text = booking.IsPatientMissedAppt ? "Yes" : "No";
lblBooking_ProviderMissedAppt.Text = booking.IsProviderMissedAppt ? "Yes" : "No";
lblBooking_Emergency.Text = booking.IsEmergency ? "Yes" : "No";
lblBooking_Notes.Text = Note.GetPopupLinkTextV2(15, booking.EntityID, booking.NoteCount > 0, true, 1050, 530, "images/notes-bw-24.jpg", "images/notes-24.png");
}
else
{
booking_space.Visible = false;
booking_title.Visible = false;
booking_offering.Visible = false;
booking_patient.Visible = false;
booking_provider.Visible = false;
booking_org.Visible = false;
booking_status.Visible = false;
booking_apptmt_time.Visible = false;
booking_patiemt_missed_apptmt.Visible = false;
booking_provider_missed_apptmt.Visible = false;
booking_isemergency.Visible = false;
booking_notes.Visible = false;
}
}
