public JsonResult GetDirectSettleList(SettleReqModel settleReq)
{
List <DirectSettleResModel> data = new List <DirectSettleResModel>();
try
{
string spName = "UP_BP_SETTLE_AR_LST";
string[] spParamName = new string[] {
"@pi_intStoreNo", "@pi_intSettleYM", "@pi_intSettleType", "@pi_intLoginType"
};
object[] spParamValue = new object[] {
settleReq.StoreNo, settleReq.SettleYM, settleReq.SettleType, settleReq.LoginType
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
if (settleReq.LoginType.Equals(1)) //슈퍼유저
{
DirectSettleResModel obj = new DirectSettleResModel
{
MemberStoreNo = Convert.ToInt64(row["MEMBERSTORENO"]),
MemberStoreName = row["MEMBERSTORENAME"].ToString(),
ApplyCnt = Convert.ToInt32(row["APPLYCNT"]),
ApplyAmt = Convert.ToInt32(row["APPLYAMT"])
};
data.Add(obj);
}
else if (settleReq.LoginType.Equals(2)) //가맹점
{
DirectSettleResModel obj = new DirectSettleResModel
{
MemberStoreNo = Convert.ToInt64(row["MEMBERSTORENO"]),
MemberStoreName = row["MEMBERSTORENAME"].ToString(),
UserNo = Convert.ToInt64(row["USERNO"]),
UserName = row["USERNAME"].ToString(),
ApplyAmt = Convert.ToInt32(row["APPLYAMT"]),
StateCode = Convert.ToInt16(row["STATECODE"]),
ApplyDate = row["APPLYDATE"].ToString() ?? ""
};
data.Add(obj);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception in GetDirectSettleList : " + ex.Message);
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult GetBPApplySettleList(SettleReqModel settleReq)
{
List <BPApplySettleResModel> data = new List <BPApplySettleResModel>();
try
{
string spName = "UP_BP_SETTLE_AR_LST";
string[] spParamName = new string[] {
"@pi_intStoreNo", "@pi_intSettleYM", "@pi_intSettleType", "@pi_intLoginType"
};
object[] spParamValue = new object[] {
settleReq.StoreNo, settleReq.SettleYM, settleReq.SettleType, settleReq.LoginType
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
if (settleReq.LoginType.Equals(1)) //슈퍼유저
{
BPApplySettleResModel obj = new BPApplySettleResModel
{
SalesStoreNo = Convert.ToInt64(row["SALESSTORENO"]),
SalesStoreName = row["SALESSTORENAME"].ToString(),
TotalCnt = Convert.ToInt32(row["TOTALCNT"]),
TotalAmt = Convert.ToInt32(row["TOTALAMT"])
};
data.Add(obj);
}
else if (settleReq.LoginType.Equals(2)) //가맹점
{
BPApplySettleResModel obj = new BPApplySettleResModel
{
MemberStoreNo = Convert.ToInt64(row["MEMBERSTORENO"]),
UserNo = Convert.ToInt64(row["USERNO"]),
UserName = row["USERNAME"].ToString(),
SalesStoreNo = Convert.ToInt64(row["SALESSTORENO"]),
SalesStoreName = row["SALESSTORENAME"].ToString(),
ApplyAmt = Convert.ToInt32(row["APPLYAMT"]),
ApplyDate = row["APPLYDATE"].ToString()
};
data.Add(obj);
}
else if (settleReq.LoginType.Equals(3)) //판매처
{
BPApplySettleResModel obj = new BPApplySettleResModel
{
SalesStoreNo = Convert.ToInt64(row["SALESSTORENO"]),
SalesStoreName = row["SALESSTORENAME"].ToString(),
MemberStoreNo = Convert.ToInt64(row["MEMBERSTORENO"]),
MemberStoreName = row["MEMBERSTORENAME"].ToString(),
ItemNo = Convert.ToInt64(row["ITEMNO"]),
ItemGroupNo = Convert.ToInt64(row["ITEMGROUPNO"]),
ItemGroupName = row["ITEMGROUPNAME"].ToString(),
ItemName = row["ITEMNAME"].ToString(),
ItemPrice = Convert.ToInt32(row["ITEMPRICE"]),
PurchaseCnt = Convert.ToInt32(row["PURCHASECNT"]),
TotalAmt = Convert.ToInt32(row["TOTALAMT"]),
RegDate = row["REGDATE"].ToString()
};
data.Add(obj);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception in GetBPApplySettleList : " + ex.Message);
return(Json(data));
}
return(Json(new { data }));
}
