/// <summary>
/// 获得数据列表
/// </summary>
public List <LPWeb.Model.LoanActivities> DataTableToList(DataTable dt)
{
List <LPWeb.Model.LoanActivities> modelList = new List <LPWeb.Model.LoanActivities>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LPWeb.Model.LoanActivities model;
for (int n = 0; n < rowsCount; n++)
{
model = new LPWeb.Model.LoanActivities();
if (dt.Rows[n]["ActivityId"].ToString() != "")
{
model.ActivityId = int.Parse(dt.Rows[n]["ActivityId"].ToString());
}
if (dt.Rows[n]["FileId"].ToString() != "")
{
model.FileId = int.Parse(dt.Rows[n]["FileId"].ToString());
}
if (dt.Rows[n]["UserId"].ToString() != "")
{
model.UserId = int.Parse(dt.Rows[n]["UserId"].ToString());
}
model.ActivityName = dt.Rows[n]["ActivityName"].ToString();
if (dt.Rows[n]["ActivityTime"].ToString() != "")
{
model.ActivityTime = DateTime.Parse(dt.Rows[n]["ActivityTime"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LPWeb.Model.LoanActivities model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.LoanActivities model)
{
return(dal.Add(model));
}
protected void Page_Load(object sender, EventArgs e)
{
// json示例
// {"ExecResult":"Success","ErrorMsg":""}
// {"ExecResult":"Failed","ErrorMsg":"Failed to do sth."}
#region 校验页面参数
string sError_Lost = "Lost required query string.";
string sError_Invalid = "Invalid query string.";
if (this.Request.QueryString["FileId"] == null)
{
this.Response.Write("{\"ExecResult\":\"Failed\",\"ErrorMsg\":\"" + sError_Lost + "\"}");
this.Response.End();
}
string sFileId = this.Request.QueryString["FileId"];
if (PageCommon.IsID(sFileId) == false)
{
this.Response.Write("{\"ExecResult\":\"Failed\",\"ErrorMsg\":\"" + sError_Invalid + "\"}");
this.Response.End();
}
if (this.Request.QueryString["ConditionId"] == null)
{
this.Response.Write("{\"ExecResult\":\"Failed\",\"ErrorMsg\":\"" + sError_Lost + "\"}");
this.Response.End();
}
#endregion
int iFileId = Convert.ToInt32(sFileId);
string sConditionIds = this.Request.QueryString["ConditionId"];
string[] sConditionIDArr = sConditionIds.Split(',');
string sErrorMsg = string.Empty;
LPWeb.BLL.LoanConditions lcon = new LPWeb.BLL.LoanConditions();
LPWeb.BLL.LoanActivities lActive = new LPWeb.BLL.LoanActivities();
#region Update Condition(Mark as Received)
UpdateConditionsRequest req = new UpdateConditionsRequest();
UpdateConditionsResponse resp = new UpdateConditionsResponse();
try
{
Conditions[] myConditions = new Conditions[sConditionIDArr.Length];
if (sConditionIDArr.Length < 1)
{
this.Response.Write("{\"ExecResult\":\"Success\",\"ErrorMsg\":\"\"}");
return;
}
int iConditionIdx = 0;
foreach (string sConditionID in sConditionIDArr)
{
int iConditionId = 0;
string sConditionName = "";
if (Int32.TryParse(sConditionID, out iConditionId) == false)
{
continue;
}
//Get Condition Status
DataTable dtCondition = lcon.GetLoanConditionsInfo(iConditionId);
if (dtCondition != null && dtCondition.Rows.Count > 0)
{
string sStatus = dtCondition.Rows[0]["Status"].ToString().Trim();
string Received_Date = dtCondition.Rows[0]["Received"].ToString().Trim();
sConditionName = dtCondition.Rows[0]["CondName"].ToString().Trim();
if (sStatus == "Cleared" || sStatus == "Received")
{
if ((Received_Date != null) &&
(Received_Date != string.Empty))
{
continue;
}
}
}
else
{
continue;
}
Conditions condition = new Conditions();
condition.ConditionId = iConditionId;
condition.Name = sConditionName;
condition.Status = "Received";
myConditions.SetValue(condition, iConditionIdx);
iConditionIdx++;
}
req.ConditionList = new Conditions[iConditionIdx];
int i = 0;
foreach (Conditions myCon in myConditions)
{
if (myCon == null)
{
continue;
}
req.ConditionList.SetValue(myCon, i);
i++;
}
if (req.ConditionList.Length < 1)
{
this.Response.Write("{\"ExecResult\":\"Success\",\"ErrorMsg\":\"\"}");
return;
}
#region Invoking WCF
ServiceManager sm = new ServiceManager();
using (LP2ServiceClient service = sm.StartServiceClient())
{
req.FileId = iFileId;
req.hdr = new ReqHdr();
req.hdr.UserId = CurrUser.iUserID;
resp = service.UpdateConditions(req);
if (resp == null || resp.hdr == null)
{
this.Response.Write("{\"ExecResult\":\"Failed\",\"ErrorMsg\":\"UpdateConditions is NULL\"}");
return;
}
sErrorMsg = resp.hdr.StatusInfo;
if (resp.hdr.Successful == true)
{
foreach (Conditions conObj in req.ConditionList)
{
if (conObj == null)
{
continue;
}
//Update Loan Condition Status
lcon.UpdateConditionStatusToReceived(conObj.ConditionId, CurrUser.sFullName);
//Insert Loan Activities
LPWeb.Model.LoanActivities lActiveMode = new LPWeb.Model.LoanActivities();
lActiveMode.FileId = iFileId;
lActiveMode.ActivityName = "Marked Condition – " + conObj.Name + " as Received";
lActiveMode.ActivityTime = DateTime.Now;
lActiveMode.UserId = CurrUser.iUserID;
lActive.Add(lActiveMode);
}
this.Response.Write("{\"ExecResult\":\"Success\",\"ErrorMsg\":\"\"}");
return;
}
else
{
sErrorMsg = "Update Condition Exception: " + sErrorMsg;
this.Response.Write("{\"ExecResult\":\"Failed\",\"ErrorMsg\":\"" + sErrorMsg + "\"}");
return;
}
}
#endregion Invoking WCF
}
catch (System.ServiceModel.EndpointNotFoundException)
{
sErrorMsg = string.Format("Exception: Point Manager is not running.");
LPLog.LogMessage(LogType.Logerror, sErrorMsg);
this.Response.Write("{\"ExecResult\":\"Failed\",\"ErrorMsg\":\"" + sErrorMsg + "\"}");
return;
}
catch (Exception ex)
{
sErrorMsg = string.Format("error: {0}", ex.Message);
LPLog.LogMessage(LogType.Logerror, sErrorMsg);
sErrorMsg = "Point Manager Exception: Database timeout expired";
this.Response.Write("{\"ExecResult\":\"Failed\",\"ErrorMsg\":\"" + sErrorMsg + "\"}");
return;
}
#endregion
}
