public InvokeResult CreateEvaluatedReport(EvaluatedReport evaluatedReport)
{
InvokeResult result = new InvokeResult {
Success = true
};
try
{
var spParam = evaluatedReport.ToSPParam();
spParam["OperatedBy"] = Guid.Parse(NormalSession.UserId);
spParam["DataSource"] = GlobalManager.DIKey_00012_ManualEdit;
BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteSPNoneQuery("SP_Eva_AddAssessmentReportOrder", spParam);
if (spParam.ErrorCode != 0)
{
result.ErrorCode = spParam.ErrorCode;
result.ErrorMessage = spParam.ErrorMessage;
}
else
{
result.ErrorMessage = spParam.ErrorMessage;
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <EvaluatedReportPK> Update(string strReportId, EvaluatedReport evaluatedReport)
{
ModelInvokeResult <EvaluatedReportPK> result = new ModelInvokeResult <EvaluatedReportPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
Guid?_ReportId = strReportId.ToGuid();
if (_ReportId == null)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
evaluatedReport.ReportId = _ReportId;
/***********************begin 自定义代码*******************/
//社区审核
if (evaluatedReport.CommunityChecker == GlobalManager.GuidAsAutoGenerate)
{
evaluatedReport.CommunityChecker = NormalSession.UserId.ToGuid();
}
else if (evaluatedReport.StreetExaminer == GlobalManager.GuidAsAutoGenerate)
{//街道审核
evaluatedReport.StreetExaminer = NormalSession.UserId.ToGuid();
}
else if (evaluatedReport.CityApproval == GlobalManager.GuidAsAutoGenerate)
{//市民政审核
evaluatedReport.CityApproval = NormalSession.UserId.ToGuid();
}
else
{
evaluatedReport.OperatedBy = NormalSession.UserId.ToGuid();
evaluatedReport.OperatedOn = DateTime.Now;
}
evaluatedReport.DataSource = GlobalManager.DIKey_00012_ManualEdit;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = evaluatedReport.GetUpdateMethodName(), ParameterObject = evaluatedReport.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
/***********************begin 自定义代码*******************/
/***********************此处添加自定义代码*****************/
/***********************end 自定义代码*********************/
BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements);
result.instance = new EvaluatedReportPK {
ReportId = _ReportId
};
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public InvokeResult UpdateEvaluatedPrintNo(string strReportIds)
{
InvokeResult result = new InvokeResult {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
List <string> sqlParamsList = new List <string>();
Guid? _ReportId;
string[] reportIdArr = strReportIds.Split('|');
for (int i = 0; i < reportIdArr.Length; i++)
{
_ReportId = reportIdArr[i].ToGuid();
if (_ReportId != null)
{
sqlParamsList.Add(string.Format("'{0}'", reportIdArr[i]));
}
}
var evaluatedReportList = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlForQuery("select ReportId,PrintNo from Eva_EvaluatedReport where ReportId in(" + string.Join(" , ", sqlParamsList.ToArray()) + ")");
EvaluatedReport evaluatedReport;
foreach (var item in evaluatedReportList)
{
evaluatedReport = new EvaluatedReport();
evaluatedReport.ReportId = item["ReportId"].ToString().ToGuid();
evaluatedReport.PrintNo = (item["PrintNo"] != null ? int.Parse(item["PrintNo"].ToString()) : 0) + 1;
statements.Add(new IBatisNetBatchStatement {
StatementName = evaluatedReport.GetUpdateMethodName(), ParameterObject = evaluatedReport.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
}
BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements);
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public InvokeResult NullifySelected(string strReportIds)
{
InvokeResult result = new InvokeResult {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string[] arrReportIds = strReportIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arrReportIds.Length == 0)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
string statementName = new EvaluatedReport().GetUpdateMethodName();
foreach (string strReportId in arrReportIds)
{
EvaluatedReport evaluatedReport = new EvaluatedReport {
ReportId = strReportId.ToGuid(), Status = 0
};
/***********************begin 自定义代码*******************/
evaluatedReport.OperatedBy = NormalSession.UserId.ToGuid();
evaluatedReport.OperatedOn = DateTime.Now;
evaluatedReport.DataSource = GlobalManager.DIKey_00012_ManualEdit;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = statementName, ParameterObject = evaluatedReport.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
}
BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements);
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <EvaluatedReport> BuildEvaluatedReport(EvaluatedReport evaluatedReport)
{
ModelInvokeResult <EvaluatedReport> result = new ModelInvokeResult <EvaluatedReport> {
Success = true
};
try
{
var spParam = evaluatedReport.ToSPParam();
spParam["OperatedBy"] = Guid.Parse(NormalSession.UserId);
spParam["DataSource"] = GlobalManager.DIKey_00012_ManualEdit;
BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteSPNoneQuery("SP_Eva_AddAssessmentReportOrder", spParam);
if (spParam.ErrorCode == 0)
{
Guid?_ReportId = spParam.ErrorMessage.ToGuid();
if (_ReportId == null)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
result.instance = BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).Load <EvaluatedReport, EvaluatedReportPK>(new EvaluatedReportPK {
ReportId = _ReportId
});
}
else
{
result.ErrorCode = spParam.ErrorCode;
result.ErrorMessage = spParam.ErrorMessage;
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public InvokeResult DeleteSelected(string strReportIds)
{
InvokeResult result = new InvokeResult {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string[] arrReportIds = strReportIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arrReportIds.Length == 0)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
string statementName = new EvaluatedReport().GetDeleteMethodName();
foreach (string strReportId in arrReportIds)
{
EvaluatedReportPK pk = new EvaluatedReportPK {
ReportId = strReportId.ToGuid()
};
DeleteCascade(statements, pk);
statements.Add(new IBatisNetBatchStatement {
StatementName = statementName, ParameterObject = pk, Type = SqlExecuteType.DELETE
});
}
BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements);
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <EvaluatedReportPK> Create(EvaluatedReport evaluatedReport)
{
ModelInvokeResult <EvaluatedReportPK> result = new ModelInvokeResult <EvaluatedReportPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
if (evaluatedReport.ReportId == GlobalManager.GuidAsAutoGenerate)
{
evaluatedReport.ReportId = Guid.NewGuid();
}
/***********************begin 自定义代码*******************/
evaluatedReport.OperatedBy = NormalSession.UserId.ToGuid();
evaluatedReport.OperatedOn = DateTime.Now;
evaluatedReport.DataSource = GlobalManager.DIKey_00012_ManualEdit;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = evaluatedReport.GetCreateMethodName(), ParameterObject = evaluatedReport.ToStringObjectDictionary(false), Type = SqlExecuteType.INSERT
});
/***********************begin 自定义代码*******************/
/***********************此处添加自定义代码*****************/
/***********************end 自定义代码*********************/
BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements);
result.instance = new EvaluatedReportPK {
ReportId = evaluatedReport.ReportId
};
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
