public bool LinksRemoveDown(int id) { //当前对象 Links current = Gateway.Default.From <Links>().Where(Links._.Lk_Id == id).ToFirst <Links>(); //当前对象父节点id; int lsId = (int)current.Ls_Id; //当前对象排序号 int orderValue = (int)current.Lk_Tax; //下一个对象,即弟弟对象;弟弟不存则直接返回false; Links next = Gateway.Default.From <Links>() .Where(Links._.Lk_Tax > orderValue && Links._.Org_ID == current.Org_ID && Links._.Ls_Id == lsId) .OrderBy(Links._.Lk_Tax.Asc).ToFirst <Links>(); if (next == null) { //如果弟对象不存在,则表示当前节点在兄弟中是老幺;即是最底端; return(false); } //交换排序号 current.Lk_Tax = next.Lk_Tax; next.Lk_Tax = orderValue; using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <Links>(current); tran.Save <Links>(next); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } return(true); }
/// <summary> /// 修改排序 /// </summary> /// <param name="xml"></param> public void SaveOrder(string xml) { XmlDocument resXml = new XmlDocument(); resXml.XmlResolver = null; using (DbTrans tran = Gateway.Default.BeginTrans()) try { resXml.LoadXml(xml, false); XmlNodeList nodeList = resXml.SelectSingleNode("nodes").ChildNodes; //取rootid XmlNode nodes = resXml.SelectSingleNode("nodes"); XmlElement xenodes = (XmlElement)nodes; //遍历所有子节点 foreach (XmlNode xn in nodeList) { XmlElement xe = (XmlElement)xn; int id = Convert.ToInt32(xe.Attributes["id"].Value); int pid = Convert.ToInt32(xe.Attributes["pid"].Value); int tax = Convert.ToInt32(xe.Attributes["tax"].Value); bool state = Convert.ToBoolean(xe.Attributes["state"].Value); Song.Entities.ManageMenu mm = this.GetSingle(id); if (mm != null) { mm.MM_PatId = pid.ToString(); mm.MM_Tax = tax; tran.Save <ManageMenu>(mm); } } tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } }
/// <summary> /// 新增数据 /// </summary> public AjaxResult Insert(TbMonthCostHeSuan model, TbMonthCostHeSuanIncome incomeModel, List <TbMonthCostHeSuanCost> costModel, List <TbMonthCostHeSuanOtherCost> otherCostModel) { if (model == null) { return(AjaxResult.Warning("参数错误")); } //判断信息是否存在 var anyRet = AnyInfoType(model.HeSuanMonth, model.ProcessFactoryCode, model.HeSuanCode); if (anyRet.state.ToString() != ResultType.success.ToString()) { return(anyRet); } model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode; try { using (DbTrans trans = Db.Context.BeginTransaction()) { //添加信息 Repository <TbMonthCostHeSuan> .Insert(trans, model); //添加信息 Repository <TbMonthCostHeSuanIncome> .Insert(trans, incomeModel); //添加明细信息 Repository <TbMonthCostHeSuanCost> .Insert(trans, costModel); if (otherCostModel.Count > 0) { //添加明细信息 Repository <TbMonthCostHeSuanOtherCost> .Insert(trans, otherCostModel); } trans.Commit(); return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }
public void SaveOrder(string xml) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { XmlDocument resXml = new XmlDocument(); resXml.XmlResolver = null; resXml.LoadXml(xml, false); XmlNodeList nodeList = resXml.SelectSingleNode("nodes").ChildNodes; //取rootid XmlNode nodes = resXml.SelectSingleNode("nodes"); XmlElement xenodes = (XmlElement)nodes; //遍历所有子节点 foreach (XmlNode xn in nodeList) { XmlElement xe = (XmlElement)xn; int id = Convert.ToInt32(xe.Attributes["id"].Value); int pid = Convert.ToInt32(xe.Attributes["pid"].Value); int tax = Convert.ToInt32(xe.Attributes["tax"].Value); Song.Entities.Columns nc = this.Single(id); if (nc != null) { nc.Col_PID = pid; nc.Col_Tax = tax; tran.Save <Columns>(nc); } } tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } } }
/// <suPsary> /// 修改 /// </suPsary> /// <param name="entity">业务实体</param> public void SortSave(LinksSort entity) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <LinksSort>(entity); tran.Update <Links>(new Field[] { Links._.Ls_Name }, new object[] { entity.Ls_Name }, Links._.Ls_Id == entity.Ls_Id); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } }
/// <summary> /// 修改 /// </summary> /// <param name="entity">业务实体</param> public void DownloadTypeSave(DownloadType entity) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <DownloadType>(entity); tran.Update <Download>(new Field[] { Download._.Dty_Type }, new object[] { entity.Dty_Name }, Download._.Dty_Id == entity.Dty_Id); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } } }
/// <summary> /// 修改 /// </summary> /// <param name="entity">业务实体</param> public void TitleSave(EmpTitle entity) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <EmpTitle>(entity); tran.Update <EmpAccount>(new Field[] { EmpAccount._.Title_Name }, new object[] { entity.Title_Name }, EmpAccount._.Title_Id == entity.Title_Id); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } } }
public void SpecialDelete(int identify) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Delete <Special>(Special._.Sp_Id == identify); tran.Delete <Special_Article>(Special_Article._.Sp_Id == identify); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } } }
public void ProductDelete(int identify) { Song.Entities.Product entity = this.ProductSingle(identify); using (DbTrans tran = Gateway.Default.BeginTrans()) { try { _ProductDelete(entity, tran); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } } }
/// <suPsary> /// 删除 /// </suPsary> /// <param name="entity">业务实体</param> public void SortDelete(LinksSort entity) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Delete <LinksSort>(LinksSort._.Ls_Id == entity.Ls_Id); tran.Delete <Links>(Links._.Ls_Id == entity.Ls_Id); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } }
public void PictureSetCover(string uid, int pid) { using (DbTrans tran = Gateway.Default.BeginTrans()) try { //去除当前相册的封面 tran.Update <Picture>(new Field[] { Picture._.Pic_IsCover }, new object[] { false }, Picture._.Pic_Uid == uid); //设置当前图片封面 tran.Update <Picture>(new Field[] { Picture._.Pic_IsCover }, new object[] { true }, Picture._.Pic_Id == pid); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } }
public void TrpDelete(string uid) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Delete <ExamGroup>(ExamGroup._.Exam_UID == uid); tran.Delete <TrPlan>(TrPlan._.TrP_UID == uid); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } } }
/// <summary> /// 删除,按主键ID; /// </summary> /// <param name="identify">实体的主键</param> public void ThemeDelete(int identify) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Delete <ProfitSharing>(ProfitSharing._.Ps_ID == identify); tran.Delete <ProfitSharing>(ProfitSharing._.Ps_PID == identify); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } }
/// <summary> /// 创建人:李沈杰 /// 描 述:修改密码 /// </summary> /// <param name="UserID">用户名</param> /// <returns></returns> public bool UpdateProjectInfo(string UserID, string UserPassword) { ProjectInfo opjson = new ProjectInfo(); opjson.UserPassword = UserPassword; //事务定义执行 DbTrans trans = DB_Conn1.Context.BeginTransaction(); try { DB_Conn1.Context.Update(trans, opjson, ProjectInfo._.UserID == UserID); trans.Commit(); return(true); } catch { trans.Rollback(); return(false); } }
/// <summary> /// 修改 /// </summary> /// <param name="entity">业务实体</param> public void SortSave(AddressSort entity) { using (DbTrans trans = Gateway.Default.BeginTrans()) { try { trans.Save <AddressSort>(entity); trans.Update <AddressList>(new Field[] { AddressList._.Ads_Name }, new object[] { entity.Ads_Name }, AddressList._.Ads_Id == entity.Ads_Id); trans.Commit(); } catch { trans.Rollback(); throw; } finally { trans.Close(); } } }
public int RootDelete(int identify) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { this._Delete(identify, tran); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } return(identify); }
public void SortSetDefault(int orgid, int identify) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Update <TeacherSort>(new Field[] { TeacherSort._.Ths_IsDefault }, new object[] { false }, TeacherSort._.Org_ID == orgid); tran.Update <TeacherSort>(new Field[] { TeacherSort._.Ths_IsDefault }, new object[] { true }, TeacherSort._.Ths_ID == identify); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } } }
public void SortSave(KnowledgeSort entity) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <KnowledgeSort>(entity); tran.Update <Knowledge>(new Field[] { Knowledge._.Kns_Name }, new object[] { entity.Kns_Name }, Knowledge._.Kns_ID == entity.Kns_ID); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } } }
public AjaxResult Insert(IEnumerable <TbFlowNode> list) { DbTrans trans = null; try { using (trans = Db.Context.BeginTransaction()) { FlowNodeDA.Insert(trans, list); trans.Commit(); return(AjaxResult.Success()); } } catch (Exception) { if (trans != null) { trans.Rollback(); } return(AjaxResult.Error()); } }
/// <summary> /// 将当前栏目向下移动;仅在当前对象的同层移动,即同一父节点下的对象之间移动; /// </summary> /// <param name="id"></param> /// <returns>如果已经处于最底端,则返回false;移动成功,返回true</returns> public bool RemoveDown(int id) { //当前对象 ManageMenu current = Gateway.Default.From <ManageMenu>().Where(ManageMenu._.MM_Id == id).ToFirst <ManageMenu>(); //当前对象父节点id; string parentId = (string)current.MM_PatId; //当前对象排序号 int orderValue = (int)current.MM_Tax; //下一个对象,即弟弟对象; ManageMenu down = Gateway.Default.From <ManageMenu>().Where(ManageMenu._.MM_PatId == parentId && ManageMenu._.MM_Tax > orderValue).OrderBy(ManageMenu._.MM_Tax.Asc).ToFirst <ManageMenu>(); if (down == null) { //如果弟对象不存在,则表示当前节点在兄弟中是老幺;即是最底端; return(false); } //交换排序号 current.MM_Tax = down.MM_Tax; down.MM_Tax = orderValue; using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <ManageMenu>(current); tran.Save <ManageMenu>(down); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } return(true); }
/// <summary> /// 将当前栏目向上移动;仅在当前对象的同层移动,即同一父节点下的对象之间移动; /// </summary> /// <param name="id"></param> /// <returns>如果已经处于顶端,则返回false;移动成功,返回true</returns> public bool RemoveUp(int id) { //当前对象 ManageMenu current = Gateway.Default.From <ManageMenu>().Where(ManageMenu._.MM_Id == id).ToFirst <ManageMenu>(); //当前对象父节点id; string parentId = (string)current.MM_PatId; //当前对象排序号 int orderValue = (int)current.MM_Tax; //上一个对象,即兄长对象; ManageMenu up = Gateway.Default.From <ManageMenu>().Where(ManageMenu._.MM_PatId == parentId && ManageMenu._.MM_Tax < orderValue).OrderBy(ManageMenu._.MM_Tax.Desc).ToFirst <ManageMenu>(); if (up == null) { //如果兄长对象不存在,则表示当前节点在兄弟中是老大;即是最顶点; return(false); } //交换排序号 current.MM_Tax = up.MM_Tax; up.MM_Tax = orderValue; using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <ManageMenu>(current); tran.Save <ManageMenu>(up); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } return(true); }
/// <summary> /// 修改数据 /// </summary> public AjaxResult Update(TbShortMessageTemplate model) { if (model == null) { return(AjaxResult.Warning("参数错误")); } try { using (DbTrans trans = Db.Context.BeginTransaction())//使用事务 { //修改信息 Repository <TbShortMessageTemplate> .Update(trans, model, p => p.ID == model.ID); trans.Commit();//提交事务 return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }
public void SaveGroup(UserGroup entity) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <UserGroup>(entity); //修改用户信息中的组名称 tran.Update <User>(new Field[] { User._.UGrp_Name }, new object[] { entity.UGrp_Name }, User._.UGrp_Id == entity.UGrp_Id); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } }
/// <summary> /// 修改 /// </summary> /// <param name="entity">业务实体</param> public void Save(Position entity) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <Position>(entity); tran.Update <EmpAccount>(new Field[] { EmpAccount._.Posi_Name }, new object[] { entity.Posi_Name }, EmpAccount._.Posi_Id == entity.Posi_Id); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } }
public bool LinksRemoveUp(int id) { //当前对象 Links current = Gateway.Default.From <Links>().Where(Links._.Lk_Id == id).ToFirst <Links>(); //当前对象父节点id; int lsId = (int)current.Ls_Id; //当前对象排序号 int orderValue = (int)current.Lk_Tax; //上一个对象,即兄长对象; Links up = Gateway.Default.From <Links>().Where(Links._.Org_ID == current.Org_ID && Links._.Ls_Id == lsId && Links._.Lk_Tax < orderValue).OrderBy(Links._.Lk_Tax.Desc).ToFirst <Links>(); if (up == null) { //如果兄长对象不存在,则表示当前节点在兄弟中是老大;即是最顶点; return(false); } //交换排序号 current.Lk_Tax = up.Lk_Tax; up.Lk_Tax = orderValue; using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <Links>(current); tran.Save <Links>(up); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } return(true); }
/// <summary> /// 新增数据 /// </summary> public AjaxResult Insert(List <TbRawMaterialStockRecord> model) { if (model == null) { return(AjaxResult.Warning("参数错误")); } try { using (DbTrans trans = Db.Context.BeginTransaction()) { //添加信息 Repository <TbRawMaterialStockRecord> .Insert(trans, model); trans.Commit(); return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }
public int AddNodeUI(List <TbFlowNodeUI> list) { DbTrans trans = null; try { using (trans = Db.Context.BeginTransaction()) { FlowNodeUIDA.Insert(list); trans.Commit(); return(1); } } catch (Exception) { if (trans != null) { trans.Rollback(); } return(0); } }
/// <summary> /// 新增部门信息数据 /// </summary> public AjaxResult InsertNew(List <TbDepartment> dep, bool isApi = false) { try { List <TbDepartment> data = Db.Context.From <TbDepartment>().Select(TbDepartment._.All).ToList(); using (DbTrans trans = Db.Context.BeginTransaction()) { //先删除原来的表 Db.Context.FromSql("truncate table TbDepartment").SetDbTransaction(trans).ExecuteNonQuery(); //插入从BM那边取过来的数据 Repository <TbDepartment> .Insert(trans, dep, isApi); trans.Commit();//提交事务 return(AjaxResult.Success()); } } catch (Exception e) { var err = e.ToString(); return(AjaxResult.Error(err)); } }
public bool SortRemoveDown(int orgid, int id) { //当前对象 TeacherSort current = Gateway.Default.From <TeacherSort>().Where(TeacherSort._.Ths_ID == id).ToFirst <TeacherSort>(); //当前对象排序号 int orderValue = (int)current.Ths_Tax; //下一个对象,即弟弟对象; TeacherSort down = Gateway.Default.From <TeacherSort>() .Where(TeacherSort._.Org_ID == orgid && TeacherSort._.Ths_Tax > orderValue) .OrderBy(TeacherSort._.Ths_Tax.Asc).ToFirst <TeacherSort>(); if (down == null) { return(false); } //交换排序号 current.Ths_Tax = down.Ths_Tax; down.Ths_Tax = orderValue; using (DbTrans tran = Gateway.Default.BeginTrans()) { try { tran.Save <TeacherSort>(current); tran.Save <TeacherSort>(down); tran.Commit(); } catch { tran.Rollback(); throw; } finally { tran.Close(); } } return(true); }
/// <summary> /// 修改充值码设置项 /// </summary> /// <param name="entity">业务实体</param> public void RechargeSetSave(RechargeSet entity) { using (DbTrans tran = Gateway.Default.BeginTrans()) { try { Song.Entities.RechargeSet rs = tran.From <RechargeSet>().Where(RechargeSet._.Rs_ID == entity.Rs_ID).ToFirst <RechargeSet>(); //如果新增了充值码 if (rs.Rs_Count < entity.Rs_Count) { _RechargeCodeBuilds(entity, entity.Rs_Count - rs.Rs_Count); } //如果减少的充值码 if (rs.Rs_Count > entity.Rs_Count) { Song.Entities.RechargeCode[] rcs = tran.From <RechargeCode>().Where(RechargeCode._.Rs_ID == entity.Rs_ID && RechargeCode._.Rc_IsUsed == false).ToArray <RechargeCode>(rs.Rs_Count - entity.Rs_Count); foreach (RechargeCode r in rcs) { tran.Delete <RechargeCode>(r); } } tran.Update <RechargeCode>(new Field[] { RechargeCode._.Rc_Price, RechargeCode._.Rc_LimitStart, RechargeCode._.Rc_LimitEnd }, new object[] { entity.Rs_Price, entity.Rs_LimitStart, entity.Rs_LimitEnd }, RechargeCode._.Rs_ID == entity.Rs_ID && RechargeCode._.Rc_IsUsed == false); tran.Save <RechargeSet>(entity); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Close(); } } }