public void UpdateMediaID(string updateValue, string wxstring) { MeidaInformation objMeida = JsonConvert.DeserializeObject <MeidaInformation>(wxstring); CRMLIBASHX obj = JsonConvert.DeserializeObject <CRMLIBASHX>(updateValue); DbConnection conn = CyDbConnManager.GetDbConnection("CRMDB"); try { conn.Open(); } catch (Exception e) { throw new MyDbException(e.Message, true); } CyQuery query = new CyQuery(conn); try { query.SQL.Text = "update WX_MEDIADY set MEDIA_ID=:MEDIA_ID where JLBH=:JLBH"; query.ParamByName("MEDIA_ID").AsString = objMeida.media_id; query.ParamByName("JLBH").AsInteger = obj.iJLBH; query.ExecSQL(); } catch (Exception e) { if (e is MyDbException) { throw e; } throw new MyDbException(e.Message, query.SqlText); } }
public WX_NewsContent Get_WX_News(out string msg, string PUBLICID, string updateValue) { msg = string.Empty; CRMLIBASHX obj = JsonConvert.DeserializeObject <CRMLIBASHX>(updateValue); WX_NewsContent tp_newscontent = new WX_NewsContent(); DbConnection conn = CyDbConnManager.GetDbConnection("CRMDB"); try { conn.Open(); } catch (Exception e) { throw new MyDbException(e.Message, true); } CyQuery query = new CyQuery(conn); try { List <WX_NewsContentList> newscontentlist = new List <WX_NewsContentList>(); tp_newscontent.articles = newscontentlist; query.SQL.Text = "select * from WX_NEWSDY_ITEM where 1=1"; if (obj.iJLBH != 0) { query.SQL.Add(" and JLBH=" + obj.iJLBH); } query.Open(); while (!query.Eof) { WX_NewsContentList list = new WX_NewsContentList(); newscontentlist.Add(list); list.title = query.FieldByName("TITLE").AsString; list.thumb_media_id = query.FieldByName("THUMB_MEDIA_ID").AsString; list.author = query.FieldByName("AUTHOR").AsString; list.digest = query.FieldByName("DIGEST").AsString; list.show_cover_pic = query.FieldByName("BJ_COVER").AsInteger; list.content = query.FieldByName("CONTNET").AsString; list.content_source_url = query.FieldByName("YWURL").AsString; query.Next(); } query.Close(); } catch (Exception e) { if (e is MyDbException) { throw e; } else { throw new MyDbException(e.Message, query.SqlText); } } finally { conn.Close(); } return(tp_newscontent); }
public override string DeleteNews(out string msg, string PUBLICID, string PUBLICIF, string updateValue, HttpContext context = null) { method = "POST"; Token = (new WX_Token()).getToken(PUBLICIF); Token1 oToken = new Token1(); oToken = JsonConvert.DeserializeObject <Token1>(Token); Url = "https://api.weixin.qq.com/cgi-bin/material/del_material?access_token=" + oToken.result; string wxstring = WXRequestString(out msg, context, updateValue); if (msg.Length > 0) { WriteToLog(msg); } else { MeidaInformation objMeida = JsonConvert.DeserializeObject <MeidaInformation>(updateValue); DbConnection conn = CyDbConnManager.GetDbConnection("CRMDB"); try { conn.Open(); } catch (Exception e) { throw new MyDbException(e.Message, true); } CyQuery query = new CyQuery(conn); try { query.SQL.Text = "delete from WX_MEDIADY where MEDIA_ID=:MEDIA_ID"; query.ParamByName("MEDIA_ID").AsString = objMeida.media_id; query.ExecSQL(); query.SQL.Text = "delete from WX_NEWSDY_ITEM where JLBH=(select JLBH from WX_MEDIADY where MEDIA_ID=:MEDIA_ID)"; query.ParamByName("MEDIA_ID").AsString = objMeida.media_id; query.ExecSQL(); } catch (Exception e) { if (e is MyDbException) { throw e; } throw new MyDbException(e.Message, query.SqlText); } } return(wxstring); }
//public class WX_MenuContentList //{ // public string name { get; set; } // public string type { get; set; } // public string nbdm { get; set; } // public string url { get; set; } // public string dm; // public List<WX_MenuContentListItem> sub_button { get; set; } //} //public class WX_MenuContentListItem //{ // public string type { get; set; } // public string name { get; set; } // public string nbdm { get; set; } // public string url { get; set; } //} public WX_MenuContent Get_WX_PostMenu(out string msg, string PUBLICID) { msg = string.Empty; WX_MenuContent tp_menucontent = new WX_MenuContent(); DbConnection conn = CyDbConnManager.GetDbConnection("CRMDB"); try { conn.Open(); } catch (Exception e) { throw new MyDbException(e.Message, true); } try { CyQuery query = new CyQuery(conn); List <WX_MenuContentList> menucontentlist = new List <WX_MenuContentList>(); tp_menucontent.button = menucontentlist; List <WX_MenuMiddle> menu = new List <WX_MenuMiddle>(); try { string DbSystemName = CyDbSystem.GetDbSystemName(query.Connection); query.SQL.Clear(); query.Params.Clear(); query.SQL.Add("select NAME,ASKID,DM,TYPE,URL,PUBLICID from WX_MENU where ").Add(CyDbSystem.GetDataLengthFuncName(conn)).Add("(DM)=2 and PUBLICID='" + PUBLICID + "' order by DM"); //query.ParamByName("PUBLICID").AsInteger = Convert.ToInt32(PUBLICID); query.Open(); while (!query.Eof) { WX_MenuMiddle tp_menu = new WX_MenuMiddle(); menu.Add(tp_menu); tp_menu.key = Convert.ToString(query.FieldByName("ASKID").AsInteger); tp_menu.dm = query.FieldByName("DM").AsString; tp_menu.type = query.FieldByName("TYPE").AsInteger; tp_menu.url = query.FieldByName("URL").AsString; tp_menu.PUBLICID = query.FieldByName("PUBLICID").AsInteger; if (DbSystemName == "ORACLE") { tp_menu.name = query.FieldByName("NAME").AsString; } else if (DbSystemName == "SYBASE") { tp_menu.name = query.FieldByName("NAME").GetChineseString(200); } query.Next(); } query.Close(); query.Params.Clear(); for (int i = 0; i < menu.Count; i++) { WX_MenuContentList tp_menucontentlist = new WX_MenuContentList(); menucontentlist.Add(tp_menucontentlist); tp_menucontentlist.name = menu[i].name; if (menu[i].type == 0) { List <WX_MenuContentListItem> list_menucontentlistitem = new List <WX_MenuContentListItem>(); tp_menucontentlist.sub_button = list_menucontentlistitem; query.Params.Clear(); query.SQL.Clear(); query.SQL.Add("select NAME,TYPE,ASKID,DM,URL,PUBLICID from WX_MENU where " + CyDbSystem.GetDataLengthFuncName(conn) + "(DM)=4 and DM LIKE '" + menu[i].dm + "%" + "' and PUBLICID='" + PUBLICID + "' order by DM"); //query.ParamByName("PUBLICID").AsInteger = Convert.ToInt32(PUBLICID); query.Open(); while (!query.Eof) { WX_MenuContentListItem tp_menucontentlistitem = new WX_MenuContentListItem(); list_menucontentlistitem.Add(tp_menucontentlistitem); int itemtype = query.FieldByName("TYPE").AsInteger; tp_menucontentlistitem.PUBLICID = query.FieldByName("PUBLICID").AsInteger; if (DbSystemName == "ORACLE") { tp_menucontentlistitem.name = query.FieldByName("NAME").AsString; } else if (DbSystemName == "SYBASE") { tp_menucontentlistitem.name = query.FieldByName("NAME").GetChineseString(200); } if (itemtype == 2) { tp_menucontentlistitem.type = "view"; tp_menucontentlistitem.url = query.FieldByName("URL").AsString; } if (itemtype == 1) { tp_menucontentlistitem.type = "click"; tp_menucontentlistitem.key = Convert.ToString(query.FieldByName("ASKID").AsInteger); } query.Next(); } query.Close(); } else if (menu[i].type == 1) { tp_menucontentlist.type = "click"; tp_menucontentlist.key = menu[i].key; } else if (menu[i].type == 2) { tp_menucontentlist.type = "view"; tp_menucontentlist.url = menu[i].url; } } } catch (Exception e) { if (e is MyDbException) { throw e; } else { throw new MyDbException(e.Message, query.SqlText); } } } finally { conn.Close(); } return(tp_menucontent); }