public void OldManMappingServeManRemove(string planId)
{
OldManMappingServeMan oldManMappingServeManRemove = new OldManMappingServeMan();
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string sql = "select UserId,OldManId from Pam_WorkPlan where PlanId='" + planId + "'";
var row = BuilderFactory.DefaultBulder().ExecuteNativeSqlForQuery(sql);
if (row.Count > 0)
{
string oldManId = row[0]["OldManId"].ToString();
string userId = row[0]["UserId"].ToString();
sql = "select * from Pam_WorkPlan where Status=1 and OldManId='" + oldManId + "' and UserId='" + userId + "' ";
int count = BuilderFactory.DefaultBulder().ExecuteNativeSqlForCount(sql);
if (count < 1)
{
oldManMappingServeManRemove.EndTime = DateTime.Now;
oldManMappingServeManRemove.OperatedBy = NormalSession.UserId.ToGuid();
oldManMappingServeManRemove.OperatedOn = DateTime.Now;
oldManMappingServeManRemove.OldManId = oldManId.ToGuid();
oldManMappingServeManRemove.UserId = userId.ToGuid();
statements.Add(new IBatisNetBatchStatement {
StatementName = "OldManMappingServeMan_Remove", ParameterObject = oldManMappingServeManRemove.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
}
SPParam spParam = new { }.ToSPParam();
spParam["OldManId"] = oldManId.ToGuid();
spParam["BatchFlag"] = 0;
BuilderFactory.DefaultBulder().ExecuteSPNoneQuery("SP_Pam_GenDailyWorkExcute", spParam);
}
}
private void OldManMappingServeManAdd(string userId, string oldManIds)
{
OldManMappingServeMan oldManMappingServeManAdd = new OldManMappingServeMan();
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
var arroldManIds = oldManIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arroldManIds.Length > 0)
{
foreach (string arroldManId in arroldManIds)
{
string sql = "select * from Pam_OldManMappingServeMan where EndTime>GETDATE() and OldManId='" + arroldManId + "' and UserId='" + userId + "'";
int count = BuilderFactory.DefaultBulder().ExecuteNativeSqlForCount(sql);
if (count < 1)
{
oldManMappingServeManAdd.OldManId = arroldManId.ToGuid();
oldManMappingServeManAdd.OperatedBy = NormalSession.UserId.ToGuid();
oldManMappingServeManAdd.OperatedOn = DateTime.Now;
oldManMappingServeManAdd.BeginTime = DateTime.Now;
oldManMappingServeManAdd.EndTime = Convert.ToDateTime("2999-12-31 23:59:59");
oldManMappingServeManAdd.UserId = userId.ToGuid();
statements.Add(new IBatisNetBatchStatement {
StatementName = oldManMappingServeManAdd.GetCreateMethodName(), ParameterObject = oldManMappingServeManAdd.ToStringObjectDictionary(false), Type = SqlExecuteType.INSERT
});
}
}
if (statements.Count > 0)
{
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
}
}
}
public ModelInvokeResult <OldManMappingServeManPK> OldManMappingServeManRemove(string strOldManId, string strUserId)
{
ModelInvokeResult <OldManMappingServeManPK> result = new ModelInvokeResult <OldManMappingServeManPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
Guid?_OldManId = strOldManId.ToGuid();
Guid?_UserId = strUserId.ToGuid();
if (_UserId == null || _OldManId == null)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
//作废工作计划是否成功
if (NullifyWorkPlan(strOldManId, strUserId))
{
OldManMappingServeMan oldManMappingServeMan = new OldManMappingServeMan();
/***********************begin 自定义代码*******************/
oldManMappingServeMan.EndTime = DateTime.Now;
oldManMappingServeMan.OperatedBy = NormalSession.UserId.ToGuid();
oldManMappingServeMan.OperatedOn = DateTime.Now;
oldManMappingServeMan.OldManId = _OldManId;
oldManMappingServeMan.UserId = _UserId;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = "OldManMappingServeMan_Remove", ParameterObject = oldManMappingServeMan.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
/***********************begin 自定义代码*******************/
/***********************此处添加自定义代码*****************/
/***********************end 自定义代码*********************/
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
SPParam spParam = new { }.ToSPParam();
spParam["OldManId"] = strOldManId.ToGuid();
spParam["BatchFlag"] = 0;
BuilderFactory.DefaultBulder().ExecuteSPNoneQuery("SP_Pam_GenDailyWorkExcute", spParam);
}
else
{
result.Success = false;
result.ErrorMessage = "工作计划作废失败";
return(result);
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <OldManMappingServeManPK> OldManMappingServeManAdd(string strParms)
{
ModelInvokeResult <OldManMappingServeManPK> result = new ModelInvokeResult <OldManMappingServeManPK> {
Success = true
};
try
{
var dictionary = new StringObjectDictionary().MixInJson(strParms);
string oldManId = dictionary["OldManId"].ToString();
string userIds = dictionary["UserIds"].ToString();
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
/***********************begin 自定义代码*******************/
/***********************end 自定义代码*********************/
string[] arruserIds = userIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arruserIds.Length > 0)
{
foreach (string arruserId in arruserIds)
{
OldManMappingServeMan oldManMappingServeManAdd = new OldManMappingServeMan();
oldManMappingServeManAdd.OldManId = oldManId.ToGuid();
oldManMappingServeManAdd.OperatedBy = NormalSession.UserId.ToGuid();
oldManMappingServeManAdd.OperatedOn = DateTime.Now;
oldManMappingServeManAdd.BeginTime = DateTime.Now;
oldManMappingServeManAdd.EndTime = Convert.ToDateTime("2999-12-31 23:59:59");
oldManMappingServeManAdd.UserId = arruserId.ToGuid();
statements.Add(new IBatisNetBatchStatement {
StatementName = oldManMappingServeManAdd.GetCreateMethodName(), ParameterObject = oldManMappingServeManAdd.ToStringObjectDictionary(false), Type = SqlExecuteType.INSERT
});
}
if (statements.Count > 0)
{
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <OldManMappingServeManPK> OldManMappingServeManChange(string strOldManId, string strUserId, string strUserIdNew)
{
ModelInvokeResult <OldManMappingServeManPK> result = new ModelInvokeResult <OldManMappingServeManPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
Guid?_OldManId = strOldManId.ToGuid();
Guid?_UserId = strUserId.ToGuid();
Guid?_UserIdNew = strUserIdNew.ToGuid();
if (_OldManId == null || _UserId == null || _UserIdNew == null)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
//变更工作计划是否成功
if (ChangeWorkPlan(strOldManId, strUserId, strUserIdNew))
{
OldManMappingServeMan oldManMappingServeManRemove = new OldManMappingServeMan();
/***********************作废原来的关系*******************/
oldManMappingServeManRemove.EndTime = DateTime.Now;
oldManMappingServeManRemove.OperatedBy = NormalSession.UserId.ToGuid();
oldManMappingServeManRemove.OperatedOn = DateTime.Now;
oldManMappingServeManRemove.OldManId = _OldManId;
oldManMappingServeManRemove.UserId = _UserId;
statements.Add(new IBatisNetBatchStatement {
StatementName = "OldManMappingServeMan_Remove", ParameterObject = oldManMappingServeManRemove.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
/***********************作废原来的关系*******************/
/***********************新增新的关系*****************/
OldManMappingServeMan oldManMappingServeManAdd = new OldManMappingServeMan();
oldManMappingServeManAdd.OldManId = _OldManId;
oldManMappingServeManAdd.OperatedBy = NormalSession.UserId.ToGuid();
oldManMappingServeManAdd.OperatedOn = DateTime.Now;
oldManMappingServeManAdd.BeginTime = DateTime.Now;
oldManMappingServeManAdd.EndTime = Convert.ToDateTime("2999-12-31 23:59:59");
oldManMappingServeManAdd.UserId = _UserIdNew;
statements.Add(new IBatisNetBatchStatement {
StatementName = oldManMappingServeManAdd.GetCreateMethodName(), ParameterObject = oldManMappingServeManAdd.ToStringObjectDictionary(false), Type = SqlExecuteType.INSERT
});
/***********************end 新增新的关系*********************/
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
SPParam spParam = new { }.ToSPParam();
spParam["OldManId"] = strOldManId.ToGuid();
spParam["BatchFlag"] = 0;
BuilderFactory.DefaultBulder().ExecuteSPNoneQuery("SP_Pam_GenDailyWorkExcute", spParam);
}
else
{
result.Success = false;
result.ErrorMessage = "工作计划作废失败";
return(result);
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
