public override int Insert(BfModuleInfo item, DataBaseResource dbResource = DataBaseResource.Default) { using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource))) { int mainId = 0; using (TransactionScope scope = new TransactionScope()) { mainId = base.Insert(item, dbResource); if (item.OperationItems != null) { item.OperationItems.ForEach(n => { n.BF_MODULE_ID = mainId; (new BfModuleOperationDAL()).Insert(n, dbResource); }); } if (item.OtherOperationItems != null) { item.OtherOperationItems.ForEach(n => { n.BF_MODULE_ID = mainId; (new BfModuleOtherOperationDAL()).Insert(n, dbResource); }); } scope.Complete(); } return(mainId); } }
/// <summary> /// 动态聚组查询获取数据 /// </summary> /// <param name="setting"></param> /// <param name="xmlFilterParams"></param> /// <returns></returns> public virtual System.Data.DataSet GetDynamicGroupQueryData(MB.Util.Model.DynamicGroupSetting setting, string xmlFilterParams) { using (MB.Orm.DB.OperationDatabaseScope scope = new OperationDatabaseScope(true)) { QueryParameterInfo[] filters = new MB.Util.Serializer.QueryParameterXmlSerializer().DeSerializer(xmlFilterParams); return(new ObjectEditHelper().GetDynamicGroupQueryData(setting, filters)); } }
public VenderUser LogOn(string userCode, string psw) { using (var DbScope = new OperationDatabaseScope(new OperationDatabaseContext("NewWeb"))) { //Microsoft.Practices.EnterpriseLibrary.Data.Database db = Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase("NewWeb"); try { VenderUser userInfo = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml<VenderUser>("NewWebCommon", "GetUserInfo", userCode, EncryptHelper.EncryptDES(psw)).FirstOrDefault(); if (userInfo != null) { } else { userInfo = new VenderUser() { ErrorMsg = "登录户名或密码不正确" }; } return userInfo; } catch (Exception ex) { MB.Util.TraceEx.Write(ex.Message); } return null; } }
public bool ChangePwd(BfUserInfo bfUser) { using (var dbScope = new OperationDatabaseScope(GetDbConnection(DataBaseResource.Default))) { var i = DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQueryByEntity("BfUser", "ChangePWD", bfUser); return(i > 0); } }
public int DeleteByModuleID(int moduleID, DataBaseResource dbResource = DataBaseResource.Default) { using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource))) { var i = DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQuery("BfModuleOperation.xml", "DeleteObjectByModuleID", moduleID); return(i); } }
public int DeleteByRoleId(int roleId) { using (var dbScope = new OperationDatabaseScope(GetDbConnection(DataBaseResource.Default))) { var i = DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQuery("BfRolePermission", "DeleteByRoleId", roleId); return(i); } }
public int DeleteByBfCodeId(int bfCodeId) { using (var dbScope = new OperationDatabaseScope(GetDbConnection(DataBaseResource.Default))) { var i = DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQuery("BfCodeDetail", "DeleteObjectByBfCodeId", bfCodeId); return(i); } }
public int updateByImgId(ImgInfo img) { using (var dbScope = new OperationDatabaseScope(GetDbConnection(DataBaseResource.Default))) { var i = DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQuery("Imginfo", "updateByImgId", img); return(i); } }
public int DeleteByModuleId(int moduleId) { using (var dbScope = new OperationDatabaseScope(GetDbConnection(DataBaseResource.Default))) { var i = DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQuery("Imginfo", "DeleteByModuleId", moduleId); return(i); } }
/// <summary> /// 根据过滤的条件获取指定类型实体对象的集合。 /// </summary> /// <param name="xmlFilterParams">QueryParameterInfo[] 系列化后的字符窜</param> /// <returns>得到的实体集合</returns> // [OperationBehavior(TransactionScopeRequired = true, TransactionAutoComplete = true)] public virtual IList GetObjects(int dataInDocType, string xmlFilterParams) { using (MB.Orm.DB.OperationDatabaseScope scope = new OperationDatabaseScope(true)) { QueryParameterInfo[] filters = new MB.Util.Serializer.QueryParameterXmlSerializer().DeSerializer(xmlFilterParams); var qh = MessageHeaderHelper.GetQueryBehavior(_MessageHeaderKey); //modify by aifang 动态列设置 var qh = MessageHeaderHelper.GetQueryBehavior(); return(new ObjectEditHelper(qh).GetObjects <System.Object>(this, ConvertDataInDocType(dataInDocType), filters)); } }
public override int Insert(UserTokenInfo item, DataBaseResource dbResource = DataBaseResource.Default) { using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource))) { DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQueryByEntity <UserTokenInfo>("UserToken", "AddObject", item); return(item.USERID); } }
public List <BfRoleInfo> GetRoleByUser(int userId) { using (var dbScope = new OperationDatabaseScope(ReadDb)) { var result = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml <BfRoleInfo>("BfRoleUser.xml", "SelectRoleByUser", userId); return(result); } }
// DataBaseResource dbResource = DataBaseResource.Default) // using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource))) public List <BfCodeDetailInfo> GetBfCodeByModuleId(string moduleId) { using (var dbScope = new OperationDatabaseScope(ReadDb)) { var result = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml <BfCodeDetailInfo>("BfCode.xml", "GetBfCodeByModuleId", moduleId); return(result); } }
public List <BfModuleInfo> SelectAllChildBfModuleInfos() { using (var dbScope = new OperationDatabaseScope(ReadDb)) { var result = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml <BfModuleInfo>(OBJECT_XML_FILE, "SelectAllChildBfModuleInfos"); return(result); } }
//查询供应商用户列表 public List<VenderUserInfo> GetVenderUserList(int pageIndex, int pageSize, out int total, params object[] parValues) { using (var DbScope = new OperationDatabaseScope(new OperationDatabaseContext("NewWeb"))) { List<VenderUserInfo> list = PagedDatabaseExcuteByXmlHelper.NewInstance.GetPagedObjectsByXml3<VenderUserInfo> ("NewWebCommon", "GetVenderUserInfo", pageIndex, pageSize, out total, parValues); return list; } }
//查询主表 public List<PurchaseOutMain> GetPurchaseInMain(int pageIndex, int pageSize, out int total, params object[] parValues) { using (var DbScope = new OperationDatabaseScope(new OperationDatabaseContext("NewWeb"))) { List<PurchaseOutMain> list = PagedDatabaseExcuteByXmlHelper.NewInstance.GetPagedObjectsByXml3<PurchaseOutMain> ("PurchaseOut", "GetPurchaseOutMain", pageIndex, pageSize, out total, parValues); return list; } }
//查询子表 public List<PurchaseOut> GetPurchaseInDetail(string OrderNoOrGoodsCode) { using (var DbScope = new OperationDatabaseScope(new OperationDatabaseContext("NewWeb"))) { List<PurchaseOut> list = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml<PurchaseOut> ("PurchaseOut", "GetPurchaseOutDetail", OrderNoOrGoodsCode); return list; } }
public System.Collections.Generic.List <string> GetAllRegion() { using (var dbScope = new OperationDatabaseScope(ReadDb)) { var result = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml <string>("Areainfo.xml", "GetAllRegion"); return(result); } }
public List <BfModuleOperationInfo> SelectOperationByUserID(int UserID) { using (var dbScope = new OperationDatabaseScope(ReadDb)) { var result = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml <BfModuleOperationInfo>(OBJECT_XML_FILE, "SelectOperationByUserID", UserID); return(result); } }
public List <RoadMunicipalInfo> getByRoadId(int roadId) { using (var dbScope = new OperationDatabaseScope(ReadDb)) { var result = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml <RoadMunicipalInfo>(OBJECT_XML_FILE, "getByRoadId", roadId); return(result); } }
public System.Collections.Generic.List <ImgInfo> GetImgByModuleIdAndType(int moduleId) { using (var dbScope = new OperationDatabaseScope(ReadDb)) { var result = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml <ImgInfo>("Imginfo", "GetImgByModuleIdAndType", moduleId); return(result); } }
public System.Collections.Generic.List <ImgInfo> GetImgByRoadId(int RoadId) { using (var dbScope = new OperationDatabaseScope(ReadDb)) { var result = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml <ImgInfo>("Imginfo.xml", "GetImgByRoadId", RoadId); return(result); } }
/// <summary> /// 根据订单号查询订单商品信息 /// </summary> /// <param name="OrderNoOrGoodsCode"></param> /// <returns></returns> public List<OrderGoods> Query(string OrderNoOrGoodsCode) { using (var DbScope = new OperationDatabaseScope(new OperationDatabaseContext("NewWeb"))) { List<OrderGoods> OrderGoodsInfo = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml<OrderGoods>("CheckOrderGoods", "GetOrderGoodsInfo", OrderNoOrGoodsCode); //if (OrderGoodsInfo == null) //{ // OrderGoodsInfo = new OrderGoods() { ErrorMsg = "输入信息错误" }; //} return OrderGoodsInfo; } }
/// <summary> /// 获取供应商列表 /// </summary> /// <param name="userCode"></param> /// <param name="psw"></param> /// <returns></returns> public List<Vender> GetVenderList() { using (var DbScope = new OperationDatabaseScope(new OperationDatabaseContext("NewWeb"))) { List<Vender> Venderlist = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml<Vender>("NewWebCommon", "GetVenderInfo", ""); Vender v=new Vender (); v.VENDERCODE=""; v.VENDERNAME="--全部--"; v.VENDERID=0; Venderlist.Add(v); return Venderlist; } }
public ImgInfo GetImgById(int moduleId) { using (var dbScope = new OperationDatabaseScope(ReadDb)) { var result = DatabaseExcuteByXmlHelper.NewInstance.GetObjectsByXml <ImgInfo>("Imginfo", "GetImgById", moduleId); if (result.Count > 0) { return(result[0]); } return(null); } }
public bool CheckExistsStreetInfo(int id) { using (var dbScope = new OperationDatabaseScope(ReadDb)) { var ds = DatabaseExcuteByXmlHelper.NewInstance.GetDataSetByXml("StreetTreeInfo.xml", "SelectRoadID", id); if (ds.Tables[0].Rows.Count > 0 && int.Parse(ds.Tables[0].Rows[0][0].ToString()) == 1) { return(true); } } return(false); }
public int BatchImport(List <BfRegionInfo> entitys, DataBaseResource dbResource = DataBaseResource.Default) { if (entitys == null || entitys.Count < 1) { return(0); } using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource))) { var updateMainLst = new List <BfRegionInfo>(); var insertMainLst = new List <BfRegionInfo>(); var id = 0; #region 组合主表新增及更新 foreach (var entity in entitys) { if (entity.ID > 0) { updateMainLst.Add(entity); } else { insertMainLst.Add(entity); } } if (insertMainLst != null && insertMainLst.Count > 0) { id = GetEntityIdentity("BF_CODE", insertMainLst.Count); foreach (var tmp in insertMainLst) { tmp.ID = id; id++; } } #endregion MB.RuleBase.Common.DatabaseExecuteHelper.NewInstance.ExecuteWithTransaction((tran) => { using (var bulk = MB.RuleBase.BulkCopy.DbBulkExecuteFactory.CreateDbBulkExecute(tran)) { bulk.WriteToServer("BfRegion", "AddObject", insertMainLst); DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQueryByEntity(tran, "BfRegion", "UpdateObject", updateMainLst); } }); return(entitys.Count); } }
public void TestSQLBuikInsert() { List <TmpTimeSplitInfo> tmpTimeSplitInfos = new List <TmpTimeSplitInfo>(); List <MyTable> myTables = new List <MyTable>(); for (int i = 0; i < 3; i++) { TmpTimeSplitInfo time = new TmpTimeSplitInfo(); time.USER_UID = i.ToString(); time.USER_CODE = i.ToString(); tmpTimeSplitInfos.Add(time); MyTable my = new MyTable(); my.ID = i; my.Name = "Name" + i.ToString(); myTables.Add(my); } //MB.OS ; MB.BPM.KQ using (MB.Orm.DB.OperationDatabaseScope scope = new OperationDatabaseScope("MB.BPM.KQ")) { try { tmpTimeSplitInfos.ForEach(p => { p.LOAD_TIME = DateTime.Now; p.APP_DATE = DateTime.Now; }); //using (TransactionScope trans = new TransactionScope()) { // using (IDbBulkExecute bulk = DbBulkExecuteFactory.CreateDbBulkExecute()) { // //MB.RuleBase.Common.DatabaseExcuteByXmlHelper.NewInstance.ExecuteNonQueryByEntity("TmpTimeSplit", // // "AddObject", // // tmpTimeSplitInfo[0]); // bulk.WriteToServer("TmpTimeSplit", "AddObject", tmpTimeSplitInfo); // } // trans.Complete(); //} //using (IDbBulkExecute bulk = DbBulkExecuteFactory.CreateDbBulkExecute()) { // bulk.WriteToServer("TmpTimeSplit", "AddObject", tmpTimeSplitInfos); //} using (IDbBulkExecute bulk = DbBulkExecuteFactory.CreateDbBulkExecute()) { bulk.WriteToServer("MyTable", "AddObject", tmpTimeSplitInfos); } } catch (Exception ex) { throw new APPException(ex.Message, APPMessageType.SysErrInfo); } } }
public override int Insert(BfOrgInfo item, DataBaseResource dbResource = DataBaseResource.Default) { using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource))) { int mainId = 0; using (TransactionScope scope = new TransactionScope()) { mainId = base.Insert(item, dbResource); //if (item.OWNER_ID < 1) //{ // item.OWNER_ID = mainId; // base.Update(item, dbResource); //} scope.Complete(); } return(mainId); } }
public override int Insert(BfCodeInfo item, DataBaseResource dbResource = DataBaseResource.Default) { using (var dbScope = new OperationDatabaseScope(GetDbConnection(dbResource))) { int mainId = 0; using (TransactionScope scope = new TransactionScope()) { mainId = base.Insert(item, dbResource); if (item.BfCodeDtlInfoList != null) { item.BfCodeDtlInfoList.ForEach(n => { n.BF_CODE_ID = mainId; (new BfCodeDetailInfoDAL()).Insert(n, dbResource); }); } scope.Complete(); } return(mainId); } }