public string GetEmailCount(string UserId) { if (!(UserId != "0")) { return(this.GetJsonResult(0, "0")); } using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "IsDelReceive=0 and IsRead=0 and ReceiveId=" + UserId; int num1 = dbOperHandler.CountId("N_UserEmail"); dbOperHandler.Reset(); dbOperHandler.ConditionExpress = "IsRead=0 and UserId=" + UserId; int num2 = dbOperHandler.CountId("N_UserMessage"); return(this.GetJsonResult(1, string.Concat((object)(num1 + num2)))); } }
public void GetListJSON(int _thispage, int _pagesize, string _wherestr1, ref string _jsonstr) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = _wherestr1; string sql0 = SqlHelp.GetSql0(dbOperHandler.CountId("Flex_History").ToString() + " as totalcount,row_number() over (order by STime desc) as rowid,case when moneychange>0 then Convert(varchar(20),moneychange) else '---' end inmoney,case when moneychange<0 then Convert(varchar(20),moneychange) else '---' end outmoney,*", "Flex_History", "Id", _pagesize, _thispage, "desc", _wherestr1); dbOperHandler.Reset(); dbOperHandler.SqlCmd = sql0; DataTable dataTable = dbOperHandler.GetDataTable(); _jsonstr = this.ConverTableToJSON(dataTable); dataTable.Clear(); dataTable.Dispose(); } }