public JsonResult UpdItemApply(BPApplyModel bpApply)
{
Result data = null;
try
{
strLoginID = HttpContext.Session.GetString("loginid");
data = new Result();
string spName = "UP_USER_ITEM_APPLY_TX_UPD";
string[] spParamName = new string[] {
"@pi_intApplyNo", "@pi_intStateCode", "@pi_strAdminID", "@po_intRetVal", "@po_strErrMsg"
};
object[] spParamValue = new object[] {
bpApply.ApplyNo, bpApply.StateCode, strLoginID, DBNull.Value, DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 730;
data.ErrMsg = "Exception in UpdItemApply : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult DetailBPApply(BPApplyModel bpApply)
{
Result <BPApplyModel> data = null;
try
{
data = new Result <BPApplyModel>();
string spName = "UP_BP_APPLY_AR_LST";
string[] spParamName = new string[] {
"@pi_intMemberStoreNo", "@pi_intApplyNo", "@pi_intStateCode"
};
object[] spParamValue = new object[] {
bpApply.MemberStoreNo, bpApply.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 BPApplyModel
{
UserNo = Convert.ToInt64(row["USERNO"]),
UserName = row["USERNAME"].ToString(),
Description = row["DESCRIPTION"].ToString(),
UseAmt = Convert.ToInt32(row["USEAMT"]),
ApplyAmt = Convert.ToInt32(row["APPLYAMT"]),
ImageDir = row["IMAGEDIR"].ToString(),
StateCode = Convert.ToInt16(row["STATECODE"]),
Memo = row["MEMO"].ToString() ?? "",
objUserModel = new UserModel
{
TeamName = row["TEAMNAME"].ToString(),
BPLevelName = row["BPLEVELNAME"].ToString()
}
};
}
}
}
catch (Exception ex)
{
data.RetVal = 749;
data.ErrMsg = "Exception in DetailBPApply : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult GetBPApplyList(BPApplyModel bpApply)
{
List <BPApplyModel> data = new List <BPApplyModel>();
try
{
string spName = "UP_BP_APPLY_AR_LST";
string[] spParamName = new string[] {
"@pi_intMemberStoreNo", "@pi_intApplyNo", "@pi_intStateCode"
};
object[] spParamValue = new object[] {
bpApply.MemberStoreNo, DBNull.Value, bpApply.StateCode
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
BPApplyModel obj = new BPApplyModel
{
RowNum = Convert.ToInt32(row["ROWNUM"]),
ApplyNo = Convert.ToInt64(row["APPLYNO"]),
UserNo = Convert.ToInt64(row["USERNO"]),
UserName = row["USERNAME"].ToString(),
Description = row["DESCRIPTION"].ToString(),
UseAmt = Convert.ToInt32(row["USEAMT"]),
ApplyAmt = Convert.ToInt32(row["APPLYAMT"]),
StateCode = Convert.ToInt16(row["STATECODE"]),
RegDate = row["REGDATE"].ToString(),
UpdDate = row["UPDDATE"].ToString()
};
data.Add(obj);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception in GetBPApplyList : " + ex.Message);
return(Json(data));
}
return(Json(new { data }));
}
