private void loadData(string table) { string strWhere = string.Empty; if (!string.IsNullOrEmpty(Request["CODE_S"])) { strWhere = strWhere + " and t1.Code like '%" + Request["CODE_S"] + "%'"; } if (!string.IsNullOrEmpty(Request["CNNAME_S"])) { strWhere = strWhere + " and t1.name like '%" + Request["CNNAME_S"] + "%'"; } if (!string.IsNullOrEmpty(Request["ENABLED_S"])) { strWhere = strWhere + " and t1.enabled='" + Request["ENABLED_S"] + "'"; } switch (table) { case "base_insplicense": case "base_inspinvoice": case "base_booksdata": case "sys_declarationcar": strWhere = string.Empty; strWhere = GetSearch(table); break; } Sql.Base_blend_web bw = new Sql.Base_blend_web(); DataTable dt = bw.LoaData(table, strWhere, "", "", ref totalProperty, Convert.ToInt32(Request["start"]), Convert.ToInt32(Request["limit"])); string json = JsonConvert.SerializeObject(dt, iso); Response.Write("{rows:" + json + ",total:" + totalProperty + "}"); Response.End(); }
public void loaddatacategory() { string strWhere = string.Empty; if (!string.IsNullOrEmpty(Request["CODE_S_category"])) { strWhere = strWhere + " and t1.code like '%" + Request["CODE_S_category"] + "%'"; } if (!string.IsNullOrEmpty(Request["CNNAME_S_category"])) { strWhere = strWhere + " and t1.name like '%" + Request["CNNAME_S_category"] + "%'"; } string table = "category"; Sql.Base_blend_web bw = new Sql.Base_blend_web(); DataTable dt = bw.LoaData(table, strWhere, "", "", ref totalProperty, Convert.ToInt32(Request["start"]), Convert.ToInt32(Request["limit"])); string json = JsonConvert.SerializeObject(dt, iso); Response.Write("{rows:" + json + ",total:" + totalProperty + "}"); Response.End(); }