Beispiel #1
0
        /// <summary>
        /// 得数据库中实际存在的数据
        /// </summary>
        /// <param name="tablename">表名称</param>
        /// <returns></returns>
        public ActionResult GetTableInfo(string tablename)
        {
            string filter = string.Format(" DM = \"{0}\" &&  LXDM = \"{1}\" "
                                          , tablename, CodeTypeEnum.TableName.ToString());

            //var code = dalCode.GetAllEntites(n => n.MC.Equals(tablename)
            //   && n.LXDM == CodeTypeEnum.TableName.ToString()).FirstOrDefault();
            var code = dalCode.GetAllEntites(filter).FirstOrDefault();

            var dm = "";

            if (code != null)
            {
                dm = code.DM;
            }

            filter = string.Format("DXDM = \"{0}\" ", dm);

            var dataList =
                dalObjectData.GetAllEntites(filter);

            return(this.JsonFormat(dataList));
        }
Beispiel #2
0
        public ActionResult GetCode(string lxdm, int sz)
        {
            string filter = string.Format(" LXDM = \"{0}\" && SZ = \"{1}\" ", lxdm, sz);

            //var data = dalCode.GetAllEntites(n => n.LXDM == lxdm && n.SZ == sz);
            var data = dalCode.GetAllEntites(filter);

            var ent = data.FirstOrDefault();

            if (ent != null)
            {
                return(this.JsonFormat(new { success = true, data = ent }, JsonRequestBehavior.AllowGet));
            }

            return(this.JsonFormat(new { success = false }, JsonRequestBehavior.AllowGet));
        }