public int of_SetMySysSet(string as_type, string as_item, string as_value)
{
MyConfig.DbName = "config.db";
int li_row = 0;
string ls_sql = "select count(*) from mysysset where itemtype='" + as_type + "' and itemname='" + as_item + "'";
li_row = MyConfig.ExecuteScalarNum(ls_sql);
n_create_sql lnv_sql = new n_create_sql("mysysset", MyConfig.DbName);
lnv_sql.of_AddCol("itemtype", as_type);
lnv_sql.of_AddCol("itemname", as_item);
lnv_sql.of_AddCol("itemvalue", as_value);
int li_rc = 0;
if (li_row <= 0)
{
li_rc = lnv_sql.of_execute();
}
if (li_row > 0)
{
li_rc = lnv_sql.of_execute("itemtype=@itemtype and itemname=@itemname", "@itemtype=" + as_type, "@itemname=" + as_item);
}
return(li_rc);
}
/// <summary>
/// 上传同步新增客户数据
/// </summary>
private void of_SyncAddCustomerData()
{
SysVisitor.CreateServerDB();
while (true)
{
System.Threading.Thread.Sleep(5000);
string ls_sql_update = "select cus_code from customer where cus_code like 'tmp%'";
DataTable ldt_update = new DataTable();
ldt_update = SqliteHelper.ExecuteDataTable(ls_sql_update);
if (ldt_update == null)
continue;
if (ldt_update.Rows.Count <= 0)
continue;
for (int i = 0; i < ldt_update.Rows.Count; i++)
{
string ls_sql_items = "select * from customer where cus_code='" + ldt_update.Rows[i]["cus_code"] + "'";
DataTable ldt_items = new DataTable();
ldt_items = SqliteHelper.ExecuteDataTable(ls_sql_items);
string ls_sql_values = "";
ls_sql_values += "'" + ldt_items.Rows[0]["cus_code"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["cus_name"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["customercreatetime"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["QQNo"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["Phone"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["address"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["linkman"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["trafficeAddr"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["cus_prov"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["Cus_City"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["mobile"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["modifydate"] + "',";
ls_sql_values += "'" + ldt_items.Rows[0]["e_mail"] + "'";
//DataTable ldt_tb = SqlHelper.of_downBasedata("cus_code,fax,cus_name,customercreatetime,QQNo,Phone,address,linkman,trafficeAddr,cus_prov,Cus_City,mobile,modifydate,e_mail", "synccustomer", ls_sql_values);
string json = Json.DataTableToJson(ldt_items);
DataTable ldt_rt = SqlHelper.of_downBasedata("", "synccustomer", "", json);
string json_rt = JsonHelper.DatatableToJson(ldt_rt);
if (ldt_rt.Rows.Count > 0)
{
string ls_sql_item = "select count(*) from customer where cus_code='" + ldt_rt.Rows[0]["cus_code"].ToString().Trim() + "'";
int row = 0;
row = SqliteHelper.ExecuteNum(ls_sql_item);
if (row <= 0)
{
//更新本地数据
n_create_sql lnv_sql = new n_create_sql();
lnv_sql.of_SetTable("customer");
lnv_sql.of_AddCol("cus_code", ldt_rt.Rows[0]["cus_code"].ToString().Trim());
lnv_sql.of_execute("cus_code='" + ldt_items.Rows[0]["cus_code"] + "'");
n_create_sql lnv_sql_getmain = new n_create_sql();
lnv_sql_getmain.of_SetTable("getmain");
lnv_sql_getmain.of_AddCol("cus_code", ldt_rt.Rows[0]["cus_code"].ToString().Trim());
lnv_sql_getmain.of_execute("cus_code='" + ldt_items.Rows[0]["cus_code"] + "'");
n_create_sql lnv_sql_getdetail = new n_create_sql();
lnv_sql_getdetail.of_SetTable("getdetail");
lnv_sql_getdetail.of_AddCol("cus_code", ldt_rt.Rows[0]["cus_code"].ToString().Trim());
lnv_sql_getdetail.of_execute("cus_code='" + ldt_items.Rows[0]["cus_code"] + "'");
//更新服务器数据
baseclass.n_create_sql lnv_sql_update = new baseclass.n_create_sql("customer");
lnv_sql_update.of_AddCol("customercreatetime", ldt_items.Rows[0]["customercreatetime"].ToString());
lnv_sql_update.of_AddCol("QQNo", ldt_items.Rows[0]["QQNo"].ToString());
lnv_sql_update.of_AddCol("Phone", ldt_items.Rows[0]["Phone"].ToString());
lnv_sql_update.of_AddCol("address", ldt_items.Rows[0]["address"].ToString());
lnv_sql_update.of_AddCol("linkman", ldt_items.Rows[0]["linkman"].ToString());
lnv_sql_update.of_AddCol("Cus_City", ldt_items.Rows[0]["Cus_City"].ToString());
lnv_sql_update.of_AddCol("mobile", ldt_items.Rows[0]["mobile"].ToString());
lnv_sql_update.of_AddCol("trafficeAddr", ldt_items.Rows[0]["trafficeAddr"].ToString());
lnv_sql_update.of_AddCol("modifydate", DateTime.Now.ToString());
lnv_sql_update.of_AddCol("e_mail", ldt_items.Rows[0]["e_mail"].ToString());
lnv_sql_update.of_execute("cus_code=@cus_code=",
"@cus_code=" + ldt_rt.Rows[0]["cus_code"].ToString().Trim());
}
}
}
System.Threading.Thread.Sleep(5000);
}
}
public static String MainReply(String as_RequestXML)
{
try
{
GyShop_Page.SetSession();
XmlDocument doc = new XmlDocument();
doc.LoadXml(as_RequestXML);
XmlNodeList list = doc.GetElementsByTagName("xml");
XmlNode xn = list[0];
Core.SysVisitor.Current.WeixinID = xn.SelectSingleNode("//ToUserName").InnerText.Trim();
Core.SysVisitor.Current.UserWeixinID = xn.SelectSingleNode("//FromUserName").InnerText.Trim();
string ls_MsgType = xn.SelectSingleNode("//MsgType").InnerText;
//接到信息类型
switch (ls_MsgType.ToLower())
{
case "event": //点击
#region event事件
String ls_Event = xn.SelectSingleNode("//Event").InnerText;
#region 关注与取消关注
if (ls_Event.ToLower() == "subscribe") //订阅
{
try
{
string ls_name = SysVisitor.Current.Get_User(Core.SysVisitor.Current.UserWeixinID);
if (!string.IsNullOrEmpty(ls_name))
{
string ls_wingroup_wx = "", ls_customer = "";
ls_wingroup_wx = SqlHelper.ExecuteScalar("select isnull(openid,'') from wingroup_wx where openid=@openid",
"@openid=" + Core.SysVisitor.Current.UserWeixinID);
ls_customer = SqlHelper.ExecuteScalar("select isnull(weixinid,'') from customer where weixinid=@openid",
"@openid=" + Core.SysVisitor.Current.UserWeixinID);
string ls_haveerp = "Y";
if (ls_customer == "")
{
ls_haveerp = "N";
}
if (ls_name.Length > 30)
{
ls_name = ls_name.Substring(0, 30);
}
n_create_sql lnv_sql = new n_create_sql();
lnv_sql.of_SetTable("wingroup_wx");
lnv_sql.of_AddCol("wxname", ls_name);
lnv_sql.of_AddCol("haveok", "Y");
lnv_sql.of_AddCol("insdate", DateTime.Now.ToString());
lnv_sql.of_AddCol("haveerp", ls_haveerp);
if (ls_wingroup_wx == "")
{
lnv_sql.of_AddCol("openid", Core.SysVisitor.Current.UserWeixinID);
lnv_sql.of_execute();
}
else
{
lnv_sql.of_execute("openid=@openid", "@openid=" + Core.SysVisitor.Current.UserWeixinID);
}
}
}
catch { }
return(SubscribeReply());
}
if (ls_Event.ToLower() == "unsubscribe") //取消订阅
{
string ls_wingroup_wx = "", ls_customer = "";;
ls_wingroup_wx = SqlHelper.ExecuteScalar("select isnull(openid,'') from wingroup_wx where openid=@openid",
"@openid=" + Core.SysVisitor.Current.UserWeixinID);
ls_customer = SqlHelper.ExecuteScalar("select isnull(weixinid,'') from customer where weixinid=@openid",
"@openid=" + Core.SysVisitor.Current.UserWeixinID);
string ls_haveerp = "Y";
if (ls_customer == "")
{
ls_haveerp = "N";
}
n_create_sql lnv_sql = new n_create_sql();
lnv_sql.of_SetTable("wingroup_wx");
lnv_sql.of_AddCol("haveok", "N");
lnv_sql.of_AddCol("deldate", DateTime.Now.ToString());
lnv_sql.of_AddCol("haveerp", ls_haveerp);
if (ls_wingroup_wx == "")
{
lnv_sql.of_AddCol("openid", Core.SysVisitor.Current.UserWeixinID);
lnv_sql.of_execute();
}
else
{
lnv_sql.of_execute("openid=@openid", "@openid=" + Core.SysVisitor.Current.UserWeixinID);
}
return("");
}
#endregion
else if (ls_Event.ToLower() == "click") //菜单点击
{
string ls_EventKey = xn.SelectSingleNode("//EventKey").InnerText;
switch (ls_EventKey.ToLower())
{
case "subcom": return(SubcomReply()); //命令列表
case "ordercar": return(OrderCarReply()); //在线订货
case "getmain": return(GetMainReply()); //订单查看
case "outone": return(OutOneReply()); //发货单查看
case "backmoney": return(BackMoneyReply()); //汇款单查看
case "accbook": return(AccBookReply()); //对账单查看
case "default": return(ShowDefault()); //显示首页
}
}
else if (ls_Event.ToLower() == "view") //菜单点击(url类型)
{
if (!UserInfo.SureUserWinxin(SysVisitor.Current.UserWeixinID))
{
return(NeedBindWeixin());
}
string ls_EventKey = xn.SelectSingleNode("//EventKey").InnerText;
switch (ls_EventKey.ToLower())
{
case "": return("");
}
}
else if (ls_Event.ToUpper() == "TEMPLATESENDJOBFINISH") //模板消息发送
{
string ls_EventKey = xn.SelectSingleNode("//Status").InnerText;
string ls_openID = xn.SelectSingleNode("//FromUserName").InnerText;
switch (ls_EventKey.ToLower())
{
case "success": Tools.WriteLog("Log", "模板消息推送", "成功！" + ls_openID); break; //成功送达
case "failed:user block": Tools.WriteLog("Log", "模板消息推送", "用户拒收！" + ls_openID); break; //用户设置了拒收
case "failed: system failed": Tools.WriteLog("Log", "模板消息推送", "用户拒收！" + ls_openID); break; //其他原因失败
}
}
return(ErrXML());
#endregion
case "text": //文字
return(TextReply(xn.SelectSingleNode("//Content").InnerText));
case "image": //图片
return(ErrXML());
case "voice": //语音
return(ErrXML());
case "video": //视频
return(ErrXML());
case "location": //地理位置
return(ErrXML());
case "link": //链接
return(ErrXML());
default:
return(ErrXML());
}
}
catch (Exception Ex)
{
Core.Tools.WriteLog("Err", "MainReply", Ex.Message);
return(ErrXML());
}
}
/// <summary>
/// 滑动特性
/// </summary>
public bool SlideFeature(string as_data)
{
if (string.IsNullOrEmpty(as_data))
{
return(false);
}
string[] _datalist = as_data.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
if (_datalist.Length < 10)
{
return(false);
}
//__array二维数组共两列 第一列为x轴坐标值 第二列为时间
long[,] __array = new long[_datalist.Length, 2];
#region 获取__array
int row = 0;
foreach (string str in _datalist)
{
string[] strlist = str.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
if (strlist.Length != 2)
{
return(false);
}
long __coor = 0, __date = 0;
try { __coor = long.Parse(strlist[0]); __date = long.Parse(strlist[1]); }
catch { return(false); }
for (int i = 0; i < 2; i++)
{
if (i == 0)
{
__array[row, i] = __coor;
}
if (i == 1)
{
__array[row, i] = __date;
}
}
row++;
}
#endregion
#region 计算速度 加速度 以及他们的标准差
//速度 像素/每秒
double[] __v = new double[_datalist.Length - 1];
//加速度 像素/每2次方秒
double[] __a = new double[_datalist.Length - 1];
//总时间
int __totaldate = 0;
for (int i = 0; i < __v.Length; i++)
{
//时间差
int __timeSpan = 0;
if (__array[i + 1, 1] - __array[i, 1] == 0)
{
__timeSpan = 1;
}
else
{
__timeSpan = (GetTime(__array[i + 1, 1].ToString()) - GetTime(__array[i, 1].ToString())).Milliseconds;
}
__v[i] = (double)1000 * Math.Abs(__array[i + 1, 0] - __array[i, 0]) / __timeSpan;//有可能移过再一回来 这里只取正值
__a[i] = (double)1000 * __v[i] / __timeSpan;
__totaldate += __timeSpan;
}
//速度的计算公式：v=S/t
//加速度计算公式：a=Δv/Δt
//分析速度与加速度
//平均速度
double __mv = 0;
double __sumv = 0;
double __s2v = 0; //速度方差
double __o2v = 0; //速度标准差
foreach (double a in __v)
{
__sumv += a;
}
__mv = __sumv / __v.Length;
__sumv = 0;
for (int i = 0; i < __v.Length; i++)
{
__sumv += Math.Pow(__v[i] - __mv, 2);
}
__s2v = __sumv / __v.Length;
__o2v = Math.Sqrt(__s2v);
//平均加速度
double __ma = 0;
double __suma = 0;
double __s2a = 0; //加速度方差
double __o2a = 0; //加速度标准差
foreach (double a in __a)
{
__suma += a;
}
__ma = __suma / __a.Length;
__suma = 0;
for (int i = 0; i < __a.Length; i++)
{
__suma += Math.Pow(__a[i] - __ma, 2);
}
__s2a = __suma / __v.Length;
__o2a = Math.Sqrt(__s2a);
double threeEqual = __a.Length / 3;
//将加速度数组分成三等分 求每一份的加速度
double __ma1 = 0, __ma2 = 0, __ma3 = 0;
for (int i = 0; i < __a.Length; i++)
{
if (i > threeEqual * 2)
{
__ma3 += __a[i];
}
else if (i > threeEqual && i < threeEqual * 2)
{
__ma2 += __a[i];
}
else
{
__ma1 += __a[i];
}
}
__ma1 = __ma1 / threeEqual;
__ma2 = __ma2 / threeEqual;
__ma3 = __ma3 / threeEqual;
//将速度数组分成三等分 求每一份的速度
threeEqual = __v.Length / 3;
double __mv1 = 0, __mv2 = 0, __mv3 = 0;
for (int i = 0; i < __v.Length; i++)
{
if (i > threeEqual * 2)
{
__mv3 += __v[i];
}
else if (i > threeEqual && i < threeEqual * 2)
{
__mv2 += __v[i];
}
else
{
__mv1 += __v[i];
}
}
__mv1 = __mv1 / threeEqual;
__mv2 = __mv2 / threeEqual;
__mv3 = __mv3 / threeEqual;
#endregion
//return true;
//将采样结果收集到数据库
CreateTable();
n_create_sql nsql = new n_create_sql("data");
nsql.of_AddCol("sumtime", __totaldate);
nsql.of_AddCol("abscissa", HttpContext.Current.Request["point"]);
nsql.of_AddCol("total", _datalist.Length);
nsql.of_AddCol("meanv", __mv.ToString("0.0000000000"));
nsql.of_AddCol("meanv1", __mv1.ToString("0.0000000000"));
nsql.of_AddCol("meanv2", __mv2.ToString("0.0000000000"));
nsql.of_AddCol("meanv3", __mv3.ToString("0.0000000000"));
nsql.of_AddCol("meana", __ma.ToString("0.0000000000"));
nsql.of_AddCol("meana1", __ma1.ToString("0.0000000000"));
nsql.of_AddCol("meana2", __ma2.ToString("0.0000000000"));
nsql.of_AddCol("meana3", __ma3.ToString("0.0000000000"));
nsql.of_AddCol("standardv", __o2v.ToString("0.0000000000"));
nsql.of_AddCol("standarda", __o2a.ToString("0.0000000000"));
nsql.of_execute();
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
Encoding gb2312 = Encoding.GetEncoding("gb2312");
Response.ContentEncoding = gb2312;
#region 处理Post请求
if (Request.RequestType == "POST")
{
GyShop_Page.SetSession();
string Edit = Request.Form["Edit"].ToString();
string scr = Request.Form["imgscr"].ToString();//缩略图路径
string user = Request.Form["username"].ToString();
string passwd = Request.Form["password"].ToString();
string goods_no = Request.Form["goods_no"].ToString();
string text = Server.UrlDecode(Request.Form["text"].ToString());
text = HttpUtility.UrlDecode(text, Encoding.GetEncoding("UTF-8"));
string str = SureSaleInfo(user, passwd, as_Code);//SaleInfo.SureSaleInfo(user, passwd);
#region 保存产品图文详情
if (str == "OK" && Edit == "false" || Edit == "true")
{
int count = 0;
count = SqlHelper.ExecuteScalarNum("select count(*) from Goodsno_picture where Goo_code=@Goo_code", "@Goo_code=" + goods_no);
n_create_sql lnv_sql = new n_create_sql();
lnv_sql.of_SetTable("Goodsno_picture");
if (count <= 0)
{
lnv_sql.of_AddCol("Goo_code", goods_no);
}
lnv_sql.of_AddCol("Memo", text);
lnv_sql.of_AddCol("Human", user);
lnv_sql.of_AddCol("Insdate", DateTime.Now.ToString());
lnv_sql.of_AddCol("Same_code", "");
if (scr != "")
{
lnv_sql.of_AddCol("ThumbnaiIimg", scr);
}
int li_count = 0;
if (count <= 0)
{
li_count = lnv_sql.of_execute();//insert
}
else
{
li_count = lnv_sql.of_execute("Goo_code=@Goo_code", "@Goo_code=" + goods_no);//update
}
if (li_count > 0)
{
Response.Write("OK");
}
else
{
Response.Write("Error");
}
return;
}
#endregion
if (str == "OK" && Edit == "DefaulePictrueAdd")//增加首页轮播图
{
string strSql = "insert into mysysset(itemType,itemName,itemvalue,memo) values('微信商城焦点图',@itemName,@itemvalue,@memo)";
GysoftParameter[] Pa = { new GysoftParameter("@itemName", goods_no), //title
new GysoftParameter("@itemvalue", scr), //Pictrue
new GysoftParameter("@memo", text) }; //href
int li_Rel = 0;
li_Rel = SqlHelper.ExecuteNonQuery(strSql, Pa);
if (li_Rel > 0)
{
Response.Write("OK");
}
else
{
Response.Write("Error;可能标题重复");
}
return;
}
if (str == "OK" && Edit == "DefaulePictrueDel")//删除首页轮播图
{
string StrSql = "DELETE from mysysset WHERE itemType='微信商城焦点图' AND itemvalue=@itemvalue";
GysoftParameter[] Pa = { new GysoftParameter("@itemvalue", scr) };
int li_Rel = SqlHelper.ExecuteNonQuery(StrSql, Pa);
if (li_Rel > 0)
{
Response.Write("OK");
}
else
{
Response.Write("Error");
}
return;
}
else
{
str = HttpUtility.UrlDecode(str, Encoding.GetEncoding("UTF-8"));
Response.Write(str);
return;
}
}
#endregion
#region 处理Get请求
GyShop_Page.SetSession();
url = HttpContext.Current.Request.Url.Query;
string username = Request["username"];
string password = Request["password"];
string code1 = Request["code"];
string askey = Request["askey"];
string ls_Rel = "Error";
if (Request["askey"] == null)
{
if (url == "" || Request["username"] == null || Request["password"] == null)
{
Response.Write("Error");
return;
}
ls_Rel = SureSaleInfo(username, password, code1);//SaleInfo.SureSaleInfo(username, password);
if (ls_Rel == "OK" && askey == null)
{
string ls_isdebug = ConfigurationManager.AppSettings["debug"].ToString();
if (ls_isdebug == "Y")
{
Response.Write("软件正在维护中，请稍后再试");
return;
}
Response.Write("OK");
return;
}
else
{
Response.Write(ls_Rel);
}
}
else if (askey != null)
{
try
{
askey = baseclass.DES.of_DecryStrVc(askey, Key);
}
catch
{
Response.Write("参数不能被识别");
return;
}
askey = HttpUtility.UrlDecode(askey, Encoding.GetEncoding("UTF-8"));
if (askey == "menu")//拉取商品种类列表
{
string sql = "Select typeNo,typeName From goodtype Where isWeb='Y' And isnull(visible,'Y')='Y' order by seq";
DataTable dt = SqlHelper.ExecuteDataTable(sql);
string str = Json.DataTableToJson(dt);
Response.Write(str);
return;
}
if (askey == "DefaultPicture")//拉取首页图片
{
string strSql = "select itemName,itemvalue,memo from mysysset where itemType='微信商城焦点图' order by itemName desc";
DataTable ldt_PPTBox = SqlHelper.ExecuteDataTable(strSql);
string str = Json.DataTableToJson(ldt_PPTBox);
Response.Write(str);
return;
}
else
{
string[] str = askey.Split('|');
#region 拉取产品信息列表
if (str.Length == 3)
{
string row = str[0].Trim();
string menu = str[1].Trim();
string name = str[2].Trim();
int li_PageIndex = 1;
string ls_sql = @"select goodsno.goo_name,goodsno.goo_code,goodsno.goo_no
from goodsno,goodmate,goodtype
where 1=1
and goo_type=typeno and goo_mate*=matecode and goodsno.Goodfunc in ('C','X')
and goodtype.isweb='Y' and goodmate.isweb='Y' and goodsno.isweb='Y'";
n_findby_dw lnv_sql = new n_findby_dw();
lnv_sql.of_setSQL(ls_sql);
lnv_sql.of_SetOr("goo_no", "goodsno.goo_no", "like", name);
lnv_sql.of_SetOr("goo_no", "goodsno.goo_name", "like", name);
lnv_sql.of_SetCol("goo_type", "goodsno.goo_type", "=", menu);
int count = 0;
DataTable ldt_Goods = new DataTable();
ldt_Goods = lnv_sql.Of_GetPageDataTable("goodsno.goo_code", Convert.ToInt32(row), li_PageIndex, ref count);
string str_dt = Json.DataTableToJson(ldt_Goods);
Response.Write(str_dt);
return;
}
#endregion
#region 为经销商微信生成初始密码，获取初始密码
if (str.Length == 4)
{
string generate = str[0].Trim();
string value = str[1].Trim();
string user = str[2].Trim();
string passwd = str[3].Trim();
string code = as_Code;
ls_Rel = SureSaleInfo(user, passwd, code);
if (ls_Rel == "OK")
{
return; //此接口不再使用
if (generate == "generate" && value == "set") //校验值set为生成密码操作 get为获取密码操作
{
string ls_sql = "select count(*) WeixinPwd from customer where WeixinPwd is null";
string ls_Temp = SqlHelper.ExecuteScalar(ls_sql);
int ls_count = 0;
try
{ ls_count = Convert.ToInt32(ls_Temp); }
catch { ls_count = 0; }
if (ls_count == 0)//不存在值为空的密码列
{
Response.Write("1"); return;
}
try
{
int RandKey = 0;
Random ran = new Random();//Random对象放在循环外面，否则大概率重复
for (int i = 0; i < ls_count; i++)
{
RandKey = ran.Next(1000, 9999);
string WeixinPwd = baseclass.DES.of_EncryStrVc(RandKey.ToString(), ls_DESKey);
string ls_Sql = "set rowcount 1 update customer set WeixinPwd=@WeixinPwd where WeixinPwd is null";
GysoftParameter[] Pa = { new GysoftParameter("@WeixinPwd", WeixinPwd) };
SqlHelper.ExecuteNonQuery(ls_Sql, Pa);
}
Response.Write("0");
return;
}
catch (Exception ex)
{ Response.Write(ex.Message); return; }
}
if (generate == "generate" && value == "get")//获取经销商初始密码
{
string ls_Sql = "select mobile,WeixinPwd from customer";
DataTable ldt_pwd = SqlHelper.ExecuteDataTable(ls_Sql);
string ls_pwd = Json.DataTableToJson(ldt_pwd);
Response.Write(ls_pwd);
return;
}
}
}
#endregion
#region 获取产品图文详情
string[] str1 = askey.Split('!');
if (str1.Length == 3)
{
string goocode = str1[0].Trim();
string user = str1[1].Trim();
string passwd = str1[2].Trim();
string code = as_Code;
ls_Rel = SureSaleInfo(user, passwd, code);
if (ls_Rel == "OK")
{
string ls_Sql = "select Memo from Goodsno_picture where Goo_code=@Goo_code";
GysoftParameter[] Pa =
{
new GysoftParameter("@Goo_code", goocode)
};
//DataTable ldt_user = SqlHelper.ExecuteDataTable(CommandType.Text, ls_Sql, Pa);
//string ls_json = Json.DataTableToJson(ldt_user);
//if (ls_json == "[]")
//{ Response.Write(""); }
//else
//Response.Write(ls_json);
string ldt_user = SqlHelper.ExecuteScalar(ls_Sql, Pa);
Response.Write(ldt_user);
return;
}
}
#endregion
else
{
Response.Write("error" + "key:" + Key + " askey:" + askey); return;
}
}
}
#endregion
}
