/// <summary>
/// 找回秘密时，给用户发送验证码
/// </summary>
/// <returns></returns>
public string GetSms()
{
string ret = BaseController.Json(-1, "抱歉，当前用户设置的手机号码可能有误或网络繁忙，你可以重新发送短信！");
string MobilePhone = Request.Form["phone"];
//判断用户的手机号码是否已经注册过
if (IsUserName(MobilePhone))
{
bool ok = false;
string smsCaptcha = Common.CheckCode.GenerateNumber();
Session["Captcha"] = smsCaptcha;
string url = "http://" + Request.Url.Host + "/include/ajax.ashx?act=updateMobilePhone&v=" + Guid.NewGuid().ToString();
var sms = new SOSOshop.MSG.Sms();
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
object phone = db.ExecuteScalar("select OfficePhone from yxs_administrators where adminid=(select Editer from memberaccount a inner join memberinfo b on a.UID=b.UID where MobilePhone='" + MobilePhone + "')");
if (phone == null || phone.ToString().Trim() == "")
{
phone = "028-66321993";
}
string SmsMsg = "您的账户安全验证码为：" + smsCaptcha + "，请在页面填写。如非本人操作，请致电您的专属采购顾问" + phone;
string from = "系统";
string to = MobilePhone;
ok = SOSOshop.BLL.Sms.SendAndSaveDataBase(MobilePhone, SmsMsg, from, to);
if (ok)
{
ret = BaseController.Json(0, "ok");
}
}
return(ret);
}
/// <summary>
/// 取消操作
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool QuXiao(int id)
{
SOSOshop.Model.AdminInfo adminInfo = SOSOshop.BLL.AdministrorManager.Get();
string s = string.Format(@"declare @uid int,@Gift_ID int,@Gift_Number decimal,@Integral decimal
if exists(select * from MemberIntegralGiftExchange where [State]<>0 and [id]={0}) begin
update MemberIntegralGiftExchange set ontime=getdate(),Editer={1},[State]=0
where [State]<>0 and [id]={0}
select @uid = uid, @Gift_ID = Gift_ID, @Gift_Number = Gift_Number from MemberIntegralGiftExchange where [id]={0}
select @Integral = Integral * @Gift_Number from MemberIntegralGift where [id]=@Gift_ID
update MemberIntegralGift set Number = Number + @Gift_Number where [id]=@Gift_ID
update MemberIntegral set realityIntegral = realityIntegral + @Integral where [uid]=@uid
end
select @uid,@Integral", id, adminInfo == null ? 0 : adminInfo.AdminId);
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
DataSet ds = db.ExecuteDataSet(s);
bool ok = ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && !ds.Tables[0].Rows[0].IsNull(0);
if (ok)
{
int uid = int.Parse(ds.Tables[0].Rows[0][0].ToString());
decimal integral = decimal.Parse(ds.Tables[0].Rows[0][1].ToString());
SOSOshop.BLL.Integral.MemberIntegral bll2 = new SOSOshop.BLL.Integral.MemberIntegral();
bll2.PresentIntegral(uid, Convert.ToInt32(integral), "返还兑换礼品的积分", true);
}
return(ok);
}
/// <summary>
/// 取得会员应该执行的价格类型
/// </summary>
/// <returns></returns>
public static string GetPriceCategory()
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
string sql = "SELECT PriceCategory FROM dbo.memberinfo WHERE UID=" + GetUserId();
return((string)db.ExecuteScalarForCache(sql));
}
/// <summary>
/// 取网站配置信息
/// </summary>
/// <returns></returns>
public static WebSiteInfo GetNetSiteInfo()
{
//WebSiteInfo wsi = new WebSiteInfo();
string sql = @"SELECT TOP 1 [id]
,[websitetitle]
,[tel]
,[fax]
,[email]
,[metekey]
,[meteinfo]
,[websitename]
,[usersagreement]
,[websitedomain]
FROM [yxs_websetting]";
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
DataTable dt = db.ExecuteTableForCache(sql, DateTime.Now.AddDays(1));
IList <WebSiteInfo> list = dt.AsEnumerable().Select(x =>
new WebSiteInfo
{
NetName = x.Field <string>("websitename"),
Domain = System.Configuration.ConfigurationManager.AppSettings["CompanyDomainName"],
NetTitle = x.Field <string>("websitetitle"),
Phone = x.Field <string>("tel"),
Fax = x.Field <string>("fax"),
Email = x.Field <string>("email"),
Keys = x.Field <string>("metekey"),
NetInfo = x.Field <string>("meteinfo"),
NetProtocol = x.Field <string>("usersagreement")
}).ToList();
return(list[0]);
}
/// <summary>
/// 资讯列表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult list(string id = "100")
{
//记录总数
int recordCount = 0;
//页总数
int pageCount = 0;
//页大小
int pageSize = 12;
//当前页
int pageIndex = 1;
if (!string.IsNullOrEmpty(Request["pageindex"]))
{
pageIndex = int.Parse(Request["pageindex"]);
}
ViewBag.id = id;
var bll = new SOSOshop.BLL.Db();
DataTable key = bll.ExecuteTableForCache("SELECT Name,Description,MeteKey,MeteDescription FROM dbo.yxs_articlechannel where id=" + Library.Lang.Input.Filter(id));
if (key.Rows.Count > 0)
{
ViewBag.Name = key.Rows[0]["Name"];
ViewBag.MeteKey = key.Rows[0]["MeteKey"];
ViewBag.MeteDescription = key.Rows[0]["MeteDescription"];
}
string where = string.Format(" AND Channel LIKE('{0}%')", Library.Lang.Input.Filter(id));
DataTable dt = bll.GetListByPage("yxs_article", "id,Title,CreateTime", pageSize, pageIndex, " id desc ", where, out recordCount, out pageCount);
//定义页面
PagedList <DataRow> pl = new PagedList <DataRow>(dt.Select(), pageIndex, pageSize, recordCount);
return(View(pl));
}
/// <summary>
/// 获得用户单位信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static DataRow GetUserWorker(int id)
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
string sql = "select id,name from DrugsBase_Enterprise where id = " + id;
return(db.ExecuteTable(sql).Rows[0]);
}
public ActionResult Index(int id)
{
SOSOshop.BLL.Db bll = new SOSOshop.BLL.Db();
ViewBag._101资讯 = bll.ExecuteTableForCache("SELECT TOP 10 Id,Title,Channel FROM dbo.yxs_article WHERE State=1 AND Channel LIKE('102%')");
string sql = "SELECT Title,SubTitle,KeyWord,Content,Introduction, (SELECT TOP (1) Name FROM yxs_articlechannel WHERE Id = a.Channel) AS Channel FROM dbo.yxs_article a WHERE State=1 AND Id=" + id;
return(View(bll.ExecuteTableForCache(sql).Rows));
}
public ActionResult Index(int id)
{
SOSOshop.BLL.Db bll = new SOSOshop.BLL.Db();
ViewBag._101资讯 = bll.ExecuteTableForCache("SELECT TOP 10 id,Title FROM dbo.yxs_article WHERE Channel LIKE('100%') and id<>" + id + " ORDER BY id DESC");
string sql = "SELECT Title,SubTitle,KeyWord,Content,Introduction,CopyFrom,updateTime FROM dbo.yxs_article WHERE id=" + id;
return(View(bll.ExecuteTableForCache(sql).Rows));
}
/// <summary>
/// 更新商品浏览次
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string clickNum(int id)
{
if (Request.HttpMethod == "POST")
{
SOSOshop.BLL.Db bll = new SOSOshop.BLL.Db();
bll.ExecuteNonQuery("UPDATE Product SET Product_ClickNum=Product_ClickNum+1 WHERE Product_ID=" + id);
}
return("");
}
/// <summary>
/// 已处理操作
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool YiChuli(int id)
{
SOSOshop.Model.AdminInfo adminInfo = SOSOshop.BLL.AdministrorManager.Get();
string s = string.Format(@"update MemberIntegralGiftExchange set ontime=getdate(),Editer={1},[State]=2 where [State]<>0 and [id]={0}",
id, adminInfo == null ? 0 : adminInfo.AdminId);
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
return(0 < db.ExecuteNonQuery(s));
}
/// <summary>
/// 取热门搜索列表
/// </summary>
/// <returns></returns>
public static Dictionary <string, string> GetHotSearch()
{
string sql = "select top 5 name,linkad from yxs_topsearches where isshow=1 order by [sort]";
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
DataTable dt = db.ExecuteTableForCache(sql, DateTime.Now.AddHours(1));
Dictionary <string, string> dic = new Dictionary <string, string>();
dic = dt.AsEnumerable().ToDictionary(x => x.Field <string>("name"), x => x.Field <string>("linkad"));
return(dic);
}
/// <summary>
/// 取得基药分类
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public string fullPath(string obj)
{
var dt = new SOSOshop.BLL.Db().ExecuteTableForCache("SELECT id,name FROM dbo.Tag_PharmAttribute WHERE tag_id=69");
List <string> li = new List <string>();
foreach (var item in obj.Trim('/').Split('/'))
{
li.Add(dt.AsEnumerable().Where(x => x.Field <int>("id") == int.Parse(item)).Select(x => x.Field <string>("name")).First());
}
return(string.Join("/", li.ToArray()));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
string id = context.Request["pid"];
string cuprice = context.Request["cuprice"];
string discount = context.Request["discount"];
string btime = context.Request["btime"];
string etime = context.Request["etime"];
string maxsell = context.Request["maxsell"];
string minsell = context.Request["minsell"];
string otcminsell = context.Request["otcminsell"];
string canel = context.Request["canel"];
if (!string.IsNullOrEmpty(id))
{
try
{
//用户操作权限审核
if (SOSOshop.BLL.PowerPass.isPass("001030000"))
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
//设置促销
string sql = string.Format("update product set cuprice={0},discount={1},maxsell={2},begindate='{3}',enddate='{4}',otcminsell={6},minsell={7} where Product_ID={5}", cuprice, discount, maxsell, btime, etime, id, otcminsell, minsell);
//取消促销设置
if (!string.IsNullOrEmpty(canel))
{
sql = string.Format("update product set cuprice=0,discount=0,maxsell=0,minsell=0,otcminsell=0,begindate=null,enddate=null where Product_ID={0}", id);
}
int result = db.ExecuteNonQuery(sql);
AdminInfo adminModel = (AdminInfo)SOSOshop.BLL.AdministrorManager.Get();
SOSOshop.BLL.Logs.Log.LogAdminAdd(string.Format("设置了促销商品:[{0}][{1}]", id, new SOSOshop.BLL.Db().ExecuteScalar("SELECT Product_Name FROM dbo.Product WHERE Product_ID=" + id), string.IsNullOrEmpty(canel) ? "促销" : "取消促销"), adminModel.AdminId, adminModel.AdminName, 1);
//大表同步更新
// sql = "";
context.Response.Write("{\"state\":" + result + ",\"message\":\"设置完成\"}");
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"对不起！您没有操作权限。\"}");
}
}
catch (Exception x)
{
context.Response.Write("{\"state\":-1,\"message\":\"" + x.Message + "\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"操作错误！\"}");
}
}
public static string Get_Json(int value)
{
string js = "";
//查询数据库
try
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
StringBuilder json = new StringBuilder();
string ParentPath = "";
string sql = "SELECT ParentPath FROM Region WHERE (ParentPath <> '') GROUP BY ParentPath ORDER BY ParentPath";
DataTable dt = db.ExecuteTableForCache(sql);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
ParentPath += dr[0] + ":";
}
if (ParentPath != "")
{
ParentPath = ParentPath.Substring(0, ParentPath.Length - 1);
}
string[] Paths = ParentPath.Split(":".ToCharArray());
foreach (string Path in Paths)
{
sql = "select Id,Name,ParentPath from Region where ParentPath='" + Path + "' ORDER BY OrderID";
dt = db.ExecuteTableForCache(sql);
if (dt != null)
{
json.Append("'" + Path + "':{");
string option = "";
foreach (DataRow dr in dt.Rows)
{
option += dr["Id"].ToString() + ":'" + dr["Name"].ToString().Trim("\r\n '".ToCharArray()) + "',";
}
if (option != "")
{
json.Append(option.Substring(0, option.Length - 1) + "},");
}
}
}
}
js = json.ToString(); if (js != "")
{
js = js.Substring(0, js.Length - 1);
}
}
catch { }
return("{" + js + "}");
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string id = context.Request["pid"];
string stop = context.Request["stop"];
string sql = null;
if (!string.IsNullOrEmpty(id) && !string.IsNullOrEmpty(stop))
{
try
{
//用户操作权限审核
if (SOSOshop.BLL.PowerPass.isPass("001009003"))
{
int sp = int.Parse(stop);
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
if (sp == 1)
{
sql = "update product set Product_bShelves=1,Product_bStop=" + stop + " where Product_ID=" + id;//商品停用并下架
}
else
{
sql = "update product set Product_bStop=" + stop + " where Product_ID=" + id;//商品启用，不改变商品上下架状态
}
//context.Response.Write(sql);
int result = db.ExecuteNonQuery(sql);
//大表同步更新
//sql = "";
context.Response.Write("{\"state\":" + result + ",\"message\":\"已处理\"}");
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"对不起！您没有操作权限。\"}");
}
}
catch (Exception x)
{
context.Response.Write("{\"state\":-1,\"message\":\"" + x.Message + sql + "\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"操作错误！\"}");
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region ajax 上架、下架、删除
if (!string.IsNullOrEmpty(Request.QueryString["ajax"]))
{
if (SOSOshop.BLL.PowerPass.isPass("008011002"))
{
string id = Request.Form["id"];
string Shangjia = Request.Form["Shangjia"];
string Del = Request.Form["Del"];
string s = "";
if (!string.IsNullOrEmpty(Shangjia) && Shangjia == "1")
{
s = string.Format("update MemberIntegralGift set [State]=(case when State=1 then 2 when State=2 then 1 else State end) where [id]={0}", id);
}
else if (!string.IsNullOrEmpty(Del) && Del == "1")
{
s = string.Format("update MemberIntegralGift set [State]=0 where [id]={0}", id);
}
try
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
int ret = db.ExecuteNonQuery(s);
if (ret > 0)
{
Response.Write("{\"state\":1,\"message\":\"处理成功！\"}");
}
else
{
Response.Write("{\"state\":0,\"message\":\"处理失败！\"}");
}
}
catch (Exception x)
{
Response.Write("{\"state\":-2,\"message\":\"" + x.Message + "\"}");
}
}
else
{
Response.Write("{\"state\":-1,\"message\":\"对不起，您没有编辑权限，请联系管理员！\"}");
}
Response.End();
}
#endregion
if (!this.Page.IsPostBack)
{
SOSOshop.BLL.PromptInfo.Popedom("008011002");
GetList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region ajax 修改积分
if (!string.IsNullOrEmpty(Request.QueryString["ajax"]))
{
if (SOSOshop.BLL.PowerPass.isPass("008011001"))
{
string id = Request.Form["id"];
string integral = Request.Form["integral"];
string s = string.Format("update MemberIntegralTemplate set [integral]={0} where [id]={1}", integral, id);
try
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
int ret = db.ExecuteNonQuery(s);
if (ret > 0)
{
Response.Write("{\"state\":1,\"message\":\"更新成功！\"}");
}
else
{
Response.Write("{\"state\":0,\"message\":\"更新失败！\"}");
}
}
catch (Exception x)
{
Response.Write("{\"state\":-2,\"message\":\"" + x.Message + "\"}");
}
}
else
{
Response.Write("{\"state\":-1,\"message\":\"对不起，您没有编辑权限，请联系管理员！\"}");
}
Response.End();
}
#endregion
//修改积分倍数
if (!string.IsNullOrEmpty(Request.Form["multiple"]))
{
bllo.update(Request.Form["id"], int.Parse(Request.Form["multiple"]));
Response.End();
}
if (!this.Page.IsPostBack)
{
SOSOshop.BLL.PromptInfo.Popedom("008011001");
GetList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!SOSOshop.BLL.PowerPass.isPass("001009007"))
{
SOSOshop.BLL.PromptInfo.Popedom("001009001");
}
if (!IsPostBack)
{
ViewState["returnUrl"] = Request.UrlReferrer;
HyperLink1.NavigateUrl = Request.UrlReferrer + "";
bool edit = SOSOshop.BLL.PowerPass.isPass("001009004");
this.TextBox2.Enabled = edit;
this.TextBox3.Enabled = edit;
this.button2.Enabled = edit;
this.button3.Enabled = edit;
}
string sql = string.Format("select *,(select top 1 image from Goods_Image where Goods_ID=product.Goods_ID) as images from product where product_id={0}", Request["pid"]);
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
//Response.Write(sql);
//Response.End();
product = new Productinfo(db.ExecuteTable(sql).Rows[0]);
//商品信息
string sqlshop = string.Format("select *," +
"(select b.is_cl from product_online_v_1 as b where b.Product_ID= {0}) as is_cl," +//可拆零
"(select b.Price_01 from product_online_v_1 as b where b.Product_ID= {0}) as price_01," +
"(select b.Price_02 from product_online_v_1 as b where b.Product_ID= {0}) as price_02," +
"isnull((select b.minsell from product_online_v_1 as b where b.Product_ID= {0}),0) as minsell,Product_State," +
"case when(select [Stock] from [Product_Stock] as d where d.Product_ID={0}) is null then 0 else 1 end as stock " +
"from product where product_id={0}", Request["pid"]);
var dt = db.ExecuteTable(sqlshop);
shop = new ShopInfo(dt.Rows[0]);
if (!IsPostBack)
{
this.txtId.Value = shop.ID.ToString();
TextBox1.Text = shop.ProductName;
TextBox2.Text = shop.SellingPoint;
TextBox3.Text = shop.Advertisement;
DropDowndrug_sensitive1.SelectedValue = dt.Rows[0]["drug_sensitive"].ToString();
Label1.Text = string.Format("{0:f2}", shop.price_01);
Label2.Text = string.Format("{0:f2}", shop.price_02);
this.DropDownSellType.SelectedValue = shop.sellType.ToString();
}
}
/// <summary>
/// 取商品广告位里的商品名称
/// </summary>
/// <param name="pid">商品ID列表</param>
/// <param name="code">广告位编码</param>
/// <returns></returns>
protected string GetProductName(List <int> pid, string code)
{
if (pid.Count > 0)
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
DataTable dt = db.ExecuteTable("select Product_Name,product_id from product where product_id in(" + string.Join(",", pid) + ")");
List <string> pname = new List <string>();
dt.AsEnumerable().ToList().ForEach(x => pname.Add(string.Format("<span onmouseover=\"shows(this,{0},'{1}')\">{2}</span>", x.Field <int>("product_id"), code, x.Field <string>("product_name"))));
return(pname.Count == 0 ? "" : string.Join("、", pname));
}
else
{
return("");
}
}
/// <summary>
/// 取得商品标签
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static string Tag(DataRow dr)
{
return("");
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
StringBuilder sb = new StringBuilder();
//拆零
bool is_cl = (string)dr["is_cl"] == "是";
//控销
bool is_kong = (decimal)dr["price_03"] > 0;
//2012基药标签
bool is_Jy = ((string)dr["tag_ids"]).Contains(",66,");
//包含中标价、调入挂网价
bool is_Zb = !dr.IsNull("zbj") && decimal.Parse(dr["zbj"].ToString()) > 0;
bool is_Dr = !dr.IsNull("drj") && decimal.Parse(dr["drj"].ToString()) > 0;
if (is_cl || is_kong || is_Jy || is_Zb || is_Dr)
{
sb.Append(" <div class='detail_img_ico'>");
if (is_Jy)
{
sb.Append(" <span class=\"bkjy_ico bkjy_ico_1\">520</span>");
}
if (is_Zb)
{
sb.Append(" <span class=\"bkjy_ico bkjy_ico_2\">中标基</span>");
}
if (is_Dr)
{
sb.Append(" <span class=\"bkjy_ico bkjy_ico_3\">调入基</span>");
}
if (is_cl)
{
sb.Append(" <span class='bkcl_ico'>拆零</span>");
}
if (is_kong)
{
sb.Append(" <span class='kx_ico'>控</span>");
}
sb.Append("</div>");
}
return(sb.ToString());
}
/// <summary>
/// 重新计算是否有在出售的otc品种
/// </summary>
public static void InitProduct_otc()
{
SOSOshop.BLL.Db bll = new SOSOshop.BLL.Db();
DataSet ds1 = bll.ExecuteDataSet("select id from Tag_PharmAttribute AS tag where tag_id=71 order by id");
SOSOshop.BLL.DrugsBase.Tag_PharmAttribute ta = new SOSOshop.BLL.DrugsBase.Tag_PharmAttribute();
for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
{
int tagid = (int)ds1.Tables[0].Rows[i][0];
int count = ta.GetCount(tagid);
string sql = string.Format(@"IF EXISTS(SELECT * FROM Tag_PharmAttribute_Product_Count WHERE Tag_PharmAttribute_id={1})
UPDATE Tag_PharmAttribute_Product_Count SET Product_Count={0} WHERE Tag_PharmAttribute_id={1}
ELSE
INSERT Tag_PharmAttribute_Product_Count (Tag_PharmAttribute_id,Product_Count) VALUES({1},{0})", count, tagid);
bll.ExecuteNonQuery(sql);
}
}
/// <summary>
/// 获得授权单位用户列表
/// </summary>
/// <returns></returns>
public static DataTable GetUserWorkList()
{
try
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
DataTable dt = db.ExecuteTable("select case when Parents is null or parents='' then CONVERT(varchar,[ParentId]) else CONVERT(varchar,[ParentId])+','+parents end from memberinfo where uid=" + GetUserId());
if (dt != null)
{
string ids = dt.Rows[0][0].ToString();
string sql = "select id,name from DrugsBase_Enterprise where id in (" + ids + ") ";
return(db.ExecuteTable(sql));
}
}
catch
{
}
return(null);
}
public string page()
{
param = "&shopname=" + Request["shopname"];
param += "&changjia=" + Request["changjia"];
param += "&pihao=" + Request["pihao"];
param += "&Price=" + Request["Price"];
param += "&is_cl=" + Request["is_cl"];
param += "&bStock=" + Request["bStock"];
param += "&bShelves=" + Request["bShelves"];
param += "&bGoodsImage=" + Request["bGoodsImage"];
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
string sql = "select count(a.product_name) as c" + getFrom() + (where.Length > 1 ? " where 1=1 " + where + "" : "");
//Response.Write(sql);
int recordcount = (int)db.ExecuteTable(sql).Rows[0]["c"];
double cs = (int)recordcount / pagesize;
//页总数
pagecount = int.Parse(Math.Ceiling(cs).ToString());
System.Text.StringBuilder s = new System.Text.StringBuilder();
s.Append("共<span style='color: Red'>" + recordcount + "</span>条记录");
s.Append("<a href=\"?current=1" + param + "\">");
s.Append("<<");
s.Append("</a> ");
int j, i;
j = i = 0;
if (pageindex > 5)
{
i = pageindex - 5;
j = i;
}
for (; i < j + 9 && i <= pagecount; i++)
{
s.Append("<a href=\"?current=" + (i + 1) + param + "\">");
s.Append(i + 1);
s.Append("</a> ");
}
s.Append("<a href=\"?current=" + pagecount + param + "\">");
s.Append(">>");
s.Append("</a> ");
return(s.ToString());
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
int Product_ID = 0; int.TryParse(request("txtId"), out Product_ID);
string Product_Name = request("TextBox1");
string SellingPoint = request("TextBox2");
string Advertisement = request("TextBox3");
string sql = "update product set Product_Name=@Product_Name, Product_SellingPoint=@Product_SellingPoint, Product_Advertisement=@Product_Advertisement,drug_sensitive=@drug_sensitive,SellType=@SellType where Product_ID=@Product_ID";
try
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
DbCommand dbCommand = db._db.GetSqlStringCommand(sql);
db._db.AddInParameter(dbCommand, "Product_ID", DbType.Int32, Product_ID);
db._db.AddInParameter(dbCommand, "Product_Name", DbType.AnsiString, Product_Name);
db._db.AddInParameter(dbCommand, "Product_SellingPoint", DbType.AnsiString, SellingPoint);
db._db.AddInParameter(dbCommand, "Product_Advertisement", DbType.AnsiString, Advertisement);
db._db.AddInParameter(dbCommand, "drug_sensitive", DbType.Boolean, bool.Parse(DropDowndrug_sensitive1.SelectedValue));
db._db.AddInParameter(dbCommand, "SellType", DbType.Int32, int.Parse(DropDownSellType.SelectedValue));
int ret = db._db.ExecuteNonQuery(dbCommand);
if (ret > 0)
{
AdminInfo adminModel = (AdminInfo)SOSOshop.BLL.AdministrorManager.Get();
SOSOshop.BLL.Logs.Log.LogAdminAdd(string.Format("编辑商品:[{0}][{1}]", Product_ID, TextBox1.Text), adminModel.AdminId, adminModel.AdminName, 1);
this.ltlMsg.Text = "保存成功·<script>if(confirm('编辑成功！继续编辑请点击确定。')){location.href='product_edit.aspx?pid=" + Product_ID + "';}else{location.href='" + ViewState["returnUrl"] + "';}</script>";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
else
{
this.ltlMsg.Text = "保存失败";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
}
}
catch (Exception ex)
{
this.ltlMsg.Text = "保存失败" + "\r\n" + ex.ToString();
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionErr";
}
}
public void ProcessRequest(HttpContext context)
{
string id = context.Request["pid"];
string stop = context.Request["verify"];
string sql = null;
if (!string.IsNullOrEmpty(id) && !string.IsNullOrEmpty(stop))
{
try
{
//用户操作权限审核
if (SOSOshop.BLL.PowerPass.isPass("001009002"))
{
int sp = int.Parse(stop);
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
if (sp == 1)
{
sql = "update product set Product_bShelves=0,Product_bStop=0, shop_state=0 where Product_ID=" + id;//审核商品
}
//context.Response.Write(sql);
int result = db.ExecuteNonQuery(sql);
//大表同步更新
sql = "";
context.Response.Write("{\"state\":" + result + ",\"message\":\"已处理\"}");
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"对不起！您没有审核权限。\"}");
}
}
catch (Exception x)
{
context.Response.Write("{\"state\":-1,\"message\":\"" + x.Message + "\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"操作错误！\"}");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string bshelves = context.Request["bshelves"];
string state = context.Request["state"];
string pid = context.Request["pid"];
if (!string.IsNullOrEmpty(pid))
{
if (SOSOshop.BLL.PowerPass.isPass("001009004"))
{
string s = string.Format("update product set Product_State='{1}' where [Product_ID]={2}", bshelves, state, pid);
try
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
int ret = db.ExecuteNonQuery(s);
if (ret > 0)
{
AdminInfo adminModel = (AdminInfo)SOSOshop.BLL.AdministrorManager.Get();
SOSOshop.BLL.Logs.Log.LogAdminAdd(string.Format("{2}了商品:[{0}][{1}]", pid, new SOSOshop.BLL.Db().ExecuteScalar("SELECT Product_Name FROM dbo.Product WHERE Product_ID=" + pid), bshelves == "1" ? "上架" : "下架"), adminModel.AdminId, adminModel.AdminName, 1);
context.Response.Write("{\"state\":" + ret + ",\"message\":\"更新成功！\"}");
}
else
{
context.Response.Write("{\"state\":" + ret + ",\"message\":\"更新失败！\"}");
}
}
catch (Exception x)
{
context.Response.Write("{\"state\":-2,\"message\":\"" + x.Message + "\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"对不起，您没有编辑权限，请联系管理员！\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"未知错误！\"}");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string id = context.Request["pid"];
string shelves = context.Request["shelves"];
if (!string.IsNullOrEmpty(id) && !string.IsNullOrEmpty(shelves))
{
try
{
//用户操作权限审核
if (SOSOshop.BLL.PowerPass.isPass("001009005"))
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
string sql = string.Format("UPDATE product SET beactive='{0}' ,Product_bShelves='{1}' WHERE Product_ID={2}", shelves.Equals("1") ? "是" : "否", shelves, id);
//context.Response.Write(sql);
int result = db.ExecuteNonQuery(sql);
AdminInfo adminModel = (AdminInfo)SOSOshop.BLL.AdministrorManager.Get();
SOSOshop.BLL.Logs.Log.LogAdminAdd(string.Format("{2}了商品:[{0}][{1}]", id, new SOSOshop.BLL.Db().ExecuteScalar("SELECT Product_Name FROM dbo.Product WHERE Product_ID=" + id), shelves == "1" ? "上架" : "下架"), adminModel.AdminId, adminModel.AdminName, 1);
//大表同步更新
sql = "";
context.Response.Write("{\"state\":" + result + ",\"message\":\"已处理\"}");
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"对不起！您没有操作权限。\"}");
}
}
catch (Exception x)
{
context.Response.Write("{\"state\":-1,\"message\":\"" + x.Message + "\"}");
}
}
else
{
context.Response.Write("{\"state\":-1,\"message\":\"操作错误！\"}");
}
}
public void ProcessRequest(HttpContext context)
{
int UID = _101shop.v3.Controllers.BaseController.GetUserId();//账户ID
if (UID > 0)
{
//调用ERP:wldwwdzl往来单位文档资料的图片
string wldwwdid = context.Request.QueryString["wldwwdid"];
if (!string.IsNullOrEmpty(wldwwdid))
{
SOSOshop.BLL.Db bll = new SOSOshop.BLL.Db();
object Data = bll.ExecuteScalar("SELECT wldwwd_image FROM wldwwdzl WHERE wldwwdid='" + wldwwdid.Replace("'", "") + "'");
if (Data != null)
{
byte[] imageData = (byte[])Data;
//写入图片信息到输出流中
context.Response.OutputStream.Write(imageData, 78, imageData.Length - 78);
}
}
}
}
public void LogOnCheck()
{
//参数提交?act=ExistsUserName
if (Request["act"] != null && Request["act"] == "ExistsUserName" && Request["UserName"] != null)
{
string UserName = Request["UserName"];
Response.Write(IsUserName(UserName) ? 1 : 0);
}
//参数提交?act=ExistsEMail
if (Request["act"] != null && Request["act"] == "ExistsEMail" && Request["Email"] != null)
{
bool Exists = false;
string Email = Request["Email"];
if (!string.IsNullOrEmpty(Email))
{
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
DataTable dt = db.ExecuteTable(string.Format("select count(uid) from [memberaccount] where Email='{0}'", Email.Trim()));
Exists = (int)dt.Rows[0][0] > 0 ? true : false;
}
Response.Write(Exists ? 1 : 0);
}
//参数提交?act=ExistsCaptcha
if (Request["act"] != null && Request["act"] == "ExistsCaptcha" && Request["Captcha"] != null)
{
bool Exists = (Request.UserHostAddress.StartsWith("::") || Request.UserHostAddress.StartsWith("192.168") || Request.UserHostAddress.StartsWith("125.69.66"));//如果是局域网，或公司内部就不用验证验证验证码方便自动化测试;
string Captcha = Request["Captcha"];
if (!Exists && !string.IsNullOrEmpty(Captcha))
{
Exists = (Session["Captcha"] != null &&
Session["Captcha"].ToString().ToUpper() == Captcha.ToUpper());
}
Response.Write(Exists ? 1 : 0);
}
}
public static UserAddressModel GetUserAddress(int id)
{
try
{
string sql = "select [id],[uid],[username] ,[mobile],[phone] ,"
+ "(select CityName from [yxs_provinces] where id=province) as province,"
+ "(select CityName from [yxs_provinces] where id=city) as city,"
+ "(select CityName from [yxs_provinces] where id=Borough) as borough,"
+ "[address],[zip],[email],[constructionsigns],[consignestime],[stat] from memberreceaddress where id=" + id;
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
DataTable dt = db.ExecuteTable(sql);
UserAddressModel ua = new UserAddressModel();
if (dt != null)
{
ua.ID = (int)dt.Rows[0]["id"];
ua.Uid = (int)dt.Rows[0]["uid"];
ua.Username = dt.Rows[0]["username"].ToString();
ua.Mobile = dt.Rows[0]["mobile"].ToString();
ua.Phone = dt.Rows[0]["phone"].ToString();
ua.Province = dt.Rows[0]["province"].ToString();
ua.City = dt.Rows[0]["city"].ToString();
ua.Borough = dt.Rows[0]["borough"].ToString();
ua.Address = dt.Rows[0]["address"].ToString();
ua.Zip = dt.Rows[0]["zip"].ToString();
ua.Email = dt.Rows[0]["email"].ToString();
ua.Constructionsigns = dt.Rows[0]["constructionsigns"].ToString();
ua.Consignestime = dt.Rows[0]["consignestime"].ToString();
ua.stat = (Boolean)dt.Rows[0]["stat"];
}
return(ua);
}
catch
{
}
return(null);
}
