/// <summary> /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CreaeWechatFriend(FriendModel model) { var strSql = (@"INSERT INTO wechat_friend (`innerid`,`accountid`,`nickname`,`photo`,`openid`,`remarkname`,`area`,`sex`,`isdel`,`subscribe_time`,`subscribe`,country,province,city,`createdtime`) VALUES (@innerid,@accountid,@nickname,@photo,@openid,@remarkname,@area,@sex,@isdel,@subscribetime,@subscribe,@country,@province,@city,@createdtime);"); return Helper.Execute(strSql, model) > 0; }
/// <summary> /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateWechatFriend(FriendModel model) { var strSql = @"UPDATE wechat_friend SET `nickname` = @nickname, `photo` = @photo, `remarkname` = @remarkname,`area` = @area, `sex` = @sex, `isdel` = @isdel, `subscribe_time` = @subscribetime, country=@country,province=@province,city=@city, `subscribe` = @subscribe WHERE `openid` = @openid and `accountid` = @accountid "; return Helper.Execute(strSql, model) > 0; }
public void CreaeWechatFriendTestMethod_DA() { Thread.Sleep(new TimeSpan(0, 0, 1)); var name = DateTime.Now.ToString("yyyyMMddHHmmss"); var friend = new FriendModel { Innerid = Guid.NewGuid().ToString(), Accountid = APPID, Nickname = name, Photo = "Photo", OPENID = name, Country = "Country", Province = "province", City = "city", Sex = 1, Isdel = 0, SubscribeTime = DateTime.Now.Ticks, Subscribe = 1, Createdtime = DateTime.Now }; var result = da.CreaeWechatFriend(friend); Assert.IsTrue(result); }
public void UpdateWechatFriendTestMethod_DA_True() { Thread.Sleep(new TimeSpan(0, 0, 1)); var openid = DateTime.Now.ToString("yyyyMMddHHmmss"); var friend = new FriendModel { Innerid = Guid.NewGuid().ToString(), Accountid = APPID, Nickname = "Nickname", Photo = "Photo", OPENID = openid, Country = "Country", Province = "province", City = "city", Sex = 1, Isdel = 0, SubscribeTime = DateTime.Now.Ticks, Subscribe = 1, Createdtime = DateTime.Now }; var friend_updated = new FriendModel { Innerid = Guid.NewGuid().ToString(), Accountid = APPID, Nickname = "Nickname1", Photo = "Photo1", OPENID = openid, Country = "Country1", Province = "province1", City = "city1", Sex = 0, Isdel = 1, SubscribeTime = DateTime.Now.Ticks, Subscribe = 0, Createdtime = DateTime.Now }; var creaeWechatFriendresult = da.CreaeWechatFriend(friend); var isWechatFriendExistsresult = da.IsWechatFriendExists(APPID, openid); var updateWechatFriendresult = da.UpdateWechatFriend(friend_updated); Assert.IsTrue(creaeWechatFriendresult); Assert.IsTrue(isWechatFriendExistsresult); Assert.IsTrue(updateWechatFriendresult); }