/// <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));
}
}
