/// <summary>连接服务器/数据库</summary>
public static bool OpenDataBase(string hostID, string databaseName, string userName, string password, ExecuteErrorEventHandler handler)
{
DBInfo dbInfo = new DBInfo();
dbInfo.ProviderName = OleDbEnum.SQLSERVER;
dbInfo.HostID = hostID;
dbInfo.DatabaseName = databaseName;
dbInfo.UserName = userName;
dbInfo.Password = password;
OleDbHelper = new OleDbHelper(dbInfo);
OleDbHelper.ExecuteError += handler;
return OleDbHelper.ConnState == System.Data.ConnectionState.Open;
}
/// <summary>
/// 获取全部
/// </summary>
/// <returns></returns>
public List <UserInfo> GetUserList()
{
string cmdText = string.Format("select * from [{0}users] order by [sortnum] asc,[userid] asc", ConfigHelper.Tableprefix);
return(DataReaderToUserList(OleDbHelper.ExecuteReader(cmdText)));
}
public DataTable getall()
{
string sqlstr = "select * from type12";
return(OleDbHelper.executeDataAdapter(sqlstr, CommandType.Text, null));
}
//kullanıcı izle butonuna basarsa;
private void btnWatch_Click(object sender, EventArgs e)
{
//global datatable'in içerisini temizlerken datagridview boş kaldığı için geçici datatable tanımlıyoruz.
DataTable tempDataTable = new DataTable();
int index = dataGridView1.SelectedCells[0].RowIndex;
//izlenen program bilgilerini diğer formalarda kullanabilmek için static program nesnesine atıyoruz.
selectedProgram = new ProgramInfo
(Convert.ToInt32(dataGridView1.Rows[index].Cells[0].Value.ToString()),
dataGridView1.Rows[index].Cells[1].Value.ToString(),
dataGridView1.Rows[index].Cells[2].Value.ToString(),
Convert.ToInt32(dataGridView1.Rows[index].Cells[3].Value.ToString()),
Convert.ToInt32(dataGridView1.Rows[index].Cells[4].Value.ToString()));
sqlQuery = "SELECT * FROM KullaniciProgram WHERE KullaniciID = " + user.Id + " and ProgramID=" + selectedProgram.Id + " ";;
tempDataTable = OleDbHelper.GetData(tempDataTable, sqlQuery);
//seçilen program daha önce izlenmemişse
if (tempDataTable.Rows.Count == 0)
{
sqlQuery = " insert into KullaniciProgram VALUES ('" + user.Id + "', '" + selectedProgram.Id + "','30','1', '0', '" + DateTime.Now + "') ";
if (OleDbHelper.insertData(sqlQuery))
{
MessageBox.Show("Program bilgileri veritabanına eklendi!");
openMainForm();
}
}
//film veya dizi daha önce izlenmeye başlanmışsa
else
{
sqlQuery = "select P.*, KP.KalinanBolum AS KalinanBolum, KP.Sure AS Sure from " +
"(Program AS P INNER JOIN KullaniciProgram AS KP ON P.ID=KP.ProgramID)" +
" WHERE KP.ProgramID = " + selectedProgram.Id + " and KP.KullaniciID=" + user.Id + " ";
clearDataTable(tempDataTable);
OleDbHelper.GetData(tempDataTable, sqlQuery);
//Bolum sayisi 1'den buyuk ise dizidir.
if (selectedProgram.BolumSayisi > 1)
{
int kalinanBolum = Convert.ToInt32(tempDataTable.Rows[0]["KalinanBolum"]);
if (kalinanBolum <= selectedProgram.BolumSayisi)
{
string message = user.Ad + " bu diziyi zaten izlemektesiniz, sonraki bolume geçmek ister misiniz ?";
string title = "Hey!";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result = MessageBox.Show(message, title, buttons);
if (result == DialogResult.Yes)
{
sqlQuery = "update KullaniciProgram set Sure='30', KalinanBolum=" +
(kalinanBolum + 1) + "" +
", Tarih='" + DateTime.Now + "' where KullaniciID=" + user.Id +
" and ProgramID=" + selectedProgram.Id + " ";
if (OleDbHelper.insertData(sqlQuery))
{
MessageBox.Show("Sonraki bölüme geçildi!");
openMainForm();
}
}
}
else
{
string message = "Bu diziyi daha önce bitirmişsiniz tekrar başlamak ister misiniz ?";
string title = "Hey!";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result = MessageBox.Show(message, title, buttons);
if (result == DialogResult.Yes)
{
sqlQuery = "update KullaniciProgram set Sure='30', KalinanBolum='1', Tarih='" +
DateTime.Now + "' where KullaniciID=" + user.Id + " and ProgramID=" +
selectedProgram.Id + " ";
if (OleDbHelper.updateData(sqlQuery))
{
openMainForm();
}
}
}
}
//Seçilen programın bolum sayisi 1 ise ve film daha önce yarım kaldıysa;
else
{
string message = "Bu filmi daha önce izlemeye başlamışsınız, kaldığınız yerden devam etmek ister misiniz ?";
string title = "Hey!";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result = MessageBox.Show(message, title, buttons);
if (result == DialogResult.Yes)
{
sqlQuery = "update KullaniciProgram set Sure='" + selectedProgram.BolumUzunluk + "', KalinanBolum='1', Tarih='" +
DateTime.Now + "' where KullaniciID=" + user.Id + " and ProgramID=" + selectedProgram.Id +
" ";
if (OleDbHelper.updateData(sqlQuery))
{
openMainForm();
}
}
}
}
}
public static DataSet GetSubByID(int id)
{
string id1 = stringbuilder(id.ToString());
return(OleDbHelper.Fill("SELECT * FROM " + TABEL + " WHERE " + filed1 + " = " + id, "subByIdTbl"));
}
protected override void Render(HtmlTextWriter writer)
{
if (Request.QueryString["t1"] == "ajaxLoad")
{
string virtualParentKey = Request.QueryString["virtualParentKey"];
string para = string.Empty; // "= 1";
if (virtualParentKey == null)
{
para = " is NULL";
}
else
{
para = "=" + virtualParentKey;
}
string sql = @"SELECT p1.[ProductID] as ProductID, p1.[ProductName] as ProductName, p1.[ParentID] as ParentID, p3.childNodesCount as ChildNodesCount
FROM [Products] p1
LEFT OUTER JOIN
(
SELECT COUNT(*) AS childNodesCount , p2.[ParentID] AS pId
FROM [Products] p2
GROUP BY p2.[ParentID]
) p3
ON p1.[ProductID] = p3.pId
WHERE p1.[ParentID] " + para;
DataTable dt = OleDbHelper.ExecuteDataset(base.NorthWindConnectionString, CommandType.Text, sql).Tables[0];
ASTreeViewNode root = new ASTreeViewNode("root");
foreach (DataRow dr in dt.Rows)
{
string productName = dr["ProductName"].ToString();
string productId = dr["ProductID"].ToString();
string parentId = dr["ParentID"].ToString();
int childNodesCount = 0;
if (!string.IsNullOrEmpty(dr["ChildNodesCount"].ToString()))
{
childNodesCount = int.Parse(dr["ChildNodesCount"].ToString());
}
ASTreeViewLinkNode node = new ASTreeViewLinkNode(productName, productId);
node.VirtualNodesCount = childNodesCount;
node.VirtualParentKey = productId;
node.IsVirtualNode = childNodesCount > 0;
node.NavigateUrl = "#";
node.AdditionalAttributes.Add(new KeyValuePair <string, string>("onclick", "return false;"));
root.AppendChild(node);
}
HtmlGenericControl ulRoot = new HtmlGenericControl("ul");
astvMyTree2.TreeViewHelper.ConvertTree(ulRoot, root, false);
foreach (Control c in ulRoot.Controls)
{
c.RenderControl(writer);
}
}
else if (Request.QueryString["t2"] == "ajaxAdd")
{
string addNodeText = Request.QueryString["addNodeText"];
int parentNodeValue = int.Parse(Request.QueryString["parentNodeValue"]);
string maxSql = "select max( productId ) from products";
int max = (int)OleDbHelper.ExecuteScalar(base.NorthWindConnectionString, CommandType.Text, maxSql);
int newId = max + 1;
string sql = string.Format(@"INSERT INTO products( productid, Discontinued, productname, parentid ) values( {0} ,0, '{1}', {2})"
, max + 1, addNodeText.Replace("'", "''"), parentNodeValue);
int i = OleDbHelper.ExecuteNonQuery(base.NorthWindConnectionString, CommandType.Text, sql);
ASTreeViewNode root = new ASTreeViewNode("root");
ASTreeViewLinkNode node = new ASTreeViewLinkNode(addNodeText, newId.ToString());
node.NavigateUrl = "#";
node.AdditionalAttributes.Add(new KeyValuePair <string, string>("onclick", "return false;"));
root.AppendChild(node);
HtmlGenericControl ulRoot = new HtmlGenericControl("ul");
astvMyTree2.TreeViewHelper.ConvertTree(ulRoot, root, false);
foreach (Control c in ulRoot.Controls)
{
c.RenderControl(writer);
}
}
else
{
base.Render(writer);
}
}
public string tjsellcount()
{
string sqlstr = "select sum(ordercount) from orders ";
return(OleDbHelper.executeScalar(sqlstr, CommandType.Text, null));
}
public string tjuser()
{
string sqlstr = "select count(*) from userinfo where power=1";
return(OleDbHelper.executeScalar(sqlstr, CommandType.Text, null));
}
public static DataSet GetuserByAdmin(int Admin)
{
return(OleDbHelper.Fill("select * from UserTBL WHERE MyAdmin = " + Admin, "userByAdminTbl"));
}
public static DataSet InnerjoinSeries(string id)
{
id = "\"" + id + "\"";
return(OleDbHelper.Fill("SELECT UserTBL.username, SeriesAndUserTBL.SeriesID FROM " + TABEL + " INNER JOIN " + TABEL2 + " ON UserTBL.username = SeriesAndUserTBL.UserID WHERE SeriesAndUserTBL.UserID = " + id, "sandstbl"));
}
public static DataSet GetAll()
{
return(OleDbHelper.Fill("select * from UserTBL", "UserTBL"));
}
public static DataSet GetAdminByID(int id)
{
string id1 = stringbuilder(id.ToString());
return(OleDbHelper.Fill("select * from " + TABEL + " WHERE " + filed1 + " = " + id, "adminByIdTbl"));
}
public List <PostInfo> GetPostList(int pageSize, int pageIndex, out int recordCount, int categoryId, int tagId, int userId, int recommend, int status, int topstatus, int PostStatus, string begindate, string enddate, string keyword)
{
string condition = " 1=1 ";
if (categoryId != -1)
{
condition += " and categoryId=" + categoryId;
}
if (tagId != -1)
{
condition += " and tag like '%{" + tagId + "}%'";
}
if (userId != -1)
{
condition += " and userid=" + userId;
}
if (recommend != -1)
{
condition += " and recommend=" + recommend;
}
if (status != -1)
{
condition += " and status=" + status;
}
if (topstatus != -1)
{
condition += " and topstatus=" + topstatus;
}
if (PostStatus != -1)
{
condition += " and PostStatus=" + PostStatus;
}
if (!string.IsNullOrEmpty(begindate))
{
condition += " and PostTime>=#" + begindate + "#";
}
if (!string.IsNullOrEmpty(enddate))
{
condition += " and PostTime<#" + enddate + "#";
}
if (!string.IsNullOrEmpty(keyword))
{
condition += string.Format(" and (summary like '%{0}%' or title like '%{0}%' )", keyword);
}
string cmdTotalRecord = "select count(1) from [" + ConfigHelper.Tableprefix + "posts] where " + condition;
// throw new Exception(cmdTotalRecord);
recordCount = TypeConverter.ObjectToInt(OleDbHelper.ExecuteScalar(CommandType.Text, cmdTotalRecord));
string cmdText = OleDbHelper.GetPageSql("[" + ConfigHelper.Tableprefix + "Posts]", "[PostId]", "*", pageSize, pageIndex, 1, condition);
using (var conn = dapper.OpenConnection())
{
var list = conn.Query <PostInfo>(cmdText, null);
return(list.ToList());
}
}
protected void btnAddShop_Click(object sender, EventArgs e)
{
if (w_ID == "")
{
Response.Redirect("index.aspx");
return;
}
if (Session["userid"] != null)
{
u_ID = Session["userid"].ToString();
string strsel = "select * from Db_user where ID=" + u_ID;
DataTable dtsel = OleDbHelper.GetDataTable(strsel);
if (dtsel.Rows.Count > 0)
{
u_Shop = dtsel.Rows[0]["userShopCart"].ToString();
}
if (u_Shop.Equals(""))
{
u_Shop = w_ID + ",1000,";
}
else
{
string[] stru_s = u_Shop.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
int i;
for (i = 0; i < stru_s.Length; i++)
{
if (w_ID == stru_s[i])
{
int count = Convert.ToInt32(stru_s[i + 1]);
count += 1000;
stru_s[i + 1] = count.ToString();
break;
}
}
u_Shop = "";
foreach (string s in stru_s)
{
u_Shop += s + ",";
}
if (i == stru_s.Length)
{
u_Shop += w_ID + "," + "1000" + ",";
}
}
string strudp = "update Db_User set userShopCart=@shop where ID=@id";
OleDbParameter[] paras =
{
new OleDbParameter("@shop", u_Shop),
new OleDbParameter("@id", u_ID)
};
int flag = OleDbHelper.ExecuteSql(strudp, paras);
if (flag > 0)
{
Response.Redirect("check.aspx");
}
else
{
Response.Write("<script>alert('添加出错，请重新加入购物车')</script>");
return;
}
}
else
{
Response.Write("<script>alert('您还未登录，请登录后再进行购物！');window.location='userLogin.aspx';</script>");
return;
}
}
public DataTable getUser()
{
String sqlstr = "select * from userinfo order by power desc ";
return(OleDbHelper.executeDataAdapter(sqlstr, CommandType.Text, null));
}
public string tjproduct()
{
string sqlstr = "select count(*) from products";
return(OleDbHelper.executeScalar(sqlstr, CommandType.Text, null));
}
public static DataSet GetuserByID(string username)
{
username = "******"" + username + "\"";
return(OleDbHelper.Fill("select * from UserTBL WHERE username = "******"userByIdTbl"));
}
public string tjorder()
{
string sqlstr = "select count(*) from orders where state=4";
return(OleDbHelper.executeScalar(sqlstr, CommandType.Text, null));
}
protected override void Render(HtmlTextWriter writer)
{
if (Request.QueryString["t"] == "ajaxAdd")
{
string addNodeText = HttpUtility.UrlDecode(Request.QueryString["addNodeText"]);
int parentNodeValue = int.Parse(HttpUtility.UrlDecode(Request.QueryString["parentNodeValue"]));
string maxSql = "select max( productId ) from products";
int max = (int)OleDbHelper.ExecuteScalar(base.NorthWindConnectionString, CommandType.Text, maxSql);
int newId = max + 1;
string sql = string.Format(@"INSERT INTO products( productid, Discontinued, productname, parentid ) values( {0} ,0, '{1}', {2})"
, max + 1, addNodeText.Replace("'", "''"), parentNodeValue);
int i = OleDbHelper.ExecuteNonQuery(base.NorthWindConnectionString, CommandType.Text, sql);
ASTreeViewNode root = new ASTreeViewNode("root");
ASTreeViewLinkNode node = new ASTreeViewLinkNode(addNodeText, newId.ToString());
node.NavigateUrl = "#";
node.AdditionalAttributes.Add(new KeyValuePair <string, string>("onclick", "return false;"));
root.AppendChild(node);
HtmlGenericControl ulRoot = new HtmlGenericControl("ul");
astvMyTree.TreeViewHelper.ConvertTree(ulRoot, root, false);
foreach (Control c in ulRoot.Controls)
{
c.RenderControl(writer);
}
/*
* foreach( DataRow dr in dt.Rows )
* {
* string productName = dr["ProductName"].ToString();
* string productId = dr["ProductID"].ToString();
* string parentId = dr["ParentID"].ToString();
* int childNodesCount = 0;
* if( !string.IsNullOrEmpty( dr["ChildNodesCount"].ToString() ) )
* childNodesCount = int.Parse( dr["ChildNodesCount"].ToString() );
*
* ASTreeViewLinkNode node = new ASTreeViewLinkNode( productName, productId );
* node.VirtualNodesCount = childNodesCount;
* node.VirtualParentKey = productId;
* node.IsVirtualNode = childNodesCount > 0;
* node.NavigateUrl = "#";
* node.AdditionalAttributes.Add( new KeyValuePair<string, string>( "onclick", "return false;" ) );
*
* root.AppendChild( node );
* }
*
*
*
* HtmlGenericControl ulRoot = new HtmlGenericControl( "ul" );
* astvMyTree.TreeViewHelper.ConvertTree( ulRoot, root, false );
* foreach( Control c in ulRoot.Controls )
* c.RenderControl( writer );*/
}
else
{
base.Render(writer);
}
}
private void getOrders()
{
if (Session["userid"] != null)
{
StringBuilder listString = new StringBuilder();
u_ID = Session["userid"].ToString();
string struser = "******" + u_ID + "' and oState<>'已评价' order by ID desc";
DataTable dtorders = OleDbHelper.GetDataTable(struser);
dtorders.Columns.Add("btnText", Type.GetType("System.String"));
if (dtorders.Rows.Count > 0)
{
for (int oi = 0; oi < dtorders.Rows.Count; oi++)
{
u_Shop = dtorders.Rows[oi]["oProject"].ToString();
string strbind = "";
if (!u_Shop.Equals(""))
{
string[] s_c = u_Shop.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
w_IDs = new string[s_c.Length / 2 + 1];
int j = 0;
//添加temp参数
for (int i = 0; i < s_c.Length; i++)
{
if (i % 2 == 0)
{
if (s_c[i] != "")
{
w_IDs[j] = s_c[i];
string strsql = "update Db_Prodouct set temp='" + (Convert.ToInt32(s_c[i + 1]) / 1000).ToString() + "' where ID=" + w_IDs[j];
int flag = OleDbHelper.ExecuteSql(strsql);
if (flag < 1)
{
Response.Write("<script>alert('1发生错误！')</script>");
}
j++;
}
}
}
//获取ID列
w_ListID = "";
foreach (string s in w_IDs)
{
if (s != "")
{
w_ListID += s + ",";
}
}
strbind = "select * from Db_Prodouct where ID in(" + w_ListID.Substring(0, w_ListID.Length - 1) + ")";
}
else
{
strbind = "select * from Db_Prodouct where ID=0";
}
DataTable dtbind = OleDbHelper.GetDataTable(strbind);
num = 0;
sum = 0;
listString.Clear();
listString.Append("");
for (int i = 0; i < dtbind.Rows.Count; i++)
{
listString.Append(dtbind.Rows[i]["pTitle"].ToString());
listString.Append("*");
listString.Append(dtbind.Rows[i]["temp"].ToString());
listString.Append("<br />");
num += Convert.ToInt32(dtbind.Rows[i]["temp"].ToString());
sum += Convert.ToInt32(dtbind.Rows[i]["temp"].ToString()) * Convert.ToInt32(dtbind.Rows[i]["pPrice"].ToString());
}
if (!dtorders.Rows[oi]["oState"].ToString().Equals("已收货") && !dtorders.Rows[oi]["oState"].ToString().Equals("已评价"))
{
dtorders.Rows[oi]["btnText"] = "确认收货";
}
else if (dtorders.Rows[oi]["oState"].ToString().Equals("已收货"))
{
dtorders.Rows[oi]["btnText"] = "等待评价";
}
else
{
dtorders.Rows[oi]["btnText"] = "订单完成";
}
dtorders.Rows[oi]["oPrice"] = sum.ToString();
dtorders.Rows[oi]["oProject"] = listString;
//清空temp
string strdel = "update Db_Prodouct set temp=''";
int f = -1;
f = OleDbHelper.ExecuteSql(strdel);
if (f == -1)
{
Response.Write("<script>alert('2发生错误！')</script>");
}
}
PagedDataSource pds = new PagedDataSource();
pds.PageSize = AspNetPager1.PageSize;
pds.AllowPaging = true;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
AspNetPager1.RecordCount = dtorders.Rows.Count;
int pagecount = AspNetPager1.PageCount;
DataView dv = dtorders.DefaultView;
pds.DataSource = dv;
rptbind.DataSource = pds;
rptbind.DataBind();
}
else
{
Response.Write("<script>alert('你没有未完成订单！')</script>");
}
}
else
{
Response.Redirect("userLogin.aspx");
}
}
protected override void Render(HtmlTextWriter writer)
{
if (this.Page.Request.QueryString["t1"] == "ajaxLoad")
{
#region ajaxLoad
string virtualParentKey = this.Page.Request.QueryString["virtualParentKey"];
string para = string.Empty; // "= 1";
if (virtualParentKey == null)
{
para = " is NULL";
}
else
{
para = "=" + virtualParentKey;
}
string sql = @"SELECT p1.[ProductID] as ProductID, p1.[ProductName] as ProductName, p1.[ParentID] as ParentID, p3.childNodesCount as ChildNodesCount
FROM [Products] p1
LEFT OUTER JOIN
(
SELECT COUNT(*) AS childNodesCount , p2.[ParentID] AS pId
FROM [Products] p2
GROUP BY p2.[ParentID]
) p3
ON p1.[ProductID] = p3.pId
WHERE p1.[ParentID] " + para;
DataTable dt = OleDbHelper.ExecuteDataset(this.NorthWindConnectionString, CommandType.Text, sql).Tables[0];
ASTreeViewNode root = new ASTreeViewNode("root");
foreach (DataRow dr in dt.Rows)
{
string productName = dr["ProductName"].ToString();
string productId = dr["ProductID"].ToString();
string parentId = dr["ParentID"].ToString();
int childNodesCount = 0;
if (!string.IsNullOrEmpty(dr["ChildNodesCount"].ToString()))
{
childNodesCount = int.Parse(dr["ChildNodesCount"].ToString());
}
ASTreeViewLinkNode node = new ASTreeViewLinkNode(productName, productId);
node.VirtualNodesCount = childNodesCount;
node.VirtualParentKey = productId;
node.IsVirtualNode = childNodesCount > 0;
node.NavigateUrl = "#";
node.AdditionalAttributes.Add(new KeyValuePair <string, string>("onclick", "return false;"));
root.AppendChild(node);
}
writer.Write(astvMyTree.AjaxResponseStartTag);
HtmlGenericControl ulRoot = new HtmlGenericControl("ul");
astvMyTree.TreeViewHelper.ConvertTree(ulRoot, root, false);
foreach (Control c in ulRoot.Controls)
{
c.RenderControl(writer);
}
writer.Write(astvMyTree.AjaxResponseEndTag);
#endregion
}
else if (this.Page.Request.QueryString["t2"] == "ajaxAdd")
{
#region ajaxAdd
string addNodeText = this.Page.Request.QueryString["addNodeText"];
int parentNodeValue = int.Parse(this.Page.Request.QueryString["parentNodeValue"]);
string maxSql = "select max( productId ) from products";
int max = (int)OleDbHelper.ExecuteScalar(this.NorthWindConnectionString, CommandType.Text, maxSql);
int newId = max + 1;
string sql = string.Format(@"INSERT INTO products( productid, Discontinued, productname, parentid ) values( {0} ,0, '{1}', {2})"
, max + 1, addNodeText.Replace("'", "''"), parentNodeValue);
int i = OleDbHelper.ExecuteNonQuery(this.NorthWindConnectionString, CommandType.Text, sql);
ASTreeViewNode root = new ASTreeViewNode("root");
ASTreeViewLinkNode node = new ASTreeViewLinkNode(addNodeText, newId.ToString());
node.NavigateUrl = "#";
node.AdditionalAttributes.Add(new KeyValuePair <string, string>("onclick", "return false;"));
root.AppendChild(node);
writer.Write(astvMyTree.AjaxResponseStartTag);
HtmlGenericControl ulRoot = new HtmlGenericControl("ul");
astvMyTree.TreeViewHelper.ConvertTree(ulRoot, root, false);
foreach (Control c in ulRoot.Controls)
{
c.RenderControl(writer);
}
writer.Write(astvMyTree.AjaxResponseEndTag);
#endregion
}
else
{
base.Render(writer);
#region render click script
string clickScript = string.Format(@"
<script type='text/javascript'>
function nodeSelectHandler{0}(elem){{
document.getElementById('{1}').value = encodeURIComponent(elem.innerHTML);
document.getElementById('{2}').value = elem.parentNode.getAttribute(""treeNodeValue"");
document.getElementById('{3}').click();
}}
</script>"
, this.ClientID /*0*/
, this.hfSelectedNodeText.ClientID /*1*/
, this.hfSelectedNodeValue.ClientID /*2*/
, this.btnPostBackTrigger.ClientID /*3*/);
writer.Write(clickScript);
#endregion
}
}
public static DataSet GetAll()
{
return(OleDbHelper.Fill("select * from " + TABEL, TABEL));
}
/// <summary>
/// Run the procedure(Inherited from Base). return type void.
/// </summary>
public void Run()
{
OleDbHelper.ExecuteNonQuery(base.ConnectionString, CommandType.StoredProcedure, StoredProcedureName, ConvertToSQLParam(Parameters));
}
public void TestMethod1()
{
var table = OleDbHelper.GetTable("SELECT * FROM T_ServiceList");
Assert.AreEqual(2, table.Rows.Count);
}
/// <summary>
///
/// </summary>
/// <param name="parameters"></param>
/// <returns></returns>
public IDataReader ExecuteReader(string connectionString)
{
//OleDbDataReader dr;
return(OleDbHelper.ExecuteReader(connectionString, CommandType.StoredProcedure, StoredProcedureName));
}
public List <LinkInfo> GetLinkList()
{
string cmdText = string.Format("select * from [{0}links] order by [sortnum] asc,[linkid] asc", ConfigHelper.Tableprefix);
return(DataReaderToListLink(OleDbHelper.ExecuteReader(cmdText)));
}
/// <summary>
/// Run the procedure(Inherited from Base). return type void.
/// </summary>
public void Run(IList <CustomParameter> param)
{
OleDbHelper.ExecuteNonQuery(base.ConnectionString, CommandType.StoredProcedure, StoredProcedureName, ConvertToSQLParam(param));
}
public int getpro(string typeid_2)
{
string sqlstr = "select count(*) from products where typeid_2=" + typeid_2;
return(Convert.ToInt32(OleDbHelper.executeScalar(sqlstr, CommandType.Text, null)));
}
/// <summary>
/// Run the procedure(Inherited from Base) with the specific transaction and required Parameters.
/// </summary>
/// <param name="transaction">OleDb Transaction</param>
/// <param name="parameters">Parameters that required by the procedure.</param>
public void Run(IDbTransaction transaction, IList <CustomParameter> parameters)
{
OleDbHelper.ExecuteNonQuery((OleDbTransaction)transaction, CommandType.StoredProcedure, StoredProcedureName, ConvertToSQLParam(parameters));
}
public string tjtype2()
{
string sqlstr = "select count(*) from type_2";
return(OleDbHelper.executeScalar(sqlstr, CommandType.Text, null));
}
public static DataSet InnerjoinEpi(int id)
{
return(OleDbHelper.Fill("SELECT SeriesTBL.SeriesID, episodeTBL.EpisdeID FROM " + TABEL + " INNER JOIN " + TABEL3 + " ON episodeTBL.EpiSeries = SeriesTBL.SeriesID WHERE SeriesTBL.SeriesID = " + id, "pandstbl"));
}
