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); }