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);
}
}
