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 <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);
}
public ModelInvokeResult <EvaluatedReportPK> Nullify(string strReportId)
{
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 evaluatedReport = new EvaluatedReport {
ReportId = _ReportId, Status = 0
};
/***********************begin 自定义代码*******************/
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);
}
