public async Task <ActionResult> GetInsurance()
{
AppFormPayService appFormPayService = new AppFormPayService();
BaseListResult <GetInsuranceOutput> result = await appFormPayService.GetInsurance();
return(this.Json(result));
}
/// <summary>
/// 获取用户基本信息 好友列表等
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public override CommonResult GetInitInfo(long userId)
{
return(_storage.UseConnection <CommonResult>(connection =>
{
string sql = @"SELECT pk_id AS id,name AS username,[sign],avatar FROM dbo.[user] WHERE pk_id=@uid
SELECT pk_id AS id,name AS groupname FROM dbo.friend_group WHERE [user_id]=@uid
SELECT a.pk_id AS gid,c.pk_id AS id,c.name as username,c.[sign],c.avatar FROM dbo.friend_group A INNER JOIN dbo.friend_group_detail B ON a.pk_id=B.group_id LEFT JOIN dbo.[user] C ON B.[user_id]=c.pk_id WHERE a.[user_id]=@uid
SELECT b.pk_id AS id,name AS groupname,avatar FROM dbo.big_group_detail A LEFT JOIN dbo.big_group B ON A.group_id=b.pk_id WHERE [user_id]=@uid";
SqlMapper.GridReader reader = connection.QueryMultiple(sql, new { uid = userId });
var result = new BaseListResult();
result.mine = reader.ReadFirstOrDefault <UserModel>();
//处理friend逻辑 start
var friend = reader.Read <FriendGroupModel>();
var groupUsers = reader.Read <GroupUserModel>();
friend.ToList().ForEach(f =>
{
//每一组的人分配给各个组
f.list = groupUsers?.Where(x => x.gid == f.id);
});
result.friend = friend;
//处理friend逻辑 end
//读取用户所在群
result.group = reader.Read <BigGroupModel>();
return new CommonResult {
code = result.mine == null ? 1 : 0, msg = result.mine == null ? "用户不存在" : "", data = result
};
}));
}
private BaseListResult ToBaseListResult(DataSet ds)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count == 0)
{
return(new BaseListResult());
}
//当前用户的信息
var rowMine = ds.Tables[0].Rows[0];
//用户组信息
var rowFriendDetails = ds.Tables[2].Rows.Cast <DataRow>().Select(x => new GroupUserEntity
{
id = x["uid"].ToInt(),
avatar = x["avatar"].ToString(),
groupid = x["gid"].ToInt(),
remarkname = x["remarkname"].ToString(),
username = x["nickname"].ToString(),
sign = x["sign"].ToString(),
//status之前的字段是为空的，现在我们把他的在线状态加上，IsOnline方法接收一个userid参数，从Redis缓存中读取该用户是否在线并返回
status = LayIMCache.Instance.IsOnline(x["uid"].ToInt()) ? "online" : "hide"
}).OrderByDescending(x => x.status);//这里要根据用户是否在线这个字段排序，保证在线用户都在好友列表最上边
//用户组信息，执行分组
var friend = ds.Tables[1].Rows.Cast <DataRow>().Select(x => new FriendGroupEntity
{
id = x["id"].ToInt(),
groupname = x["name"].ToString(),
online = 0,
list = rowFriendDetails.Where(f => f.groupid == x["id"].ToInt())
});
//群组信息
var group = ds.Tables[3].Rows.Cast <DataRow>().Select(x => new GroupEntity
{
id = x["id"].ToInt(),
groupname = x["name"].ToString(),
avatar = x["avatar"].ToString(),
groupdesc = x["groupdesc"].ToString()
});
//用户皮肤，第一个是默认正在使用的
List <string> skin = ds.Tables[4].Rows.Cast <DataRow>().Select(x => x[0].ToString()).ToList();
BaseListResult result = new BaseListResult
{
mine = new UserEntity
{
id = rowMine["id"].ToInt(),
avatar = rowMine["avatar"].ToString(),
sign = rowMine["sign"].ToString(),
username = rowMine["nickname"].ToString(),
status = "online"
},
friend = friend,
group = group,
skin = skin
};
return(result);
}
return(null);
}
/// <summary>
/// 取得往來明細清單(未繳/逾期)
/// </summary>
/// <param name="model">取得標的物資料(繳款紀錄) Input</param>
/// <returns>取得往來明細清單(未繳/逾期) Output</returns>
public async Task <BaseListResult <GetArRecLvNewOutput> > GetArLv1New(GetArRecLvInput model)
{
// 透過 Api 把資料送出去
string apiUrl = "V2/APP_FORM_PAY/GET_AR_LV1_NEW";
BaseListResult <GetArRecLvNewOutput> result = await ApiService.Instance.ApiGetArLv1New(model, apiUrl);
return(result);
}
/// <summary>
/// 取得保險列表
/// </summary>
/// <param name="model">取得標的物資料(繳款紀錄) Input</param>
/// <returns>銀行列表 Output</returns>
public async Task <BaseListResult <GetInsuranceOutput> > GetInsurance()
{
// 透過 Api 把資料送出去
string apiUrl = "/api/AppBack/GetInsurance";
BaseListResult <GetInsuranceOutput> result = await ApiService.Instance.ApiGetInsurance(null, apiUrl);
return(result);
}
/// <summary>
/// 取得繳款紀錄(含已繳項目)
/// </summary>
/// <param name="model">取得標的物資料(繳款紀錄) Input</param>
/// <returns>取得標的物資料(繳款紀錄) Output</returns>
public async Task <BaseListResult <GetArRecOutput> > GetArRec(GetArRecInput model)
{
// 透過 Api 把資料送出去
string apiUrl = "APP_FORM_PAY/GET_AR_REC";
BaseListResult <GetArRecOutput> result = await ApiService.Instance.ApiGetArRec(model, apiUrl);
return(result);
}
public async Task <ActionResult> GetArRecLv1()
{
GetCustInfoInput cusModel = new GetCustInfoInput();
GetCustInfoOutput cusResult = new GetCustInfoOutput();
if (this.TokenVerify.Id == string.Empty)
{
cusModel = new GetCustInfoInput
{
MBR_ID = this.TokenVerify.MbrId,
MbrId = this.TokenVerify.MbrId,
DevId = this.TokenVerify.DevId,
Token = this.TokenVerify.Token
};
// 取得會員資料
HomeService homeService = new HomeService();
cusResult = await homeService.GetCustInfo(cusModel);
if (cusResult.ID != string.Empty)
{
// 取得全資料
InitOutput initOutput = await homeService.INIT(cusResult.ID);
System.Web.HttpCookie AridCookie = this.AirdCookie(cusResult.ID ?? string.Empty, this.TokenVerify.MbrId, this.TokenVerify.DevId, this.TokenVerify.Token, initOutput?.CUST_ID ?? string.Empty, initOutput?.CNTRT_NO ?? string.Empty);
this.Response.Cookies.Add(AridCookie);
}
}
GetArRecLvInput model = new GetArRecLvInput
{
//ID = this.TokenVerify.Id,
ID = !string.IsNullOrEmpty(cusResult.ID) ? cusResult.ID : this.TokenVerify.Id,
COMP_ID = this.TokenVerify.CustId,
MbrId = this.TokenVerify.MbrId,
DevId = this.TokenVerify.DevId,
Token = this.TokenVerify.Token,
SYS_ID = Common.GetSysId()
};
AppFormPayService appFormPayService = new AppFormPayService();
BaseListResult <GetArRecLvOutput> result = await appFormPayService.GetArRecLv1(model);
return(this.Json(result));
}
public async Task <ActionResult> GetArRec(string cntrtNo)
{
GetArRecInput model = new GetArRecInput
{
ID = this.TokenVerify.Id,
CNTRT_NO = cntrtNo,
COMP_ID = this.TokenVerify.CustId,
MbrId = this.TokenVerify.MbrId,
DevId = this.TokenVerify.DevId,
Token = this.TokenVerify.Token,
SYS_ID = Common.GetSysId()
};
AppFormPayService appFormPayService = new AppFormPayService();
BaseListResult <GetArRecOutput> result = await appFormPayService.GetArRec(model);
return(this.Json(result));
}
/// <summary>
/// 取得全資料(已繳/未繳/逾期)
/// </summary>
/// <param name="model">取得會員資訊 Input</param>
/// <returns>取得會員資訊 Output</returns>
public async Task <InitOutput> INIT(string id)
{
// 透過 Api 把資料送出去
string apiUrl = "APP_FORM_PAY/INIT";
InitInput model = new InitInput
{
ID = id
};
BaseListResult <InitOutput> baseListResult = await ApiService.Instance.ApiINIT(model, apiUrl);
InitOutput result = new InitOutput();
if (baseListResult.Result.ReturnCode == 0 && baseListResult.Data != null)
{
result = baseListResult.Data.FirstOrDefault();
}
return(result);
}
/// <summary>
/// 取得標的物資料(繳款紀錄)
/// </summary>
/// <param name="model">param</param>
/// <param name="apiUrl">Api 路徑</param>
/// <returns>result</returns>
public async Task <BaseListResult <GetArRecOutput> > ApiGetArRec(GetArRecInput model, string apiUrl)
{
BaseListResult <GetArRecOutput> result = await this.GetApiResultAsync <BaseListResult <GetArRecOutput> >(apiUrl, model);
return(result);
}
/// <summary>
/// 取得往來明細清單(未繳/逾期)
/// </summary>
/// <param name="model">param</param>
/// <param name="apiUrl">Api 路徑</param>
/// <returns>result</returns>
public async Task <BaseListResult <GetArRecLvNewOutput> > ApiGetArLv1New(object model, string apiUrl)
{
BaseListResult <GetArRecLvNewOutput> result = await this.GetApiResultAsync <BaseListResult <GetArRecLvNewOutput> >(apiUrl, model);
return(result);
}
/// <summary>
/// 取得保險列表
/// </summary>
/// <param name="model">param</param>
/// <param name="apiUrl">Api 路徑</param>
/// <returns>result</returns>
public async Task <BaseListResult <GetInsuranceOutput> > ApiGetInsurance(object model, string apiUrl)
{
BaseListResult <GetInsuranceOutput> result = await this.GetApiResultAsync <BaseListResult <GetInsuranceOutput> >(apiUrl, model, true);
return(result);
}
/// <summary>
/// 取得全資料(已繳/未繳/逾期)
/// </summary>
/// <param name="model">param</param>
/// <param name="apiUrl">Api 路徑</param>
/// <returns>result</returns>
public async Task <BaseListResult <InitOutput> > ApiINIT(object model, string apiUrl)
{
BaseListResult <InitOutput> result = await this.GetApiResultAsync <BaseListResult <InitOutput> >(apiUrl, model);
return(result);
}
public async Task <ActionResult> GetArLv1New()
{
var dataList = new List <GetArRecLvNewOutput>();
var data = new GetArRecLvNewOutput();
var ar = new ArList();
var arList = new List <ArList>();
GetArRecLvInput model = new GetArRecLvInput
{
ID = this.TokenVerify.Id,
COMP_ID = this.TokenVerify.CustId,
MbrId = this.TokenVerify.MbrId,
DevId = this.TokenVerify.DevId,
Token = this.TokenVerify.Token,
SYS_ID = Common.GetSysId()
};
AppFormPayService appFormPayService = new AppFormPayService();
BaseListResult <GetArRecLvNewOutput> result = await appFormPayService.GetArLv1New(model);
foreach (var item in result.Data)
{
data = new GetArRecLvNewOutput();
arList = new List <ArList>();
data.IS_PROXY = item.IS_PROXY;
data.PAYABLE_AMT = item.PAYABLE_AMT;
data.CNTRT_NO = item.CNTRT_NO;
data.OBJ_ITEMS = item.OBJ_ITEMS;
data.PAYMENT_DESC = item.PAYMENT_DESC;
data.AR_DT = item.AR_DT;
data.AR_AMT = item.AR_AMT;
data.TTL_AMT = item.TTL_AMT;
data.OBJ_NAME = item.OBJ_NAME;
data.VENDER_NME = item.VENDER_NME;
data.BUY_DT = item.BUY_DT;
data.IS_FINISH = item.IS_FINISH;
foreach (var itemList in item.AR_LIST)
{
ar = new ArList();
ar.AR_AMT = itemList.AR_AMT;
ar.AR_CNT = itemList.AR_CNT;
ar.AR_DESC = itemList.AR_DESC;
ar.AR_DT = itemList.AR_DT;
ar.AR_ID = itemList.AR_ID;
ar.AR_PAYDT = itemList.AR_PAYDT;
ar.AR_PK = itemList.AR_PK;
ar.ISCURRENT = itemList.ISCURRENT;
ar.OVERDUE = itemList.OVERDUE;
ar.PAYMENT_STATUS = itemList.PAYMENT_STATUS;
if (item.IS_PROXY == "Y" && itemList.PAYMENT_STATUS == "1" && itemList.ISCURRENT == "Y")
{
data.PAYABLE_AMT = 0;
data.AR_DT = itemList.AR_DT;
}
arList.Add(ar);
}
data.AR_LIST = arList;
dataList.Add(data);
}
result.Data = dataList;
return(this.Json(result));
}
