/// <summary>
/// 没有明细时判断SubjectMst表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DeletedResult Delete2(long id)
{
var deletedresult = new DeletedResult();
try
{
QtBaseProjectModel qtBaseProjectModel = base.Find(id).Data;
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("FProjCode", qtBaseProjectModel.FProjCode)).
Add(ORMRestrictions <string> .Eq("FYear", qtBaseProjectModel.FYear));
IList <SubjectMstModel> subjectMstModels = SubjectMstFacade.Find(dicWhere).Data;
for (var i = 0; i < subjectMstModels.Count; i++)
{
GHSubjectModel gHSubjectModel = GHSubjectFacade.Find(subjectMstModels[i].Mstphid).Data;
if (gHSubjectModel.FApproveStatus != "1")
{
deletedresult.Status = ResponseStatus.Error;
deletedresult.Msg = "有数据处于审批流程当中，无法删除！";
return(deletedresult);
}
}
deletedresult = base.Delete(id);
}
catch (Exception ex)
{
deletedresult.Status = ResponseStatus.Error;
deletedresult.Msg = ex.Message.ToString();
}
return(deletedresult);
}
public string PostDelete([FromBody] InfoBaseModel <List <long> > phids)
{
var deletedresult = new DeletedResult();
if (phids.infoData.Count > 0)
{
List <long> usePhids = BankAccountService.judgeIfUse(phids.infoData);
if (usePhids.Count > 0)
{
string Msg = "银行账户名称为";
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PhId", usePhids));
IList <BankAccountModel> bankAccounts = BankAccountService.Find(dic).Data;
foreach (BankAccountModel bankAccount in bankAccounts)
{
Msg = Msg + bankAccount.FBankname + ",";
}
Msg = Msg.Substring(0, Msg.Length - 1) + "已被引用不能删除";
deletedresult.Status = ResponseStatus.Error;
deletedresult.Msg = Msg;
}
else
{
for (var i = 0; i < phids.infoData.Count; i++)
{
deletedresult = BankAccountService.Delete <System.Int64>(phids.infoData[i]);
//BankAccountService.Find(t => phids.infoData.Contains(t.PhId));
}
}
}
return(DataConverterHelper.SerializeObject(deletedresult));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DeletedResult DeleteAddinOperator(long id)
{
var result = AddinOperatorRule.Delete <Int64>(id);
DeletedResult dresult = new DeletedResult();
dresult.DelRows = result;
dresult.Status = "success"; //返回状态
return(dresult);
}
/// <summary>
/// 根据岗位主键集合删除岗位与岗位对应操作员信息
/// </summary>
/// <param name="phidList">岗位主键集合</param>
/// <param name="uCode">用户账号</param>
/// <returns></returns>
public DeletedResult DeletedPostOpers(List <long> phidList, string uCode)
{
DeletedResult deletedResult = new DeletedResult();
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PostPhid", phidList));
var record = this.GAppvalRecordFacade.Find(dic).Data;
if (record.Count > 0)
{
throw new Exception("此岗位已被审批使用，无法进行删除！");
}
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PostPhid", phidList));
var procPost = this.GAppvalProc4PostFacade.Find(dic).Data;
if (procPost.Count > 0)
{
throw new Exception("此岗位已被流程使用，无法进行删除！");
}
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PhId", phidList))
.Add(ORMRestrictions <byte> .Eq("IsSystem", (byte)1));
var sysPosts = this.GAppvalPostFacade.Find(dic).Data;
if (sysPosts.Count > 0 && uCode != "Admin")
{
throw new Exception("内置岗位普通操作员不能进行删除！");
}
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PhId", phidList));
var posts = this.GAppvalPostFacade.Find(dic).Data;
if (posts.Count > 0)
{
deletedResult = this.GAppvalPostFacade.Delete(dic);
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PostPhid", phidList));
var opers = this.GAppvalPost4OperFacade.Find(dic).Data;
if (opers.Count > 0)
{
deletedResult = this.GAppvalPost4OperFacade.Delete(dic);
}
}
return(deletedResult);
}
///// <summary>
///// 方法实例
///// </summary>
///// <returns></returns>
//public List<MethodAroundMstModel> ExampleMethod<MethodAroundMstModel>(string param)
//{
// //编写代码
//}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DeletedResult DeleteMethodAround(long id)
{
var result = MethodAroundMstRule.Delete <Int64>(id);
AssemblyRule.DeleteByForeignKey <Int64>(id);
SqlRule.DeleteByForeignKey <Int64>(id);
ExpRule.DeleteByForeignKey <Int64>(id);
ExpVarRule.DeleteByForeignKey <Int64>(id);
DeletedResult dresult = new DeletedResult();
dresult.DelRows = result;
dresult.Status = "success"; //返回状态
return(dresult);
}
/// <summary>
/// 删除审批类型
/// </summary>
/// <param name="proc_phid">审批类型id</param>
/// <returns></returns>
public DeletedResult PostDeleteProcType(long proc_phid)
{
if (proc_phid == 0)
{
return(null);
}
IList <GAppvalProcModel> procModels = GAppvalProcFacade.Find(t => t.SPLXPhid == proc_phid).Data;
//批量删除审批流程
GAppvalProcFacade.DeleteAppvalProc(procModels);
DeletedResult deletedResult = QTSysSetFacade.Delete(proc_phid);
return(deletedResult);
}
///// <summary>
///// 方法实例
///// </summary>
///// <returns></returns>
//public List<ExtendFunctionMstModel> ExampleMethod<ExtendFunctionMstModel>(string param)
//{
// //编写代码
//}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DeletedResult DeleteExtendFunc(long id)
{
var result = ExtendFunctionMstRule.Delete <Int64>(id);
assemblyRule.DeleteByForeignKey <Int64>(id);
sqlRule.DeleteByForeignKey <Int64>(id);
DeletedResult dresult = new DeletedResult();
dresult.DelRows = result;
dresult.Status = "success"; //返回状态
//刷新缓存配置
executor.RefreshConfigure();
return(dresult);
}
public string PostDeleteProcType([FromBody] ProcRequestModel requestModel)
{
if (requestModel == null || requestModel.ApprovalTypeIds == null || requestModel.ApprovalTypeIds.Count == 0)
{
return(DCHelper.ErrorMessage("审批类型id为空！"));
}
try
{
//判断审批流程是否被引用
foreach (long id in requestModel.ApprovalTypeIds)
{
bool symbol = GAppvalProcService.ProcIsUsed(id);
//bool symbol = GAppvalProcService.ProcIsUsed(requestModel.ApprovalTypeId);
if (symbol)
{
return(DCHelper.ErrorMessage("删除失败,已有审批流程被引用！"));
}
var procs = this.GAppvalProcService.Find(t => t.SPLXPhid == id).Data;
if (procs != null && procs.Count > 0)
{
throw new Exception("此类型下已存在审批流，不能删除此审批流类型！");
}
}
DeletedResult deletedResult = GAppvalProcService.PostDeleteProcTypes(requestModel.ApprovalTypeIds);
if (deletedResult != null && deletedResult.DelRows > 0)
{
return(DCHelper.SuccessMessage("删除成功！"));
}
else
{
return(DCHelper.ErrorMessage("删除失败！"));
}
}
catch (Exception e) {
return(DCHelper.ErrorMessage(e.Message));
}
}
/// <summary>
/// 批量删除审批类型
/// </summary>
/// <param name="ids">审批类型id集合</param>
/// <returns></returns>
public DeletedResult PostDeleteProcTypes(List <long> ids)
{
if (ids == null || ids.Count == 0)
{
return(null);
}
foreach (long proc_phid in ids)
{
IList <GAppvalProcModel> procModels = GAppvalProcFacade.Find(t => t.SPLXPhid == proc_phid).Data;
//批量删除审批流程
GAppvalProcFacade.DeleteAppvalProc(procModels);
}
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <List <long> > .In("PhId", ids));
DeletedResult deletedResult = QTSysSetFacade.Delete(dicWhere);
return(deletedResult);
}
/// <summary>
/// 删除收入预算数据
/// </summary>
/// <param name="phid">收入预算主键</param>
/// <returns></returns>
public DeletedResult SaveDelete(long phid)
{
DeletedResult deletedResult = new DeletedResult();
var ysIncomes = this.YsIncomeMstFacade.Find(t => t.PhId == phid).Data;
if (ysIncomes != null && ysIncomes.Count == 1)
{
//未上报，未送审，未生成预算的数据才能删除
if (ysIncomes[0].FApproval == (byte)0 && ysIncomes[0].FIsbudget == (byte)0 && ysIncomes[0].FIsreport == (byte)0)
{
ysIncomes[0].PersistentState = PersistentState.Deleted;
deletedResult = this.YsIncomeMstFacade.Delete <long>(ysIncomes[0].PhId);//删除主从表数据
}
else
{
throw new Exception("只有未上报，未送审以及未生成预算的收入预算才能删除！");
}
}
else
{
throw new Exception("传递的收入预算主键有误！");
}
return(deletedResult);
}
/// <summary>
/// 是否为申报单位的设置
/// </summary>
/// <returns>返回Json串</returns>
public CommonResult <CorrespondenceSettings2Model> UpdateIfSBOrg(List <OrganizeModel> models, List <CorrespondenceSettings2Model> DeleteData, List <OrganizeModel> InsertData)
{
//末级组织保存对应关系
string OrgCode;
string OrgPhId;
var selectresult = new PagedResult <CorrespondenceSettings2Model>();
CommonResult <CorrespondenceSettings2Model> result = new CommonResult <CorrespondenceSettings2Model>();
if (models != null && models.Count > 0)
{
for (int i = 0; i < models.Count; i++)
{
var dicWhere = new Dictionary <string, object>();
OrganizeModel organize = models[i];
OrgCode = organize.OCode;
OrgPhId = organize.PhId.ToString();
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("Dwdm", OrgCode)).
Add(ORMRestrictions <string> .Eq("Dydm", OrgCode)).
Add(ORMRestrictions <string> .Eq("Dylx", "ZC")).
Add(ORMRestrictions <string> .Eq("DefStr2", OrgPhId));
selectresult = base.ServiceHelper.LoadWithPageInfinity("GQT3.QT.DYGX2_All", dicWhere);
if (selectresult.TotalItems == 0)
{
try
{
CorrespondenceSettings2Model correspondence = new CorrespondenceSettings2Model();
correspondence.PersistentState = SUP.Common.Base.PersistentState.Added;
correspondence.Dwdm = OrgCode;
correspondence.Dydm = OrgCode;
correspondence.Dylx = "ZC";
correspondence.DefStr2 = OrgPhId;
SavedResult <Int64> savedResult = base.Save <Int64>(correspondence, "");
}
catch (Exception e)
{
result.Status = ResponseStatus.Error;
result.Msg = "设置失败，请重新设置！";
return(result);
}
}
}
}
long Deleteid; //主表主键
if (DeleteData != null && DeleteData.Count > 0)
{
for (int i = 0; i < DeleteData.Count; i++)
{
CorrespondenceSettings2Model delete = DeleteData[i];
Deleteid = delete.PhId;
try
{
//判断当前组织是否在项目中被使用，如果使用则不能删除
Dictionary <string, object> where1 = new Dictionary <string, object>();
new CreateCriteria(where1).Add(ORMRestrictions <string> .Eq("FDeclarationUnit", delete.Dwdm));
FindedResults <ProjectMstModel> findedResults = ProjectMstFacade.Find(where1);
if (findedResults.Data.Count > 0)
{
result.Status = ResponseStatus.Error;
result.Msg = "设置失败，组织已被引用！";
return(result);
}
else
{
Dictionary <string, object> where2 = new Dictionary <string, object>();
new CreateCriteria(where2).Add(ORMRestrictions <string> .Eq("FOcode", delete.Dwdm));
DeletedResult deletedResult = BudgetProcessCtrlFacade.Delete(where2);
}
base.Delete <System.Int64>(Deleteid);
}
catch (Exception e)
{
result.Status = ResponseStatus.Error;
result.Msg = "设置失败，请重新设置！";
return(result);
}
}
}
if (InsertData != null && InsertData.Count > 0)
{
for (int i = 0; i < InsertData.Count; i++)
{
OrganizeModel insertorganize = InsertData[i];
var insertOrgCode = insertorganize.OCode;
var insertOrgPhId = insertorganize.PhId.ToString();
try
{
CorrespondenceSettings2Model correspondence2 = new CorrespondenceSettings2Model();
correspondence2.PersistentState = SUP.Common.Base.PersistentState.Added;
correspondence2.Dwdm = insertOrgCode;
correspondence2.Dylx = "SB";
correspondence2.DefStr2 = insertOrgPhId;
SavedResult <Int64> savedResult2 = base.Save <Int64>(correspondence2, "");
//向预算进度控制表添加相应的记录
Dictionary <string, object> where1 = new Dictionary <string, object>();
new CreateCriteria(where1).Add(ORMRestrictions <string> .Eq("FOcode", insertorganize.OCode));
FindedResults <BudgetProcessCtrlModel> findedResults = BudgetProcessCtrlFacade.Find(where1);
//判断进度表中是否已经存在
if (findedResults.Data.Count == 0)
{
List <BudgetProcessCtrlModel> budgetProcessList = new List <BudgetProcessCtrlModel>();
Dictionary <string, object> where2 = new Dictionary <string, object>();
Dictionary <string, object> where3 = new Dictionary <string, object>();
Dictionary <string, object> where4 = new Dictionary <string, object>();
new CreateCriteria(where2).Add(ORMRestrictions <Int64> .Eq("ParentOrgId", insertorganize.PhId));
new CreateCriteria(where3).Add(ORMRestrictions <string> .Eq("OCode", insertorganize.OCode));
new CreateCriteria(where4).Add(ORMRestrictions.Or(where2, where3));
List <OrganizeModel> organizeList = OrganizationFacade.Find(where4).Data.ToList();
//获得组织对象,前端传过来的组织对象可能没有组织名称
OrganizeModel organizeModel = organizeList.Find(t => t.IfCorp == "Y");
if (organizeList.Count > 1)
{
for (int j = 0; j < organizeList.Count; j++)
{
if ("N".Equals(organizeList[j].IfCorp))
{
BudgetProcessCtrlModel budgetProcessCtrlModel = new BudgetProcessCtrlModel();
budgetProcessCtrlModel.PersistentState = PersistentState.Added;
budgetProcessCtrlModel.FOcode = organizeModel.OCode;
budgetProcessCtrlModel.FOname = organizeModel.OName;
budgetProcessCtrlModel.FDeptCode = organizeList[j].OCode;
budgetProcessCtrlModel.FDeptName = organizeList[j].OName;
budgetProcessCtrlModel.FProcessStatus = "1";
budgetProcessList.Add(budgetProcessCtrlModel);
}
}
}
else
{
BudgetProcessCtrlModel budgetProcessCtrlModel = new BudgetProcessCtrlModel();
budgetProcessCtrlModel.PersistentState = PersistentState.Added;
budgetProcessCtrlModel.FOcode = organizeModel.OCode;
budgetProcessCtrlModel.FOname = organizeModel.OName;
budgetProcessCtrlModel.FProcessStatus = "1";
budgetProcessList.Add(budgetProcessCtrlModel);
}
BudgetProcessCtrlFacade.Save <Int64>(budgetProcessList);
}
}
catch (Exception e)
{
result.Status = ResponseStatus.Error;
result.Msg = "设置失败，请重新设置！";
return(result);
}
}
}
return(result);
}
