/// <summary>
/// 得到所有类别下拉列表
/// </summary>
/// <returns></returns>
public DataTable ProductTypeDDlist()
{
bll.Attributebll attrbll = new bll.Attributebll();
DataTable dt1 = new DataTable();
dt1 = attrbll.GetTypeDDlist();
return(dt1);
}
/// <summary>
/// 品牌下拉列表
/// </summary>
/// <returns></returns>
public DataTable ProductStyleDDlist(string Courstomer)
{
bll.Attributebll attrbll = new bll.Attributebll();
DataTable dt1 = new DataTable();
dt1 = attrbll.GetCatDDlist(Courstomer);
return(dt1);
}
/// <summary>
/// 显示数据源列表
/// </summary>
/// <returns></returns>
public string GetVencodeDDlist()
{
string s = string.Empty;
DataTable dt1 = new DataTable();
bll.Attributebll attrbll = new bll.Attributebll();
dt1 = DbHelperSQL.Query(@"select * from productsource").Tables[0];
s += "<option value=''>请选择</option>";
for (int i = 0; i < dt1.Rows.Count; i++)
{
s += "<option value='" + dt1.Rows[i]["SourceCode"].ToString() + "'>" + dt1.Rows[i]["sourceName"].ToString() + "</option>";
}
return(s);
}
/// <summary>
/// 类别下拉列表
/// </summary>
/// <returns></returns>
public string ProductTypeDDlist()
{
string s = string.Empty;
DataTable dt1 = new DataTable();
bll.Attributebll attrbll = new bll.Attributebll();
dt1 = attrbll.GetTypeDDlist(userInfo.User.Id.ToString());
s += "<option value=''>请选择</option>";
for (int i = 0; i < dt1.Rows.Count; i++)
{
s += "<option value='" + dt1.Rows[i][1].ToString() + "'>" + dt1.Rows[i][0].ToString() + "</option>";
}
return(s);
}
/// <summary>
/// 品牌下拉列表
/// </summary>
/// <returns></returns>
public string GetBrandDDlist(int UserId)
{
string s = string.Empty;
bll.Attributebll attrbll = new bll.Attributebll();
DataTable dt1 = new DataTable();
dt1 = attrbll.GetCatDDlist(UserId.ToString());
s += "<option value=''>请选择</option>";
for (int i = 0; i < dt1.Rows.Count; i++)
{
s += "<option value='" + dt1.Rows[i][1].ToString() + "'>" + dt1.Rows[i][0].ToString() + "</option>";
}
return(s);
}
/// <summary>
/// 获取商品类别并构造下拉列表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string GetDDlist(string TypeNo)
{
string s = string.Empty;
DataTable dt = new DataTable();
bll.Attributebll attrbll = new bll.Attributebll();
dt = attrbll.GetTypeDDlist(userInfo.User.Id.ToString());
s += "<select id='ddlType' style='width:150px' onchange='ddl(this[selectedIndex].value)' >";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][1].ToString() == TypeNo)
{
s += "<option value='" + dt.Rows[i][1].ToString() + "' selected='selected' >" + dt.Rows[i][0].ToString() + "</option>";
}
else
{
s += "<option value='" + dt.Rows[i][1].ToString() + "'>" + dt.Rows[i][0].ToString() + "</option>";
}
}
s += "</select>";
return(s);
}
