/// <summary> /// 插入合作商信息 /// </summary> /// <returns>大于0成功,否则失败</returns> /// <remarks> /// <list type="bullet"> /// </list> /// </remarks> public int Insert(Dictionary <string, object> datajson) { ClearCache(); int val = 0; ConnectorEntity ent = new ConnectorEntity(); ent.SetValues(datajson); //检查信息是否存在 Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("GroupId", ent.GroupId); dic.Add("SellerId", ent.SellerId); dic.Add("Name", ent.Name); ConnectorEntity entConnector = DbAccess.GetEntity <ConnectorEntity>(TableName, dic); if (entConnector != null && Utils.ToInt(entConnector.Id) != 0) { return(-1); } ent.Status = 1; ent.AddTime = DateTime.Now; ent.UpdateTime = DateTime.Now; val = DbAccess.ExecuteInsert(TableName, ent); return(val); }
/// <summary> /// 交换token /// </summary> /// <param name="dic"></param> /// <returns></returns> public IResultResponse ExchangeToken(int fk_id, int db_id) { DataTable dt = DbAccess.GetDataTable(string.Format(CommandConstant.ConnectorAuth, fk_id, db_id)); if (dt != null && dt.Rows.Count > 0) { ConnectorEntity entity = new ConnectorEntity(); entity.SetValues(dt.Rows[0]); AccessToken accessToken = new AccessToken(Utils.ToInt(entity.Id), Utils.ToInt(entity.SellerId), entity.Name, entity.Mobile, entity.Domain, Utils.ToInt(entity.GroupId), Utils.ToInt(entity.DBId), Utils.ToInt(entity.UpConnectorId) ); Dictionary <string, object> authDic = dt.Rows[0].ToDictionary(); authDic.Add("Token", accessToken.ToTokenString()); authDic.Add("Qr", ECF.Security.AES.Encode(entity.Id.ToString())); authDic.Add("Expire", Utils.ToUnixTime(DateTime.Now.AddDays(1))); return(ResultResponse.GetSuccessResult(authDic)); } else { return(ResultResponse.ExceptionResult("", null, 201)); } }
/// <summary> /// 更新合作商 /// </summary> /// <param name="xmlDoc">xmlDoc格式的合作商数据.</param> /// <param name="id">待更新的Id.</param> /// <returns> /// System.Int32,大于0成功,否则失败 /// </returns> /// <remarks> /// <list type="bullet"> /// <item></item> /// </list> /// </remarks> public int Update(Dictionary <string, object> datajson) { try { ClearCache(); int val = 0; ConnectorEntity ent = new ConnectorEntity(); ent.SetValues(datajson); //检查信息是否存在 Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("Id", ent.Id); ConnectorEntity entConnector = DbAccess.GetEntity <ConnectorEntity>(TableName, dic); if (entConnector == null || entConnector.Id == null || entConnector.Id < 1) { return(-1); } entConnector.Name = ent.Name; entConnector.SellerId = ent.SellerId; entConnector.Logo = ent.Logo; entConnector.Mobile = ent.Mobile; entConnector.GroupId = ent.GroupId; entConnector.Remark = ent.Remark; entConnector.Status = ent.Status; entConnector.UpdateTime = DateTime.Now; val = DbAccess.ExecuteUpdate(TableName, entConnector, new string[] { "Id" }); return(val); } catch (Exception ex) { new Exceptions(ex.Message, ex); } return(0); }
/// <summary> /// 入驻 /// </summary> /// <param name="dic"></param> /// <returns></returns> public IResultResponse Join(Dictionary <string, object> dic) { if (dic == null) { return(ResultResponse.ExceptionResult("对像为空")); } ConnectorEntity entity = new ConnectorEntity(); entity.SetValues(dic); entity.Status = 1; entity.AddTime = DateTime.Now; GroupEntity groupEntity = new GroupEntity(); groupEntity.SetValues(dic); groupEntity.Status = 1; groupEntity.AddTime = DateTime.Now; IResultResponse resultResponse = null; using (IDTService dbHandler = DbAccess.DtService) { try { dbHandler.BeginTransaction(); //保存主表 int id = Utils.ToInt(dbHandler.ExecuteScalar(DbProvider.InsertCommandText(groupEntity, GroupBusiness._TableName))); if (id == 0) { throw new Exception("操作失败"); } entity.GroupId = id; dbHandler.ExecuteScalar(DbProvider.InsertCommandText(entity, TableName)); dbHandler.CommitTransaction(); resultResponse = ResultResponse.GetSuccessResult(1); } catch (Exception ex) { dbHandler.RollbackTransaction(); resultResponse = ResultResponse.ExceptionResult(ex.Message); } } return(resultResponse); }