예제 #1
0
        public List <CompanyDatumWithUid> GetForApi(int pageSize, ref int pageIndex, string searchText, out int totalCount)
        {
            if (pageSize < 5)
            {
                pageSize = 5;
            }

            int rowsOffset = pageIndex * pageSize;

            int tmpCount = 0;

            DoReadAll($"SELECT COUNT(*) AS CUS_COUNT FROM {TABLE}",
                      (SqlDataReader reader) =>
            {
                ConvertToInt(reader["CUS_COUNT"], out tmpCount);
            });
            totalCount = tmpCount;

            string sql =
                $"SELECT * FROM {TABLE} "
                + $" WHERE {string.Join(" OR ", SEARCH_FIELDS.ConvertAll(o => $"{o} LIKE ?"))} "
                + $" ORDER BY {FIELD_NAME} OFFSET {rowsOffset} ROWS "
                + $" FETCH NEXT {pageSize} ROWS ONLY ";

            var list = new List <CompanyDatumWithUid>();

            DoReadAll(sql,
                      (SqlDataReader reader) =>
            {
                CompanyDatumWithUid item = ConvertTo(reader);
                list.Add(item);
            }, SEARCH_FIELDS.ConvertAll(o => $"%{searchText}%").ToArray());

            return(list);
        }
        public void Patch([FromBody] string value)
        {
            CompanyDatumWithUid datum = Newtonsoft.Json.JsonConvert.DeserializeObject <CompanyDatumWithUid>(value);

            GlobalInstance.DB.RecordTable.Insert("Company Update", datum);
            GlobalInstance.DB.CompanyTable.Update(datum);
        }
예제 #3
0
        public List <CompanyDatumWithUid> Get()
        {
            string sql = $"SELECT * FROM {TABLE}";

            var list = new List <CompanyDatumWithUid>();

            DoReadAll(sql,
                      (SqlDataReader reader) =>
            {
                CompanyDatumWithUid item = ConvertTo(reader);
                list.Add(item);
            });

            return(list);
        }
예제 #4
0
 public void Update(CompanyDatumWithUid datum)
 {
     DoExecuteNonQuery($"UPDATE {TABLE} SET {FIELD_NAME}=?, {FIELD_ADDRESS}=?, "
                       + $"{FIELD_TELEPHONE}=? ,{FIELD_FAX}=? ,{FIELD_REMARK}=? WHERE {FIELD_UID}=?",
                       datum.Name, datum.Address, datum.Telephone, datum.Fax, datum.Remark, datum.Uid);
 }