{ 

                case 0://账户查看

                    sql = string.Format("select logid,rtrim(logtitle) as logtitle,SUBSTRING(AccDate,1,4)+'年'+SUBSTRING(AccDate,5,2)+'月'+SUBSTRING(AccDate,7,2)+'日' as AccDate,accamount,rtrim(logmemo) as logmemo  from LOGACCOUNT where accidin = {0}" +

                                        " union "+

                                        " select logid,rtrim(logtitle) as logtitle,SUBSTRING(AccDate,1,4)+'年'+SUBSTRING(AccDate,5,2)+'月'+SUBSTRING(AccDate,7,2)+'日' as AccDate, -accamount as accamount,rtrim(logmemo) as logmemo from LOGACCOUNT where accidout = {0}  ", ni.Id);

                    break;

 

                case 1://分类查看

                    sql = string.Format("select logid,rtrim(logtitle) as logtitle,SUBSTRING(AccDate,1,4)+'年'+SUBSTRING(AccDate,5,2)+'月'+SUBSTRING(AccDate,7,2)+'日' as AccDate,accamount,rtrim(logmemo) as logmemo from LOGACCOUNT where SortId = {0}", ni.Id);

                    break;

            

            }