protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlParameter[] sp = new SqlParameter[] { new SqlParameter("name", FzUserName) }; DataTable dt = hostBll.SelByWhere("Name=@name", "Name", sp); if (dt.Rows.Count < 1) { function.WriteErrMsg("主机[" + FzUserName + "]不存在"); } DataRow dr = dt.Rows[0]; Name_T.Text = DataConverter.CStr(dr["Name"]); UserPwd_T.Text = DataConverter.CStr(dr["UserPwd"]); CDate_T.Text = DataConverter.CStr(dr["CDate"]); EndDate_T.Text = DataConverter.CDate(dr["EndDate"]).ToString("yyyy/MM/dd"); SiteInfo_T.Text = DataConverter.CStr(dr["SiteInfo"]); Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "Main.aspx'>工作台</a></li><li><a href='Default.aspx'>站群管理</a></li><li><a href='" + Request.RawUrl + "'>主机管理</a></li><li>主机信息</li>"); } }
public string wxqrcode(int refereeType, string refereeId, string key) { try { if (string.IsNullOrEmpty(key)) { retMod.retmsg = "未指定key"; } else if (!key.Equals(APIKey)) { retMod.retmsg = "key不正确"; } else { int scenceid = 0; B_CodeModel codeBll = new B_CodeModel("ZL_SSW_WXQRCode"); SqlParameter[] sp = new SqlParameter[] { new SqlParameter("refereeId", refereeId) }; DataTable dt = codeBll.SelByWhere("refereeType=" + refereeType + " AND refereeId=" + refereeId, "ID DESC", sp); if (dt.Rows.Count < 1) { DataRow dr = dt.NewRow(); dr["refereeType"] = refereeType; dr["refereeId"] = refereeId; scenceid = codeBll.Insert(dr); } else { scenceid = Convert.ToInt32(dt.Rows[0]["ID"]); } //-------------------------------------------------------------------------- WxAPI wxapi = WxAPI.Code_Get(); string resultStr = APIHelper.GetWebResult("https://api.weixin.qq.com/cgi-bin/qrcode/create?access_token=" + wxapi.AccessToken + "&type=jsapi", "POST", "{\"expire_seconds\":604800,\"action_name\":\"QR_LIMIT_SCENE\",\"action_info\":{\"scene\":{\"scene_id\":" + scenceid + "}}}"); JObject result = (JObject)JsonConvert.DeserializeObject(resultStr); if (result["ticket"] == null) { retMod.retmsg = resultStr; ZLLog.L("wxqrcode failed1:" + resultStr); } else { retMod.result = "https://mp.weixin.qq.com/cgi-bin/showqrcode?ticket=" + HttpUtility.UrlEncode(result["ticket"].ToString()); retMod.retcode = M_APIResult.Success; } } } catch (Exception ex) { retMod.retmsg = ex.Message; ZLLog.L("wxqrcode failed2:" + ex.Message); } return(retMod.ToString()); }
//更新商品所用原料信息 private void IsHaveMaterial(M_Product proMod) { B_Shop_Material matBll = new B_Shop_Material(); B_CodeModel codeBll = new B_CodeModel("ZL_Shop_ProMaterial"); try { DataTable dt = DBCenter.SelWithField(matBll.TbName, "ID"); foreach (DataRow dr in dt.Rows) { int id = Convert.ToInt32(dr["ID"]); int matnum = DataConvert.CLng(Request.Form["mat_" + id + "_num"]); if (matnum < 0) { matnum = 0; } DataTable codeMod = codeBll.SelByWhere("ProID=" + proMod.ID + " AND MatID=" + id, "ID DESC"); if (codeMod.Rows.Count < 1) { codeMod.Rows.Add(codeMod.NewRow()); } codeMod.Rows[0]["ProID"] = proMod.ID; codeMod.Rows[0]["MatID"] = id; codeMod.Rows[0]["MatNum"] = matnum; codeMod.Rows[0]["Remind"] = ""; if (DataConvert.CLng(codeMod.Rows[0]["ID"]) > 0) { codeBll.UpdateByID(codeMod.Rows[0]); } else { codeBll.Insert(codeMod.Rows[0]); } } } catch { } }