protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("property_list", "属性规格列表"))
{
PageReturnMsg = PageNoPowerMsg();
}
tid = RequestTool.RequestInt("tid", 133);
key = RequestTool.RequestSafeString("key");
tag = RequestTool.RequestSafeString("tag");
PageSize = RequestTool.getpageSize(25);
string where = "parentid = 0 and Type_id_ProPertyType = " + tid + "";
if (key != "")
{
where += " and (Name like lbsql{'%" + key + "%'} or Code like lbsql{'%" + key + "%'})";
}
if (tag != "")
{
if (tag == "none")
{
where += " and (Tag = '' or Tag is null)";
}
else
{
where += " and Tag = lbsql{'" + tag + "'}";
}
}
models = B_Lebi_ProPerty.GetList(where, "Sort desc", PageSize, page);
types = B_Lebi_Type.GetList("Class='ProPertyType'", "Sort desc");
int recordCount = B_Lebi_ProPerty.Counts(where);
PageString = Pager.GetPaginationString("?page={0}&tid=" + tid + "&tag=" + tag + "&key=" + key + "", page, PageSize, recordCount);
tmodel = B_Lebi_Type.GetModel(tid);
tags = B_Lebi_ProPerty_Tag.GetList("Type_id_ProPertyType = " + tid + " and Supplier_id = 0", "Sort desc");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Power("supplier_property", "属性规格"))
{
PageReturnMsg = PageNoPowerMsg();
}
Lebi_ProPerty check = B_Lebi_ProPerty.GetModel(pid);
if (check == null)
{
pid = B_Lebi_ProPerty.GetList("Supplier_id = " + CurrentSupplier.id + " and parentid = 0", "").FirstOrDefault().id;
}
PageSize = RequestTool.getpageSize(25);
pid = RequestTool.RequestInt("pid", 0);
key = RequestTool.RequestString("key");
pmodel = B_Lebi_ProPerty.GetModel(pid);
string where = "parentid=" + pid;
if (key != "")
{
where += " and (Name like lbsql{'%" + key + "%'} or Code like lbsql{'%" + key + "%'})";
}
models = B_Lebi_ProPerty.GetList(where, "Sort desc", PageSize, page);
int recordCount = B_Lebi_ProPerty.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationString("?page={0}&pid=" + pid + "&key=" + key + "", page, PageSize, recordCount);
tmodel = B_Lebi_Type.GetModel(pmodel.Type_id_ProPertyType);
}
public string TypeRadio(string class_, string name, int id, string ext, string lang)
{
string where = "Class='" + class_ + "'";
if (model.IsAllowHtml != 1)
{
where += " and id!=122";
}
if (model.IsCustom != 1)
{
where += " and id!=123";
}
List <Lebi_Type> models = B_Lebi_Type.GetList(where, "Sort desc");
string str = "";
foreach (Lebi_Type t in models)
{
string sel = "";
if (id == t.id)
{
sel = "checked";
}
if (!string.IsNullOrEmpty(RequestTool.GetConfigKey("SystemAdmin").Trim()))
{
str += "<label class=\"custom-control custom-radio m-r-20\"><input type=\"radio\" id=\"" + name + "" + t.id + "\" name=\"" + name + "\" value=\"" + t.id + "\" class=\"custom-control-input\" " + sel + " " + ext + "><span class=\"custom-control-label\">" + Language.Tag(t.Name, lang) + "</span></label>";
}
else
{
str += "<label><input type=\"radio\" name=\"" + name + "\" value=\"" + t.id + "\" " + sel + " " + ext + "/>" + Language.Tag(t.Name, lang) + "</label>";
}
}
return(str);
}
/// <summary>
/// 返回一组类型并排除授权之外的类型
/// </summary>
/// <param name="class_"></param>
/// <returns></returns>
public static List <Lebi_Type> GetTypes(string class_)
{
string where = "Class='" + class_ + "' and id in(131,133)";
List <Lebi_Type> models = B_Lebi_Type.GetList(where, "Sort desc");
return(models);
}
public string TypeRadio(string class_, string name, int id, string ext, string lang)
{
string where = "Class='" + class_ + "'";
if (model.IsAllowHtml != 1)
{
where += " and id!=122";
}
if (model.IsCustom != 1)
{
where += " and id!=123";
}
List <Lebi_Type> models = B_Lebi_Type.GetList(where, "Sort desc");
string str = "";
foreach (Lebi_Type t in models)
{
string sel = "";
if (id == t.id)
{
sel = "checked";
}
str += "<label><input type=\"radio\" name=\"" + name + "\" value=\"" + t.id + "\" " + sel + " " + ext + "/>" + Language.Tag(t.Name, lang) + "</label>";
}
return(str);
}
public string SearchTab()
{
string str = "";
List <Lebi_Type> ts = B_Lebi_Type.GetList("Class='CardType'", "id asc");
foreach (Lebi_Type t in ts)
{
string sel = "";
if (cardtype == t.id)
{
sel = "class=\"selected\"";
}
str += "<li " + sel + "><a href=\"?cardtype=" + t.id + "\"><span>" + Tag(t.Name) + "</span></a></li>";
}
return(str);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("type_list", "类型管理"))
{
PageReturnMsg = PageNoPowerMsg();
}
PageSize = RequestTool.getpageSize(50);
key = RequestTool.RequestString("key");
string where = "Class like '%Status%' and Class not like '%Upload%'";
if (key != "")
where += " and (Name like lbsql{'%" + key + "%'} or Class like lbsql{'%" + key + "%'})";
models = B_Lebi_Type.GetList(where, "Class asc,Sort desc", PageSize, page);
int recordCount = B_Lebi_Type.Counts(where);
PageString = Pager.GetPaginationString("?page={0}&&key=" + key, page, PageSize, recordCount);
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
if (CurrentUser.id == 0)
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
LoadTheme(themecode, siteid, languagecode, pcode);
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserAsk", "") + "\"><span>" + Tag("商品咨询") + "</span></a>";
key = Rstring("key");
dateFrom = Rstring("dateFrom");
dateTo = Rstring("dateTo");
DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom");
DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo");
status = RequestTool.RequestInt("status", 0);
types = B_Lebi_Type.GetList("Class='AskStatus'", "sort desc");
pageindex = RequestTool.RequestInt("page", 1);
where = "Parentid = 0 and TableName = 'Product_Ask' and User_id=" + CurrentUser.id + "";
if (key != "")
{
where += " and (Content like lbsql{'%" + key + "%'})";
}
if (dateFrom != "" && dateTo != "")
{
where += " and Time_Add>='" + FormatDate(lbsql_dateFrom) + "'and Time_Add<='" + FormatDate(lbsql_dateTo) + " 23:59:59'";
}
if (status > 0)
{
where += " and (Status = " + status + ")";
}
comments = B_Lebi_Comment.GetList(where, "id desc", PageSize, pageindex);
foreach (Lebi_Comment c in comments)
{
c.IsRead = 1;
B_Lebi_Comment.Update(c);
}
int recordCount = B_Lebi_Comment.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&key=" + key + "&status=" + status + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage);
NextPage = "?page=" + (pageindex + 1) + "&key=" + key + "&status=" + status + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("property_list", "属性规格列表"))
{
PageReturnMsg = PageNoPowerMsg();
}
PageSize = RequestTool.getpageSize(25);
lang = RequestTool.RequestString("lang");
key = RequestTool.RequestString("key");
string where = "1=1";
if (key != "")
{
where += " and Name like lbsql{'%" + key + "%'}";
}
models = B_Lebi_ProPerty_Tag.GetList(where, "Sort desc", PageSize, page);
int recordCount = B_Lebi_ProPerty_Tag.Counts(where);
PageString = Pager.GetPaginationString("?page={0}&key=" + key, page, PageSize, recordCount);
types = B_Lebi_Type.GetList("Class='ProPertyType'", "Sort desc");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Power("supplier_property", "属性规格"))
{
PageReturnMsg = PageNoPowerMsg();
}
PageSize = RequestTool.getpageSize(25);
lang = RequestTool.RequestString("lang");
key = RequestTool.RequestString("key");
string where = "Supplier_id = " + CurrentSupplier.id + "";
if (key != "")
{
where += " and Name like lbsql{'%" + key + "%'}";
}
models = B_Lebi_ProPerty_Tag.GetList(where, "Sort desc", PageSize, page);
int recordCount = B_Lebi_ProPerty_Tag.Counts(where);
PageString = Shop.Bussiness.Pager.GetPaginationString("?page={0}&key=" + key, page, PageSize, recordCount);
types = B_Lebi_Type.GetList("Class='ProPertyType' and id in(131,133)", "Sort desc");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("property_add", "添加属性规格") || !EX_Admin.Power("property_edit", "编辑属性规格"))
{
PageReturnMsg = PageNoPowerMsg();
}
PageSize = RequestTool.getpageSize(25);
pid = RequestTool.RequestInt("pid", 0);
key = RequestTool.RequestString("key");
pmodel = B_Lebi_ProPerty.GetModel(pid);
string where = "parentid=" + pid;
if (key != "")
{
where += " and (Name like lbsql{'%" + key + "%'} or Code like lbsql{'%" + key + "%'})";
}
models = B_Lebi_ProPerty.GetList(where, "Sort desc", PageSize, page);
int recordCount = B_Lebi_ProPerty.Counts(where);
PageString = Pager.GetPaginationString("?page={0}&pid=" + pid + "&key=" + key + "", page, PageSize, recordCount);
tmodel = B_Lebi_Type.GetModel(pmodel.Type_id_ProPertyType);
}
protected void Page_Load(object sender, EventArgs e)
{
string connectionString = ConfigurationManager.ConnectionStrings["constr"].ToString();
conn = new SqlConnection(connectionString);
conn.Open();
tables_ = conn.GetSchema(SqlClientMetaDataCollectionNames.Tables, new string[] { null, null, null, "BASE TABLE" });
DataTable cols_;
string col_name = "";
string col_defaultval = "";
string col_isnullable = "";
string col_char_length = "";
string col_type = "";
string col_numeric_length = "";
string col_numeric_scale = "";
string col_remark = "";
for (int i = 0; i < tables_.Rows.Count; i++)
{
string tablename = tables_.Rows[i]["TABLE_NAME"].ToString();
cols_ = GetCols(tablename);
Lebi_Table parentmodel = B_Lebi_Table.GetModel("name='" + tablename + "' and parentid=0");
if (parentmodel == null)
{
parentmodel = new Lebi_Table();
parentmodel.name = tablename;
parentmodel.remark = "";
B_Lebi_Table.Add(parentmodel);
parentmodel.id = B_Lebi_Table.GetMaxId();
}
for (int j = 0; j < cols_.Rows.Count; j++)
{
col_name = cols_.Rows[j]["COLUMN_NAME"].ToString();
col_defaultval = cols_.Rows[j]["COLUMN_DEFAULT"].ToString();
col_isnullable = cols_.Rows[j]["IS_NULLABLE"].ToString();
col_char_length = cols_.Rows[j]["CHARACTER_MAXIMUM_LENGTH"].ToString();
col_type = cols_.Rows[j]["DATA_TYPE"].ToString();
col_numeric_length = cols_.Rows[j]["NUMERIC_PRECISION"].ToString();
col_numeric_scale = cols_.Rows[j]["NUMERIC_SCALE"].ToString();
col_remark = "";
if (col_name.Contains("Type_id_"))
{
string des = "";
List <Lebi_Type> ts = B_Lebi_Type.GetList("Class='" + col_name.Replace("Type_id_", "") + "'", "");
foreach (Lebi_Type ty in ts)
{
if (des == "")
{
des = ty.id + ty.Name;
}
else
{
des += "," + ty.id + ty.Name;
}
}
col_remark = des;
}
Lebi_Table model = B_Lebi_Table.GetModel("name='" + col_name + "' and parentid=" + parentmodel.id);
if (model == null)
{
model = new Lebi_Table();
}
model.name = col_name;
model.type = col_type;
model.remark = col_remark;
model.defaultval = col_defaultval;
model.isnullable = col_isnullable == "YES" ? 1 : 0;
model.isidentity = col_name == "id" ? 1 : 0;
model.ispk = col_name == "id" ? 1 : 0;
try
{
model.char_length = Convert.ToInt32(col_char_length);
}
catch
{
}
try
{
model.numeric_scale = Convert.ToInt32(col_numeric_scale);
}
catch
{
}
try
{
model.numeric_length = Convert.ToInt32(col_numeric_length);
}
catch
{
}
model.parentid = parentmodel.id;
model.parentname = parentmodel.name;
if (model.id == 0)
{
B_Lebi_Table.Add(model);
}
else
{
B_Lebi_Table.Update(model);
}
}
}
//JavaScriptSerializer jss = new JavaScriptSerializer();
//string json = jss.Serialize(tables);
//Response.Write(json);
Response.Write("OK");
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
if (CurrentUser.id == 0)
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
LoadTheme(themecode, siteid, languagecode, pcode);
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a href=\"" + URL("P_UserComment", "") + "\"><span>" + Tag("商品评价") + "</span></a>";
//key={0}&type={1}&status={2}&dateFrom={3}&dateTo={4}
key = Rstring("key");
type = Rint("type");
status = Rint("status");
dateFrom = Rstring("dateFrom");
dateTo = Rstring("dateTo");
DateTime lbsql_dateFrom = RequestTool.RequestDate("dateFrom");
DateTime lbsql_dateTo = RequestTool.RequestDate("dateTo");
pageindex = RequestTool.RequestInt("page", 1);
types = B_Lebi_Type.GetList("Class='CommentStatus'", "sort desc");
if (type == 0)
{
where = "Parentid = 0 and TableName = 'Product' and User_id=" + CurrentUser.id + "";
if (key != "")
{
where += " and (Content like lbsql{'%" + key + "%'})";
}
if (dateFrom != "" && dateTo != "")
{
where += " and (datediff(d,Time_Add,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Add,'" + FormatDate(lbsql_dateTo) + "')>=0)";
}
if (status > 0)
{
where += " and (Status = " + status + ")";
}
comments = B_Lebi_Comment.GetList(where, "id desc", PageSize, pageindex);
foreach (Shop.Model.Lebi_Comment c in comments)
{
c.IsRead = 1;
B_Lebi_Comment.Update(c);
}
int recordCount = B_Lebi_Comment.Counts(where);
//string url = URL("P_UserComment", key + "," + type + "," + status + "," + dateFrom + "," + dateTo + ",{0}");
//PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb(url, page, PageSize, recordCount, CurrentLanguage);
PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&key=" + key + "&type=" + type + "&status=" + status + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage);
}
else
{
//待评价商品
where = "IsCommented = 0 and User_id=" + CurrentUser.id + " and id in(select id from [Lebi_Order_Product] where Order_id in(select id from [Lebi_Order] where User_id=" + CurrentUser.id + " and IsReceived = 1))";
if (key != "")
{
where += " and (Product_Name like lbsql{'%" + key + "%'})";
}
if (dateFrom != "" && dateTo != "")
{
where += " and (datediff(d,Time_Add,'" + FormatDate(lbsql_dateFrom) + "')<=0 and datediff(d,Time_Add,'" + FormatDate(lbsql_dateTo) + "')>=0)";
}
order_products = B_Lebi_Order_Product.GetList(where, "id desc", PageSize, pageindex);
int recordCount = B_Lebi_Order_Product.Counts(where);
string url = URL("P_UserComment", key + "," + type + "," + status + "," + dateFrom + "," + dateTo + ",{0}");
PageString = Shop.Bussiness.Pager.GetPaginationStringForWeb("?page={0}&key=" + key + "&type=" + type + "&status=" + status + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "", pageindex, PageSize, recordCount, CurrentLanguage);
}
NextPage = "?page=" + (pageindex + 1) + "&key=" + key + "&type=" + type + "&status=" + status + "&dateFrom=" + dateFrom + "&dateTo=" + dateTo + "";
}
