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