/// <summary> /// 保存用户查询数据 /// </summary> /// <param name="PageId"></param> /// <param name="ClientJsonString"></param> /// <returns></returns> public int SetQueryPanelData(string PageId, string ClientJsonString) { string sqlWhere = " pageid=" + DbConvert.ToSqlString(PageId) + " and userid=" + DbConvert.ToSqlString(NG3.AppInfoBase.LoginID) + " and cboo=" + DbConvert.ToSqlString(NG3.AppInfoBase.OCode); string query = DataConverterHelper.ConvertQueryString(ClientJsonString); //目前是直接删除后创建 这样的话,guid的主从明细表就查不到明细数据了 //若存在 则更新,否则 删除后创建 DataTable tmpDT = DbHelper.GetDataTable("select * from c_sys_search_def_master where " + sqlWhere); if (tmpDT.Rows.Count == 0) { DataRow dr = tmpDT.NewRow(); dr["id"] = Guid.NewGuid().ToString(); dr["pageid"] = PageId; dr["userid"] = NG3.AppInfoBase.LoginID; dr["cboo"] = NG3.AppInfoBase.OCode; dr["isdefault"] = 0; dr["ismember"] = 0; dr["remeberstr"] = ClientJsonString; dr["reembersql"] = query; tmpDT.Rows.Add(dr); return(DbHelper.Update(tmpDT, "select * from c_sys_search_def_master")); } else { tmpDT.Rows[0]["isdefault"] = 0; tmpDT.Rows[0]["ismember"] = 0; tmpDT.Rows[0]["remeberstr"] = ClientJsonString; tmpDT.Rows[0]["reembersql"] = query; return(DbHelper.Update(tmpDT, "select * from c_sys_search_def_master where " + sqlWhere)); } }