public static ClientOrderAccount GetClientOrderAccountByAutoID(string autoid) {
   DataTable dt=  ClientOrderAccountDAL.BaseProvider.ClientOrderAccountByAutoIDDAL(autoid);
   ClientOrderAccount model = new ClientOrderAccount();
   if (dt.Rows.Count == 1)
   {
       DataRow row = dt.Rows[0];
       model.FillData(row);
       return model;
   }
   else
       return null;
 }
        /// <summary>
        /// 获取客户订单账目列表
        /// </summary>
        public static List<ClientOrderAccount> GetClientOrderAccounts(string keyWords, string orderID, string clientID,int payType,int status,int type, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
        {
            string sqlWhere = "a.Status<>9";
            if (!string.IsNullOrEmpty(keyWords))
                sqlWhere += " and ( a.OrderID like '%" + keyWords + "%'  or  a.ClientID  like '%" + keyWords + "%' )";
            if (!string.IsNullOrEmpty(orderID))
                 sqlWhere += " and ( a.OrderID ='"+orderID+"' )";
            if (!string.IsNullOrEmpty(clientID))
                sqlWhere += " and ( a.ClientID ='" + clientID + "' )";
            if (payType>0)
                sqlWhere += " and ( a.PayType ='" + payType + "' )";
            if (type > 0)
                sqlWhere += " and ( a.Type ='" + type + "' )";
            if (status > 0)
                sqlWhere += " and ( a.Status ='" + status + "' )";
            string sqlColumn = @" * ";
            DataTable dt = CommonBusiness.GetPagerData("ClientOrderAccount a", sqlColumn, sqlWhere, "a.AutoID", pageSize, pageIndex, out totalCount, out pageCount);
            List<ClientOrderAccount> list = new List<ClientOrderAccount>();
            ClientOrderAccount model;
            foreach (DataRow item in dt.Rows)
            {
                model = new ClientOrderAccount();
                model.FillData(item);
                if (!string.IsNullOrEmpty(model.CreateUserID))
                {
                    model.CreateUser = OrganizationBusiness.GetUserByUserID(model.CreateUserID, model.ClientID);
                    if (string.IsNullOrEmpty(model.CreateUser.Name)){
                        M_Users mUser = M_UsersBusiness.GetUserDetail(model.CreateUserID);
                        model.CreateUser.Name = mUser != null ? mUser.Name : "";
                        model.CreateUser.UserID = model.CreateUserID;
                    }
                }
                if(!string.IsNullOrEmpty(model.CheckUserID))
                    model.CheckerUser=M_UsersBusiness.GetUserDetail(model.CheckUserID);
                list.Add(model);
            }

            return list;
        }