public AppealInfoItems(AppealInfo appealInfo)
{
RowNumber = appealInfo.RowNumber;
RecordReference = appealInfo.RecordReference;
Appealint = appealInfo.Appealint;
AppealState = appealInfo.AppealState;
ReferenceID = appealInfo.ReferenceID;
AppealTime = appealInfo.AppealTime;
AgentNum = appealInfo.AgentID;
AgentID = AgentNum.ToString();
AgentName = appealInfo.AgentName;
TemplateID = appealInfo.TemplateID;
TemplateName = appealInfo.TemplateName;
Score = appealInfo.Score;
ScoreID = appealInfo.ScoreID;
}
public async Task <APIResult> AppealInfoSearch(int aPId)
{
try
{
string spName = @"up_MBMS_APP_AppealInfoSearch_R";
DynamicParameters dp = new DynamicParameters();
dp.Add("@APId", aPId, DbType.Int32);
using (var conn = new SqlConnection(DapperContext.Current.SqlConnection))
{
conn.Open();
var list = await conn.QueryMultipleAsync(spName, dp, null, null, CommandType.StoredProcedure);
var r1 = list.ReadAsync().Result;
var r2 = list.ReadAsync().Result;
var r3 = list.ReadAsync().Result;
List <AppealInfo> lst = JsonConvert.DeserializeObject <List <AppealInfo> >(JsonConvert.SerializeObject(r1));
List <AttachmentMngDto> lst2 = JsonConvert.DeserializeObject <List <AttachmentMngDto> >(JsonConvert.SerializeObject(r2));
List <AttachmentMngDto> lst3 = JsonConvert.DeserializeObject <List <AttachmentMngDto> >(JsonConvert.SerializeObject(r3));
AppealInfo dto = lst.FirstOrDefault <AppealInfo>();
dto.AttachmentList = lst2;
dto.ApproalAttachList = lst3;
string message = "";
if (lst.Count == 0)
{
message = "没有数据";
}
APIResult result = new APIResult {
Body = CommonHelper.EncodeDto <AppealInfo>(dto), ResultCode = ResultType.Success, Msg = message
};
return(result);
}
}
catch (Exception ex)
{
return(new APIResult {
Body = "", ResultCode = ResultType.Failure, Msg = ex.Message
});
}
}
public async Task <APIResult> AppealInfoReg(AppealInfo param)
{
string AttachmentList = CommonHelper.Serializer(typeof(List <AttachmentMngDto>), param.AttachmentList);
string spName = @"up_MBMS_APP_AppealInfoReg_C";
DynamicParameters dp = new DynamicParameters();
dp.Add("@TPId", param.TPId, DbType.Int32);
dp.Add("@TIId", param.TIId, DbType.Int32);
dp.Add("@AppealContent", param.AppealContent, DbType.String);
dp.Add("@ApprealUserId", param.ApprealUserId, DbType.Int32);
dp.Add("@AttachmentList", AttachmentList, DbType.Xml);
using (var conn = new SqlConnection(DapperContext.Current.SqlConnection))
{
conn.Open();
using (var tran = conn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
{
try
{
await conn.ExecuteAsync(spName, dp, tran, null, CommandType.StoredProcedure);
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
return(new APIResult {
Body = "", ResultCode = ResultType.Failure, Msg = ex.Message
});
}
finally
{
tran.Dispose();
}
}
return(new APIResult {
Body = "", ResultCode = ResultType.Success, Msg = ""
});
}
}
public void QueryAppealInfo(string strCondition, List <DateTimeSpliteAsDay> lstDateTimeSplitAsDay)
{
mListAllAppealInfo.Clear();
mListCurrentAppealItems.Clear();
mListAppealInfoItems = null;
mRecordTotal = 0;
mPageIndex = 0;
mPageCount = 0;
mPageSize = S3105Consts.USER_PARAM_PAGESIZE;
mMaxRecords = S3105Consts.USER_PARAM_MAXRECORDS;
try
{
PanelBasicOpts.IsEnabled = false;
PanelOtherOpts.IsEnabled = false;
SetBusy(true, string.Empty);
mWorker = new BackgroundWorker();
//注册线程主体方法
mWorker.DoWork += (s, de) =>
{
CurrentApp.WriteLog("QueryRecord", string.Format("{0}", strCondition));
WebRequest webRequest = new WebRequest();
webRequest.Session = CurrentApp.Session;
webRequest.Code = (int)S3105Codes.GetAppealInfoData;
webRequest.ListData.Add(strCondition);
//Service31051Client client = new Service31051Client();
Service31051Client client = new Service31051Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session), WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service31051"));
WebReturn webReturn = client.UMPTaskOperation(webRequest);
client.Close();
if (!webReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", webReturn.Code, webReturn.Message));
return;
}
if (webReturn.ListData == null)
{
ShowException(CurrentApp.GetLanguageInfo("3105T00101", string.Format("ListData is null")));
return;
}
if (webReturn.ListData.Count <= 0)
{
SetPageState();
return;
}
for (int i = 0; i < webReturn.ListData.Count; i++)
{
OperationReturn optReturn = XMLHelper.DeserializeObject <AppealInfo>(webReturn.ListData[i]);
if (!optReturn.Result)
{
ShowException(string.Format("Fail.\t{0}\t{1}", optReturn.Code, optReturn.Message));
continue;
}
AppealInfo appealInfo = optReturn.Data as AppealInfo;
if (appealInfo == null)
{
ShowException(CurrentApp.GetLanguageInfo("3105T00101", string.Format("ListData is null")));
return;
}
AppealInfoItems item = new AppealInfoItems(appealInfo);
mRecordTotal = item.RowNumber;
item.Background = GetRecordBackground(item);
if (item.Appealint > 0)
{
item.AppealState = CurrentApp.GetLanguageInfo(string.Format("3105T000{0}", 77 + item.Appealint), item.Appealint.ToString());
}
if (item.AgentNum != 0)
{
item.AgentName = AgentAndUserFullName(item.AgentNum);
item.AgentID = AgentAndUserName(item.AgentNum);
}
mListAllAppealInfo.Add(item);
if (mRecordTotal < mPageSize + 1)
{
AddNewAppealInfo(item);
}
}
SetPageState();
};
//当后台操作已完成、被取消或引发异常时发生
mWorker.RunWorkerCompleted += (s, re) =>
{
mWorker.Dispose();
SetBusy(false, string.Empty);
PanelBasicOpts.IsEnabled = true;
PanelOtherOpts.IsEnabled = true;
};
mWorker.RunWorkerAsync();//触发DoWork事件
}
catch (Exception ex)
{
ShowException(ex.Message);
CurrentApp.WriteOperationLog(S3105Consts.OPT_Query.ToString(), ConstValue.OPT_RESULT_FAIL, "");
}
#region 写操作日志
CurrentApp.WriteOperationLog(S3105Consts.OPT_Query.ToString(), ConstValue.OPT_RESULT_SUCCESS, "");
#endregion
}
public Task <APIResult> AppealInfoReg([FromBody] AppealInfo param)
{
return(_appealMngService.AppealInfoReg(param));
}
