Exemplo n.º 1
0
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="nodeCodes"></param>
        public void DeleteBaseConfigs(string nodeCodes)
        {
            try
            {
                //开始事物
                db_dataReportWJW.BeginTransaction();

                FgSys_BaseConfig entity        = new FgSys_BaseConfig();
                string[]         nodeCodeArray = nodeCodes.Split(',');

                for (int i = 0; i < nodeCodeArray.Length; i++)
                {
                    OQLCompareFunc <FgSys_BaseConfig> cmpFun = (cmp, u) =>
                    {
                        OQLCompare cmpResult = null;
                        cmpResult = cmpResult & cmp.Comparer(entity.NodeCode, OQLCompare.CompareType.Equal, nodeCodeArray[i]);
                        return(cmpResult);
                    };
                    OQL deleteQ = OQL.From(entity).Delete().Where(cmpFun).END;
                    EntityQuery <FgSys_BaseConfig> .ExecuteOql(deleteQ, db_dataReportWJW);
                }

                //提交事物
                db_dataReportWJW.Commit();
            }
            catch (Exception err)
            {
                //回滚事物
                db_dataReportWJW.Rollback();
                throw err;
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// 查询列表
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <param name="pageSize"></param>
        /// <param name="pageCurrent"></param>
        /// <param name="listCount"></param>
        /// <param name="orderBy"></param>
        /// <returns></returns>
        public List <FgSys_BaseConfig> GetBaseConfigList(Dictionary <string, string> sqlWhere, int pageSize, int pageCurrent, ref int listCount, string[] orderBy)
        {
            try
            {
                FgSys_BaseConfig entity = new FgSys_BaseConfig();

                OQLCompareFunc <FgSys_BaseConfig> cmpFun = (cmp, u) =>
                {
                    OQLCompare cmpResult = null;
                    if (sqlWhere.Keys.Contains("NodeCode") && !string.IsNullOrEmpty(sqlWhere["NodeCode"]))
                    {
                        cmpResult = cmpResult & cmp.Comparer(entity.NodeCode, OQLCompare.CompareType.Like, "%" + sqlWhere["NodeCode"] + "%");
                    }
                    if (sqlWhere.Keys.Contains("NodeDomain") && !string.IsNullOrEmpty(sqlWhere["NodeDomain"]))
                    {
                        cmpResult = cmpResult & cmp.Comparer(entity.NodeDomain, OQLCompare.CompareType.Like, "%" + sqlWhere["NodeDomain"] + "%");
                    }

                    return(cmpResult);
                };

                OQL query;

                if (orderBy != null)
                {
                    query = OQL.From(entity).Select().Where(cmpFun).OrderBy(orderBy).END;
                }
                else
                {
                    query = OQL.From(entity).Select().Where(cmpFun).OrderBy(new string[1] {
                        "NodeCode asc"
                    }).END;
                }

                if (pageSize != 0 && pageCurrent != 0)
                {
                    //查询总条数
                    OQL qCount = OQL.From(entity).Select().Count(entity.NodeCode, "").Where(cmpFun).END;
                    listCount = Convert.ToInt32(EntityQuery <FgSys_BaseConfig> .QueryObject(qCount, db_dataReportWJW).NodeCode);//总条数

                    //构造分页
                    query.Limit(pageSize, pageCurrent);//分页大小,第几页
                    query.PageWithAllRecordCount = listCount;
                }

                //OQL query = OQL.From(entity).Select().END;

                List <FgSys_BaseConfig> list = EntityQuery <FgSys_BaseConfig> .QueryList(query, db_dataReportWJW);

                return(list);
            }
            catch (Exception err)
            {
                throw err;
            }
        }
Exemplo n.º 3
0
 /// <summary>
 /// 新增
 /// </summary>
 /// <param name="nodeCodes"></param>
 public void InsertBaseConfig(FgSys_BaseConfig entity)
 {
     try
     {
         EntityQuery <FgSys_BaseConfig> .Instance.Insert(entity, db_dataReportWJW);
     }
     catch (Exception err)
     {
         throw err;
     }
 }
Exemplo n.º 4
0
 /// <summary>
 /// 修改
 /// </summary>
 /// <param name="nodeCodes"></param>
 public void UpdateBaseConfig(FgSys_BaseConfig entity)
 {
     try
     {
         OQL updateQ = OQL.From(entity).Delete().Where(entity.NodeCode).END;
         EntityQuery <FgSys_BaseConfig> .ExecuteOql(updateQ, db_dataReportWJW);
     }
     catch (Exception err)
     {
         throw err;
     }
 }
Exemplo n.º 5
0
        /// <summary>
        /// 查询对象
        /// </summary>
        /// <param name="nodeCode"></param>
        /// <returns></returns>
        public FgSys_BaseConfig GetBaseConfig(string nodeCode)
        {
            try
            {
                FgSys_BaseConfig entity = new FgSys_BaseConfig()
                {
                    NodeCode = nodeCode
                };

                if (!string.IsNullOrEmpty(nodeCode))
                {
                    OQL query = OQL.From(entity).Select().Where(entity.NodeCode).END;
                    entity = EntityQuery <FgSys_BaseConfig> .QueryObject(query, db_dataReportWJW);
                }

                return(entity);
            }
            catch (Exception err)
            {
                throw err;
            }
        }