/// <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);
}