public InvokeResult NullifySelected(string strPlanIds)
{
InvokeResult result = new InvokeResult {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string[] arrPlanIds = strPlanIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arrPlanIds.Length == 0)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
string statementName = new WorkPlan().GetUpdateMethodName();
foreach (string strPlanId in arrPlanIds)
{
WorkPlan workPlan = new WorkPlan {
PlanId = strPlanId.ToGuid(), Status = 0
};
/***********************begin 自定义代码*******************/
workPlan.OperatedBy = NormalSession.UserId.ToGuid();
workPlan.OperatedOn = DateTime.Now;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = statementName, ParameterObject = workPlan.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
}
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public bool NullifyWorkPlan(string strOldManId, string strUserId)
{
bool result = false;
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
Guid?_OldManId = strOldManId.ToGuid();
Guid?_UserId = strUserId.ToGuid();
if (_UserId == null || _OldManId == null)
{
result = false;
return(result);
}
WorkPlan workPlan = new WorkPlan();
/***********************begin 自定义代码*******************/
workPlan.Status = 0;
workPlan.OperatedBy = NormalSession.UserId.ToGuid();
workPlan.OperatedOn = DateTime.Now;
workPlan.UserId = _UserId;
workPlan.OldManId = _OldManId;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = "NullifyWorkPlan_Update", ParameterObject = workPlan.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
result = true;
/***********************end 自定义代码*********************/
}
catch (Exception ex)
{
result = false;
}
return(result);
}
public ModelInvokeResult <WorkPlanPK> NullifyWorkPlan(WorkPlan workPlan)
{
ModelInvokeResult <WorkPlanPK> result = new ModelInvokeResult <WorkPlanPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
/***********************begin 自定义代码*******************/
workPlan.Status = 0;
workPlan.OperatedBy = NormalSession.UserId.ToGuid();
workPlan.OperatedOn = DateTime.Now;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = "NullifyWorkPlan_Update", ParameterObject = workPlan.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
/***********************begin 自定义代码*******************/
if (workPlan.UserId == null && workPlan.OldManId == null)
{
result.Success = false;
result.ErrorMessage = "操作对象不能为空,工作计划作废失败";
}
else
{
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
}
/***********************end 自定义代码*********************/
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <WorkPlanPK> Nullify(string strPlanId)
{
ModelInvokeResult <WorkPlanPK> result = new ModelInvokeResult <WorkPlanPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
Guid?_PlanId = strPlanId.ToGuid();
if (_PlanId == null)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
WorkPlan workPlan = new WorkPlan {
PlanId = _PlanId, Status = 0
};
/***********************begin 自定义代码*******************/
workPlan.OperatedBy = NormalSession.UserId.ToGuid();
workPlan.OperatedOn = DateTime.Now;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = workPlan.GetUpdateMethodName(), ParameterObject = workPlan.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
/***********************begin 自定义代码*******************/
/***********************此处添加自定义代码*****************/
/***********************end 自定义代码*********************/
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
result.instance = new WorkPlanPK {
PlanId = _PlanId
};
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <WorkPlanPK> Create(WorkPlan workPlan)
{
ModelInvokeResult <WorkPlanPK> result = new ModelInvokeResult <WorkPlanPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
if (workPlan.PlanId == GlobalManager.GuidAsAutoGenerate)
{
workPlan.PlanId = Guid.NewGuid();
}
/***********************begin 自定义代码*******************/
workPlan.OperatedBy = NormalSession.UserId.ToGuid();
workPlan.OperatedOn = DateTime.Now;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = workPlan.GetCreateMethodName(), ParameterObject = workPlan.ToStringObjectDictionary(false), Type = SqlExecuteType.INSERT
});
/***********************begin 自定义代码*******************/
/***********************此处添加自定义代码*****************/
/***********************end 自定义代码*********************/
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
result.instance = new WorkPlanPK {
PlanId = workPlan.PlanId
};
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <WorkPlanPK> CreateWorkPlanS(string oldManIds, WorkPlan workPlan)
{
ModelInvokeResult <WorkPlanPK> result = new ModelInvokeResult <WorkPlanPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
if (workPlan.PlanId == GlobalManager.GuidAsAutoGenerate)
{
workPlan.PlanId = Guid.NewGuid();
}
/***********************begin 自定义代码*******************/
workPlan.OperatedBy = NormalSession.UserId.ToGuid();
workPlan.OperatedOn = DateTime.Now;
/***********************end 自定义代码*********************/
var arroldManIds = oldManIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arroldManIds.Length < 1)
{
result.Success = false;
result.ErrorMessage = "请选择老人";
return(result);
}
/***********************检查是否已经存在此项工作计划*********************/
foreach (string arroldManId in arroldManIds)
{
string sql = "";
//string sql = "select * from Pam_WorkPlan where OldManId='" + arroldManId + "' and UserId='" + workPlan.UserId + "' and WorkItem='" + workPlan.WorkItem + "' and PlanSchedule='" + workPlan.PlanSchedule + "'";
int i = BuilderFactory.DefaultBulder().ExecuteNativeSqlForCount(sql);
if (i > 0)
{
result.Success = false;
result.ErrorMessage = "此项工作计划已经存在";
return(result);
}
}
/***********************检查是否已经存在此项工作计划*********************/
foreach (string arroldManId in arroldManIds)
{
workPlan.OldManId = arroldManId.ToGuid();
workPlan.PlanId = Guid.NewGuid();
statements.Add(new IBatisNetBatchStatement {
StatementName = workPlan.GetCreateMethodName(), ParameterObject = workPlan.ToStringObjectDictionary(false), Type = SqlExecuteType.INSERT
});
}
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
result.instance = new WorkPlanPK {
PlanId = workPlan.PlanId
};
if (result.Success)
{
/***********************如果老人和服务人员没有建立关系，这里建立关系*********************/
OldManMappingServeManAdd(workPlan.UserId.ToString(), oldManIds);
/***********************如果老人和服务人员没有建立关系，这里建立关系*********************/
/***********************重新生成工作执行表*********************/
foreach (string arroldManId in arroldManIds)
{
SPParam spParam = new { }.ToSPParam();
spParam["OldManId"] = arroldManId.ToGuid();
spParam["BatchFlag"] = 0;
BuilderFactory.DefaultBulder().ExecuteSPNoneQuery("SP_Pam_GenDailyWorkExcute", spParam);
}
}
/***********************重新生成工作执行表*********************/
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <WorkPlanPK> Update(string strPlanId, WorkPlan workPlan)
{
ModelInvokeResult <WorkPlanPK> result = new ModelInvokeResult <WorkPlanPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
Guid?_PlanId = strPlanId.ToGuid();
if (_PlanId == null)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
workPlan.PlanId = _PlanId;
/***********************begin 自定义代码*******************/
workPlan.OperatedBy = NormalSession.UserId.ToGuid();
workPlan.OperatedOn = DateTime.Now;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = workPlan.GetUpdateMethodName(), ParameterObject = workPlan.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
/***********************begin 自定义代码*******************/
/***********************此处添加自定义代码*****************/
/***********************end 自定义代码*********************/
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
result.instance = new WorkPlanPK {
PlanId = _PlanId
};
if (result.Success)
{
SPParam spParam = new { }.ToSPParam();
spParam["OldManId"] = workPlan.OldManId;
spParam["BatchFlag"] = 0;
BuilderFactory.DefaultBulder().ExecuteSPNoneQuery("SP_Pam_GenDailyWorkExcute", spParam);
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}