P2022036_ExportMap.git

13693261870

2023-12-22 200ce83f5c9410ac6926584632ed117a2b7cd2de

完成接口开发

已修改5个文件

	JiangSu/App_Data/db.sql	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	JiangSu/App_Data/js.db	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	JiangSu/Controllers/OpController.cs	18 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	JiangSu/cs/ModelDAL.cs	20 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	JiangSu/index.html	68 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 JiangSu/App_Data/db.sql

@@ -7,5 +7,6 @@
-- insert into model (name, json) values ('Test', '{"color": "#ffffff", "yaw": 0}');

select * from model;
select * from model where upper(name) like '%' order by id limit 10 offset 0;
--------------------------------------------------------------------------------


 JiangSu/App_Data/js.db

Binary files differ

 JiangSu/Controllers/OpController.cs

@@ -12,6 +12,20 @@
    public class OpController : ApiController
    {
        [HttpGet]
        public List<Model> SelectByPage(string name, int pageSize = 10, int pageIndex = 1)
        {
            try
            {
                return ModelDAL.SelectByPage(string.IsNullOrWhiteSpace(name) ? "" : name.ToString(), pageSize, pageIndex);
            }
            catch (Exception ex)
            {
                LogOut.Error(ex.StackTrace);
                return null;
            }
        }

        [HttpGet]
        public Model SelectById(long id)
        {
            try
@@ -42,13 +56,13 @@
        }

        [HttpPost]
        public int insert([FromBody] Model model)
        public int Insert([FromBody] Model model)
        {
            try
            {
                if (null == model) return 0;

                return ModelDAL.insert(model);
                return ModelDAL.Insert(model);
            }
            catch (Exception ex)
            {

 JiangSu/cs/ModelDAL.cs

@@ -43,6 +43,24 @@
            return list.ToArray();
        }

        public static List<Model> SelectByPage(string name, int pageSize = 10, int pageIndex = 1)
        {
            string sql = string.Format("select * from model where upper(name) like @name order by id limit {0} offset {1}", pageSize, pageSize * (pageIndex - 1));

            SQLiteParameter param = new SQLiteParameter("@name");
            param.Value = "%" + name.ToUpper() + "%";

            DataTable dt = SQLiteHelper.GetDataTable(sql, param);
            if (null == dt || dt.Rows.Count == 0)
            {
                return null;
            }

            List<Model> list = ModelHandler.FillModel<Model>(dt);

            return list;
        }

        public static Model SelectById(long id)
        {
            string sql = "select * from model where id = @id";
@@ -69,7 +87,7 @@
            return SQLiteHelper.ExecuteNonQuery(sql);
        }

        public static int insert(Model model)
        public static int Insert(Model model)
        {
            string sql = "insert into model (name, json) values (@name, @json)";
            SQLiteParameter[] sqlParams = GetParams<Model>(sql, model);

 JiangSu/index.html

@@ -1,14 +1,80 @@
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <title>江苏交控智慧高速项目</title>
  <meta http-equiv="Expires" content="0" />
  <meta http-equiv="Cache" content="no-cache" />
  <meta http-equiv="Pragma" content="no-cache" />
  <meta http-equiv="Cache-control" content="no-cache" />
  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title></title>
  <script src="Scripts/jquery-1.7.1.min.js"></script>
  <script>
    $(function () {
      //
    });

    function Insert() {
      var data = getModel();

      ajax("Op/Insert", "POST", data, null, null, function (rs) {
        console.log(rs);
        alert(rs);
      });
    }

    function UpdateById() {
      var data = getModel();

      ajax("Op/UpdateById", "POST", data, null, null, function (rs) {
        console.log(rs);
        alert(rs);
      });
    }

    function getModel() {
      var model = {
        id: $("#id").val(),
        name: $("#name").val(),
        json: $("#json").val()
      };

      return JSON.stringify(model);
    }

    function ajax(url, type, data, dataType, contentType, fn) {
      $.ajax({
        url: url,
        type: type,
        data: data,
        dataType: dataType || "json", // html、json、jsonp、script、text
        contentType: contentType || "application/json", // "application/x-www-form-urlencoded"
        success: function (data) {
          fn(data);
        },
        error: function (e) {
          console.error(e);
        }
      });
    }
  </script>
</head>
<body>
  <a href="http://localhost/JiangSu/Values/Get">GetValues</a> <br />

  <a href="http://localhost/JiangSu/Op/SelectByPage?pageSize=10&pageIndex=1&name=">SelectByPage?pageSize=10&pageIndex=1&name=</a> <br />

  <a href="http://localhost/JiangSu/Op/SelectById?id=1">SelectById?id=1</a> <br />

  <a href="http://localhost/JiangSu/Op/DeleteByIds?ids=2,3">DeleteByIds?ids=2,3</a> <br />

  <form>
    <input id="id" name="id" value="3" /> <br />
    <input id="name" name="name" value="A" /> <br />
    <input id="json" name="json" value="{}" /> <br />

    <input type="button" value="Insert" onclick="Insert();" />
    <input type="button" value="UpdateById" onclick="UpdateById();" /><br />
  </form>
</body>
</html>

			@@ -7,5 +7,6 @@
			-- insert into model (name, json) values ('Test', '{"color": "#ffffff", "yaw": 0}');

			select * from model;
			select * from model where upper(name) like '%' order by id limit 10 offset 0;
			--------------------------------------------------------------------------------

			@@ -12,6 +12,20 @@
			public class OpController : ApiController
			{
			[HttpGet]
			public List<Model> SelectByPage(string name, int pageSize = 10, int pageIndex = 1)
			{
			try
			{
			return ModelDAL.SelectByPage(string.IsNullOrWhiteSpace(name) ? "" : name.ToString(), pageSize, pageIndex);
			}
			catch (Exception ex)
			{
			LogOut.Error(ex.StackTrace);
			return null;
			}
			}

			[HttpGet]
			public Model SelectById(long id)
			{
			try
			@@ -42,13 +56,13 @@
			}

			[HttpPost]
			public int insert([FromBody] Model model)
			public int Insert([FromBody] Model model)
			{
			try
			{
			if (null == model) return 0;

			return ModelDAL.insert(model);
			return ModelDAL.Insert(model);
			}
			catch (Exception ex)
			{

			@@ -43,6 +43,24 @@
			return list.ToArray();
			}

			public static List<Model> SelectByPage(string name, int pageSize = 10, int pageIndex = 1)
			{
			string sql = string.Format("select * from model where upper(name) like @name order by id limit {0} offset {1}", pageSize, pageSize * (pageIndex - 1));

			SQLiteParameter param = new SQLiteParameter("@name");
			param.Value = "%" + name.ToUpper() + "%";

			DataTable dt = SQLiteHelper.GetDataTable(sql, param);
			if (null == dt \|\| dt.Rows.Count == 0)
			{
			return null;
			}

			List<Model> list = ModelHandler.FillModel<Model>(dt);

			return list;
			}

			public static Model SelectById(long id)
			{
			string sql = "select * from model where id = @id";
			@@ -69,7 +87,7 @@
			return SQLiteHelper.ExecuteNonQuery(sql);
			}

			public static int insert(Model model)
			public static int Insert(Model model)
			{
			string sql = "insert into model (name, json) values (@name, @json)";
			SQLiteParameter[] sqlParams = GetParams<Model>(sql, model);

			@@ -1,14 +1,80 @@
			<!DOCTYPE html>
			<html xmlns="http://www.w3.org/1999/xhtml">
			<head>
			<title>江苏交控智慧高速项目</title>
			<meta http-equiv="Expires" content="0" />
			<meta http-equiv="Cache" content="no-cache" />
			<meta http-equiv="Pragma" content="no-cache" />
			<meta http-equiv="Cache-control" content="no-cache" />
			<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
			<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
			<title></title>
			<script src="Scripts/jquery-1.7.1.min.js"></script>
			<script>
			$(function () {
			//
			});

			function Insert() {
			var data = getModel();

			ajax("Op/Insert", "POST", data, null, null, function (rs) {
			console.log(rs);
			alert(rs);
			});
			}

			function UpdateById() {
			var data = getModel();

			ajax("Op/UpdateById", "POST", data, null, null, function (rs) {
			console.log(rs);
			alert(rs);
			});
			}

			function getModel() {
			var model = {
			id: $("#id").val(),
			name: $("#name").val(),
			json: $("#json").val()
			};

			return JSON.stringify(model);
			}

			function ajax(url, type, data, dataType, contentType, fn) {
			$.ajax({
			url: url,
			type: type,
			data: data,
			dataType: dataType \|\| "json", // html、json、jsonp、script、text
			contentType: contentType \|\| "application/json", // "application/x-www-form-urlencoded"
			success: function (data) {
			fn(data);
			},
			error: function (e) {
			console.error(e);
			}
			});
			}
			</script>
			</head>
			<body>
			<a href="http://localhost/JiangSu/Values/Get">GetValues</a> <br />

			<a href="http://localhost/JiangSu/Op/SelectByPage?pageSize=10&pageIndex=1&name=">SelectByPage?pageSize=10&pageIndex=1&name=</a> <br />

			<a href="http://localhost/JiangSu/Op/SelectById?id=1">SelectById?id=1</a> <br />

			<a href="http://localhost/JiangSu/Op/DeleteByIds?ids=2,3">DeleteByIds?ids=2,3</a> <br />

			<form>
			<input id="id" name="id" value="3" /> <br />
			<input id="name" name="name" value="A" /> <br />
			<input id="json" name="json" value="{}" /> <br />

			<input type="button" value="Insert" onclick="Insert();" />
			<input type="button" value="UpdateById" onclick="UpdateById();" /><br />
			</form>
			</body>
			</html>