public JsonResult DetailItemApply(ItemApplyModel itemApply)
{
Result <ItemApplyModel> data = null;
try
{
data = new Result <ItemApplyModel>();
string spName = "UP_USER_ITEM_APPLY_AR_LST";
string[] spParamName = new string[] {
"@pi_intMemberStoreNo", "@pi_intApplyNo", "@pi_intStateCode"
};
object[] spParamValue = new object[] {
itemApply.MemberStoreNo, itemApply.ApplyNo, DBNull.Value
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
data.data = new ItemApplyModel
{
UserNo = Convert.ToInt64(row["USERNO"]),
UserName = row["USERNAME"].ToString(),
Description = row["DESCRIPTION"].ToString(),
Price = Convert.ToInt32(row["PRICE"]),
TotalINCnt = Convert.ToInt32(row["TOTALINCNT"]),
ImageDir = row["IMAGEDIR"].ToString(),
StateCode = Convert.ToInt16(row["STATECODE"]),
objUserModel = new UserModel
{
TeamName = row["TEAMNAME"].ToString(),
BPLevelName = row["BPLEVELNAME"].ToString()
},
TotalOUTCnt = Convert.ToInt32(row["TOTALOUTCNT"]),
RemainCnt = Convert.ToInt32(row["REMAINCNT"]),
ItemName = row["ITEMNAME"].ToString()
};
}
}
}
catch (Exception ex)
{
data.RetVal = 739;
data.ErrMsg = "Exception in DetailItemApply : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult GetItemApplyList(ItemApplyModel itemApply)
{
List <ItemApplyModel> data = new List <ItemApplyModel>();
try
{
string spName = "UP_USER_ITEM_APPLY_AR_LST";
string[] spParamName = new string[] {
"@pi_intMemberStoreNo", "@pi_intApplyNo", "@pi_intStateCode"
};
object[] spParamValue = new object[] {
itemApply.MemberStoreNo, DBNull.Value, itemApply.StateCode
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
ItemApplyModel obj = new ItemApplyModel
{
ApplyNo = Convert.ToInt64(row["APPLYNO"]),
UserNo = Convert.ToInt64(row["USERNO"]),
UserName = row["USERNAME"].ToString(),
Description = row["DESCRIPTION"].ToString(),
Price = Convert.ToInt32(row["PRICE"]),
TotalINCnt = Convert.ToInt32(row["TOTALINCNT"]),
StateCode = Convert.ToInt16(row["STATECODE"]),
RegDate = row["REGDATE"].ToString(),
UpdDate = row["UPDDATE"].ToString(),
TotalOUTCnt = Convert.ToInt32(row["TOTALOUTCNT"]),
RemainCnt = Convert.ToInt32(row["REMAINCNT"]),
ItemName = row["ITEMNAME"].ToString()
};
data.Add(obj);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception in GetItemApplyList : " + ex.Message);
return(Json(data));
}
return(Json(new { data }));
}
