public string[] GetProList(string prefixText, string count)
{
SqlComm sqlcomm = new SqlComm();
System.Data.DataTable dt = sqlcomm.getDataByCondition("dbo.View_Product", "top " + count + " product_name,product_id", " product_name like '%" + prefixText + "%' order by product_name desc");
if (dt != null && dt.Rows.Count > 0)
{
string[] prolist = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
prolist[i] = dt.Rows[i]["product_name"].ToString();
}
return prolist;
}
else
{
return null;
}
}
public string[] GetNewsList(string prefixText, string count)
{
SqlComm sqlcomm = new SqlComm();
System.Data.DataTable dt = sqlcomm.getDataByCondition("dbo.Veiw_News", " top " + count + " NewsID,NewsTitle", " NewsTitle like '%" + prefixText + "%' order by NewsTitle desc");
if (dt != null && dt.Rows.Count > 0)
{
string[] newstitle = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
newstitle[i] = dt.Rows[i]["NewsTitle"].ToString();
}
return newstitle;
}
else
{
return null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] != null)
{
this.lbUserName.Text = Session["username"].ToString();
lbUser.Visible = true;
}
if (Session["Cid"] != null)
{
SqlComm sql = new SqlComm();
System.Data.DataTable dt= sql.getDataByCondition("dbo.TbCat", "isnull(sum(num),0)", "Customerid=" + Session["Cid"].ToString() + " AND isOrders=0");
if (dt != null && dt.Rows.Count > 0)
{
sum = int.Parse(dt.Rows[0][0].ToString());
}
else
{
sum = 0;
}
}
}