public void Delete(ORGEntity DefineDelete) { var allenum = SelectList(new ORGEntity()); //已经有下级的部门不能删除 foreach (var data in allenum) { if (data.ORGCODE.Length > DefineDelete.ORGCODE.Length) { var dataOrgcode = data.ORGCODE.Substring(0, DefineDelete.ORGCODE.Length); if ((data.ORGCODE != DefineDelete.ORGCODE) && (dataOrgcode == DefineDelete.ORGCODE)) { throw new LogicException($"当前部门级次已经有下级不能删除!"); } } ; } ; //已经使用的部门通过外键控制 var v = GetVerify(DefineDelete); v.Require(a => a.ORGID); v.Verify(); CommenDelete(DefineDelete); }
//public void Fun2(BMEntity bm) //{ //} public void Save1(ORGEntity ORG) { var v = GetVerify(ORG); v.Require(a => a.ORGID); v.IsNumber(a => a.ORGID); v.IsUnique(a => a.ORGCODE); v.Verify(); CommonSave(ORG); }
public void Org_Update(string ID, int BRANCHID) { ORGEntity Data = new ORGEntity { ORGID = ID }; ORGEntity org = DbHelper.Select(Data); string sqlUpdate = $@"update ORG set BRANCHID=" + BRANCHID + " where ORGCODE like '" + org.ORGCODE + "%'"; DbHelper.ExecuteNonQuery(sqlUpdate); }
public string Save(string Tar, string Key, ORGEntity DefineSave) { var allenum = SelectList(new ORGEntity()); string newkey = TreeModel.GetNewKey(allenum, a => a.ORGCODE, Key, Tar); DefineSave.ORGCODE = newkey; //当前数据有下级,并且当前数据要修改为末级,那么提示不让修改保存成功 if (((Tar == null) || (Tar == " ")) && (DefineSave.LEVEL_LAST == ((int)末级标记.末级).ToString())) { foreach (var data in allenum) { if (data.ORGCODE.Length > DefineSave.ORGCODE.Length) { var dataOrgcode = data.ORGCODE.Substring(0, DefineSave.ORGCODE.Length); if ((data.ORGCODE != DefineSave.ORGCODE) && (dataOrgcode == DefineSave.ORGCODE)) { throw new LogicException("当前组织已经有下级数据不能修改为末级!"); } } } } ; //同一级次已经有核算部门不能在设置为核算部门 foreach (var data in allenum) { if ((data.ORGCODE.Length < DefineSave.ORGCODE.Length) && (data.ORG_TYPE == ((int)部门类型.核算部门).ToString())) //代码长度小于当前长度并且其是核算部门 { var dataOrgcode = DefineSave.ORGCODE.Substring(0, data.ORGCODE.Length); if ((data.ORGCODE != DefineSave.ORGCODE) && (dataOrgcode == data.ORGCODE) && (DefineSave.ORG_TYPE == ((int)部门类型.核算部门).ToString()) ) { throw new LogicException($"当前级次组织上({data.ORGCODE})已经拥有了核算类型的组织!"); } } ; if ((data.ORGCODE.Length > DefineSave.ORGCODE.Length) && (data.ORG_TYPE == ((int)部门类型.核算部门).ToString())) //代码长度大于当前长度并且其是核算部门 { var dataOrgcode = data.ORGCODE.Substring(0, DefineSave.ORGCODE.Length); if ((data.ORGCODE != DefineSave.ORGCODE) && (dataOrgcode == DefineSave.ORGCODE) && (DefineSave.ORG_TYPE == ((int)部门类型.核算部门).ToString()) ) { throw new LogicException($"当前级次组织上({data.ORGCODE})已经拥有了核算类型的组织!"); } } ; } if (DefineSave.ORGID.IsEmpty()) { DefineSave.ORGID = service.CommonService.NewINC("ORG"); } var v = GetVerify(DefineSave); v.Require(a => a.ORGNAME); v.IsUnique(a => a.ORGNAME); v.Require(a => a.ORG_TYPE); v.Require(a => a.LEVEL_LAST); v.Require(a => a.VOID_FLAG); v.Verify(); if ((Tar == "xj") && (Key != null)) { DefineSave.BRANCHID = service.XtglService.Org_BRANCHID(Key); } CommonSave(DefineSave); return(newkey); }
public string SaveContract(CONTRACTEntity SaveData) { var v = GetVerify(SaveData); if (SaveData.STYLE.ToInt() != (int)核算方式.多经点位) { ORGEntity org = DbHelper.Select(new ORGEntity() { ORGID = SaveData.ORGID }); if (org.BRANCHID != SaveData.BRANCHID) { throw new LogicException($"请核对招商部门与分店之间的关系!"); } ; //选择是扣点的时候,不应该有保底数据 if ((SaveData.OPERATERULE.ToInt() == (int)联营合同合作方式.扣点) && (SaveData.STYLE.ToInt() == (int)核算方式.联营合同)) { foreach (var rent in SaveData.CONTRACT_RENT) { if (rent.RENTS.ToDecimal() != 0) { throw new LogicException($"扣点形式的合同不应该有保底值!"); } if (rent.RENTS_JSKL.ToDecimal() != 0) { throw new LogicException($"扣点形式的合同不应该有保底扣率!"); } } } } if (SaveData.CONTRACT_OLD.IsEmpty()) { SaveData.HTLX = ((int)合同类型.原始合同).ToString(); } else { SaveData.HTLX = ((int)合同类型.变更合同).ToString(); } if (SaveData.CONTRACTID.IsEmpty()) // 合同号规则:核算方式(1租赁2联营)+门店(2位)+5位流水 变更合同 9开头 { string tblname; int leadCode; if (SaveData.HTLX == "1") { leadCode = (SaveData.STYLE + SaveData.BRANCHID.PadLeft(2, '0')).ToInt(); } else { leadCode = ("9" + SaveData.BRANCHID.PadLeft(2, '0')).ToInt(); } tblname = "CONTRACT_" + leadCode.ToString(); SaveData.CONTRACTID = (NewINC(tblname).ToInt() + leadCode * 100000).ToString(); SaveData.STATUS = ((int)合同状态.未审核).ToString(); } else { //从界面上传回来,后面优化 CONTRACTEntity con = DbHelper.Select(SaveData); if (con.STATUS == ((int)合同状态.审核).ToString()) { throw new LogicException($"租约({SaveData.CONTRACTID})已经审核!"); } SaveData.VERIFY = con.VERIFY; SaveData.VERIFY_NAME = con.VERIFY_NAME; SaveData.VERIFY_TIME = con.VERIFY_TIME; } SaveData.QZRQ = SaveData.CONT_START; SaveData.REPORTER = employee.Id; SaveData.REPORTER_NAME = employee.Name; SaveData.REPORTER_TIME = DateTime.Now.ToString(); using (var Tran = DbHelper.BeginTransaction()) { DbHelper.Save(SaveData); Tran.Commit(); } return(SaveData.CONTRACTID); }